APPS.IGC_ETAX_UTIL_PKG dependencies on IGC_CC_HEADERS

Line 6: l_user_id igc_cc_headers.created_by%TYPE := FND_GLOBAL.user_id;

2: /* $Header: IGCETXUB.pls 120.7.12010000.2 2008/11/25 16:07:17 sasukuma ship $ */
3:
4:
5: -- Create global variables to maintain the session info
6: l_user_id igc_cc_headers.created_by%TYPE := FND_GLOBAL.user_id;
7: l_login_id igc_cc_headers.last_update_login%TYPE := FND_GLOBAL.login_id;
8: l_sysdate DATE := sysdate;
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IGC_ETAX_UTIL_PKG';

Line 7: l_login_id igc_cc_headers.last_update_login%TYPE := FND_GLOBAL.login_id;

3:
4:
5: -- Create global variables to maintain the session info
6: l_user_id igc_cc_headers.created_by%TYPE := FND_GLOBAL.user_id;
7: l_login_id igc_cc_headers.last_update_login%TYPE := FND_GLOBAL.login_id;
8: l_sysdate DATE := sysdate;
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IGC_ETAX_UTIL_PKG';
11: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;

Line 30: P_CC_Header_Rec IN igc_cc_headers%ROWTYPE,

26: G_MODULE_NAME CONSTANT VARCHAR2(64) := 'IGC.PLSQL.ICETXUB.IGC_ETAX_UTIL_PKG.';
27: G_ORG_LOC_ID HR_ALL_ORGANIZATION_UNITS.location_id%TYPE;
28:
29: FUNCTION Populate_Dist_GT(
30: P_CC_Header_Rec IN igc_cc_headers%ROWTYPE,
31: P_Line_Id IN igc_cc_acct_lines.cc_acct_line_id%type,
32: P_Calling_Mode IN VARCHAR2,
33: P_Error_Code OUT NOCOPY VARCHAR2,
34: P_Calling_Sequence IN VARCHAR2,

Line 99: P_CC_Header_Rec IN igc_cc_headers%ROWTYPE,

95: END set_tax_security_context;
96:
97:
98: FUNCTION Populate_Headers_GT(
99: P_CC_Header_Rec IN igc_cc_headers%ROWTYPE,
100: P_Calling_Mode IN VARCHAR2,
101: --P_Event_Class_Code IN VARCHAR2,
102: --P_Event_Type_Code IN VARCHAR2,
103: P_Legal_Entity_Id IN NUMBER,

Line 342: P_CC_Header_Rec IN igc_cc_headers%ROWTYPE,

338: END Populate_Headers_GT;
339:
340: /* Bug 6719456 - Added new parameter P_Line_Id */
341: FUNCTION Populate_Lines_GT(
342: P_CC_Header_Rec IN igc_cc_headers%ROWTYPE,
343: P_Line_Id IN igc_cc_acct_lines.cc_acct_line_id%type,
344: P_Calling_Mode IN VARCHAR2,
345: --P_Event_Class_Code IN VARCHAR2,
346: --P_Line_Number IN NUMBER DEFAULT NULL,

Line 537: P_CC_Header_Rec IN igc_cc_headers%ROWTYPE,

533:
534:
535: /* New function created for Bug#6719456 */
536: FUNCTION Populate_Dist_GT(
537: P_CC_Header_Rec IN igc_cc_headers%ROWTYPE,
538: P_Line_Id IN igc_cc_acct_lines.cc_acct_line_id%type,
539: P_Calling_Mode IN VARCHAR2,
540: P_Error_Code OUT NOCOPY VARCHAR2,
541: P_Calling_Sequence IN VARCHAR2,

Line 650: P_CC_Header_Rec IN igc_cc_headers%ROWTYPE,

646:
647: END Populate_Dist_GT;
648:
649: Procedure Calculate_Tax(
650: P_CC_Header_Rec IN igc_cc_headers%ROWTYPE,
651: P_Calling_Mode IN VARCHAR2,
652: P_Error_Code OUT NOCOPY VARCHAR2,
653: P_Amount IN NUMBER,
654: P_Tax_Amount OUT NOCOPY NUMBER,

Line 839: AND entity_code =IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE --'IGC_CC_HEADERS'

835: SELECT nvl(SUM(rec_nrec_tax_amt),0)
836: INTO l_tax_amount
837: FROM ZX_REC_NREC_DIST_GT
838: WHERE application_id = IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID --'8407'
839: AND entity_code =IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE --'IGC_CC_HEADERS'
840: AND event_class_code =IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE --'PURCHASE_TRANSACTION_TAX_QUOTE'
841: AND trx_id = P_CC_Header_Rec.cc_header_id
842: AND trx_line_id = p_line_id
843: AND trx_level_type = IGC_ETAX_UTIL_PKG.IGC_TRX_LEVEL_TYPE --'LINE'