APPS.PA_CC_ENC_IMPORT_FCK dependencies on PA_BC_PACKETS

Line 3: -- variable to hold a table of record for pa_bc_packets

1: package PA_CC_ENC_IMPORT_FCK AUTHID CURRENT_USER as
2: -- $Header: PACCENCS.pls 115.2 2003/04/17 22:37:50 riyengar noship $
3: -- variable to hold a table of record for pa_bc_packets
4: TYPE FC_Record IS RECORD (
5: PACKET_ID pa_bc_packets.PACKET_ID%type,
6: BC_PACKET_ID pa_bc_packets.BC_PACKET_ID%type,
7: PARENT_BC_PACKET_ID pa_bc_packets.PARENT_BC_PACKET_ID%type default Null, -- should be populated for burden rows

Line 5: PACKET_ID pa_bc_packets.PACKET_ID%type,

1: package PA_CC_ENC_IMPORT_FCK AUTHID CURRENT_USER as
2: -- $Header: PACCENCS.pls 115.2 2003/04/17 22:37:50 riyengar noship $
3: -- variable to hold a table of record for pa_bc_packets
4: TYPE FC_Record IS RECORD (
5: PACKET_ID pa_bc_packets.PACKET_ID%type,
6: BC_PACKET_ID pa_bc_packets.BC_PACKET_ID%type,
7: PARENT_BC_PACKET_ID pa_bc_packets.PARENT_BC_PACKET_ID%type default Null, -- should be populated for burden rows
8: EXT_BUDGET_TYPE varchar2(100) default 'GL', -- defaule values are 'CC' or 'GL'
9: BC_COMMITMENT_ID pa_bc_packets.BC_COMMITMENT_ID%type default Null,

Line 6: BC_PACKET_ID pa_bc_packets.BC_PACKET_ID%type,

2: -- $Header: PACCENCS.pls 115.2 2003/04/17 22:37:50 riyengar noship $
3: -- variable to hold a table of record for pa_bc_packets
4: TYPE FC_Record IS RECORD (
5: PACKET_ID pa_bc_packets.PACKET_ID%type,
6: BC_PACKET_ID pa_bc_packets.BC_PACKET_ID%type,
7: PARENT_BC_PACKET_ID pa_bc_packets.PARENT_BC_PACKET_ID%type default Null, -- should be populated for burden rows
8: EXT_BUDGET_TYPE varchar2(100) default 'GL', -- defaule values are 'CC' or 'GL'
9: BC_COMMITMENT_ID pa_bc_packets.BC_COMMITMENT_ID%type default Null,
10: PROJECT_ID pa_bc_packets.PROJECT_ID%type,

Line 7: PARENT_BC_PACKET_ID pa_bc_packets.PARENT_BC_PACKET_ID%type default Null, -- should be populated for burden rows

3: -- variable to hold a table of record for pa_bc_packets
4: TYPE FC_Record IS RECORD (
5: PACKET_ID pa_bc_packets.PACKET_ID%type,
6: BC_PACKET_ID pa_bc_packets.BC_PACKET_ID%type,
7: PARENT_BC_PACKET_ID pa_bc_packets.PARENT_BC_PACKET_ID%type default Null, -- should be populated for burden rows
8: EXT_BUDGET_TYPE varchar2(100) default 'GL', -- defaule values are 'CC' or 'GL'
9: BC_COMMITMENT_ID pa_bc_packets.BC_COMMITMENT_ID%type default Null,
10: PROJECT_ID pa_bc_packets.PROJECT_ID%type,
11: TASK_ID pa_bc_packets.TASK_ID%type,

Line 9: BC_COMMITMENT_ID pa_bc_packets.BC_COMMITMENT_ID%type default Null,

5: PACKET_ID pa_bc_packets.PACKET_ID%type,
6: BC_PACKET_ID pa_bc_packets.BC_PACKET_ID%type,
7: PARENT_BC_PACKET_ID pa_bc_packets.PARENT_BC_PACKET_ID%type default Null, -- should be populated for burden rows
8: EXT_BUDGET_TYPE varchar2(100) default 'GL', -- defaule values are 'CC' or 'GL'
9: BC_COMMITMENT_ID pa_bc_packets.BC_COMMITMENT_ID%type default Null,
10: PROJECT_ID pa_bc_packets.PROJECT_ID%type,
11: TASK_ID pa_bc_packets.TASK_ID%type,
12: EXPENDITURE_TYPE pa_bc_packets.EXPENDITURE_TYPE%type,
13: EXPENDITURE_ITEM_DATE pa_bc_packets.EXPENDITURE_ITEM_DATE%type,

Line 10: PROJECT_ID pa_bc_packets.PROJECT_ID%type,

6: BC_PACKET_ID pa_bc_packets.BC_PACKET_ID%type,
7: PARENT_BC_PACKET_ID pa_bc_packets.PARENT_BC_PACKET_ID%type default Null, -- should be populated for burden rows
8: EXT_BUDGET_TYPE varchar2(100) default 'GL', -- defaule values are 'CC' or 'GL'
9: BC_COMMITMENT_ID pa_bc_packets.BC_COMMITMENT_ID%type default Null,
10: PROJECT_ID pa_bc_packets.PROJECT_ID%type,
11: TASK_ID pa_bc_packets.TASK_ID%type,
12: EXPENDITURE_TYPE pa_bc_packets.EXPENDITURE_TYPE%type,
13: EXPENDITURE_ITEM_DATE pa_bc_packets.EXPENDITURE_ITEM_DATE%type,
14: SET_OF_BOOKS_ID pa_bc_packets.SET_OF_BOOKS_ID%type,

Line 11: TASK_ID pa_bc_packets.TASK_ID%type,

7: PARENT_BC_PACKET_ID pa_bc_packets.PARENT_BC_PACKET_ID%type default Null, -- should be populated for burden rows
8: EXT_BUDGET_TYPE varchar2(100) default 'GL', -- defaule values are 'CC' or 'GL'
9: BC_COMMITMENT_ID pa_bc_packets.BC_COMMITMENT_ID%type default Null,
10: PROJECT_ID pa_bc_packets.PROJECT_ID%type,
11: TASK_ID pa_bc_packets.TASK_ID%type,
12: EXPENDITURE_TYPE pa_bc_packets.EXPENDITURE_TYPE%type,
13: EXPENDITURE_ITEM_DATE pa_bc_packets.EXPENDITURE_ITEM_DATE%type,
14: SET_OF_BOOKS_ID pa_bc_packets.SET_OF_BOOKS_ID%type,
15: JE_CATEGORY_NAME pa_bc_packets.JE_CATEGORY_NAME%type,

Line 12: EXPENDITURE_TYPE pa_bc_packets.EXPENDITURE_TYPE%type,

8: EXT_BUDGET_TYPE varchar2(100) default 'GL', -- defaule values are 'CC' or 'GL'
9: BC_COMMITMENT_ID pa_bc_packets.BC_COMMITMENT_ID%type default Null,
10: PROJECT_ID pa_bc_packets.PROJECT_ID%type,
11: TASK_ID pa_bc_packets.TASK_ID%type,
12: EXPENDITURE_TYPE pa_bc_packets.EXPENDITURE_TYPE%type,
13: EXPENDITURE_ITEM_DATE pa_bc_packets.EXPENDITURE_ITEM_DATE%type,
14: SET_OF_BOOKS_ID pa_bc_packets.SET_OF_BOOKS_ID%type,
15: JE_CATEGORY_NAME pa_bc_packets.JE_CATEGORY_NAME%type,
16: JE_SOURCE_NAME pa_bc_packets.JE_SOURCE_NAME%type,

Line 13: EXPENDITURE_ITEM_DATE pa_bc_packets.EXPENDITURE_ITEM_DATE%type,

9: BC_COMMITMENT_ID pa_bc_packets.BC_COMMITMENT_ID%type default Null,
10: PROJECT_ID pa_bc_packets.PROJECT_ID%type,
11: TASK_ID pa_bc_packets.TASK_ID%type,
12: EXPENDITURE_TYPE pa_bc_packets.EXPENDITURE_TYPE%type,
13: EXPENDITURE_ITEM_DATE pa_bc_packets.EXPENDITURE_ITEM_DATE%type,
14: SET_OF_BOOKS_ID pa_bc_packets.SET_OF_BOOKS_ID%type,
15: JE_CATEGORY_NAME pa_bc_packets.JE_CATEGORY_NAME%type,
16: JE_SOURCE_NAME pa_bc_packets.JE_SOURCE_NAME%type,
17: STATUS_CODE pa_bc_packets.STATUS_CODE%type default 'P', -- P pending

Line 14: SET_OF_BOOKS_ID pa_bc_packets.SET_OF_BOOKS_ID%type,

10: PROJECT_ID pa_bc_packets.PROJECT_ID%type,
11: TASK_ID pa_bc_packets.TASK_ID%type,
12: EXPENDITURE_TYPE pa_bc_packets.EXPENDITURE_TYPE%type,
13: EXPENDITURE_ITEM_DATE pa_bc_packets.EXPENDITURE_ITEM_DATE%type,
14: SET_OF_BOOKS_ID pa_bc_packets.SET_OF_BOOKS_ID%type,
15: JE_CATEGORY_NAME pa_bc_packets.JE_CATEGORY_NAME%type,
16: JE_SOURCE_NAME pa_bc_packets.JE_SOURCE_NAME%type,
17: STATUS_CODE pa_bc_packets.STATUS_CODE%type default 'P', -- P pending
18: DOCUMENT_TYPE pa_bc_packets.DOCUMENT_TYPE%type,

Line 15: JE_CATEGORY_NAME pa_bc_packets.JE_CATEGORY_NAME%type,

11: TASK_ID pa_bc_packets.TASK_ID%type,
12: EXPENDITURE_TYPE pa_bc_packets.EXPENDITURE_TYPE%type,
13: EXPENDITURE_ITEM_DATE pa_bc_packets.EXPENDITURE_ITEM_DATE%type,
14: SET_OF_BOOKS_ID pa_bc_packets.SET_OF_BOOKS_ID%type,
15: JE_CATEGORY_NAME pa_bc_packets.JE_CATEGORY_NAME%type,
16: JE_SOURCE_NAME pa_bc_packets.JE_SOURCE_NAME%type,
17: STATUS_CODE pa_bc_packets.STATUS_CODE%type default 'P', -- P pending
18: DOCUMENT_TYPE pa_bc_packets.DOCUMENT_TYPE%type,
19: FUNDS_PROCESS_MODE pa_bc_packets.FUNDS_PROCESS_MODE%type default 'T',

Line 16: JE_SOURCE_NAME pa_bc_packets.JE_SOURCE_NAME%type,

12: EXPENDITURE_TYPE pa_bc_packets.EXPENDITURE_TYPE%type,
13: EXPENDITURE_ITEM_DATE pa_bc_packets.EXPENDITURE_ITEM_DATE%type,
14: SET_OF_BOOKS_ID pa_bc_packets.SET_OF_BOOKS_ID%type,
15: JE_CATEGORY_NAME pa_bc_packets.JE_CATEGORY_NAME%type,
16: JE_SOURCE_NAME pa_bc_packets.JE_SOURCE_NAME%type,
17: STATUS_CODE pa_bc_packets.STATUS_CODE%type default 'P', -- P pending
18: DOCUMENT_TYPE pa_bc_packets.DOCUMENT_TYPE%type,
19: FUNDS_PROCESS_MODE pa_bc_packets.FUNDS_PROCESS_MODE%type default 'T',
20: EXPENDITURE_ORGANIZATION_ID pa_bc_packets.EXPENDITURE_ORGANIZATION_ID%type,

Line 17: STATUS_CODE pa_bc_packets.STATUS_CODE%type default 'P', -- P pending

13: EXPENDITURE_ITEM_DATE pa_bc_packets.EXPENDITURE_ITEM_DATE%type,
14: SET_OF_BOOKS_ID pa_bc_packets.SET_OF_BOOKS_ID%type,
15: JE_CATEGORY_NAME pa_bc_packets.JE_CATEGORY_NAME%type,
16: JE_SOURCE_NAME pa_bc_packets.JE_SOURCE_NAME%type,
17: STATUS_CODE pa_bc_packets.STATUS_CODE%type default 'P', -- P pending
18: DOCUMENT_TYPE pa_bc_packets.DOCUMENT_TYPE%type,
19: FUNDS_PROCESS_MODE pa_bc_packets.FUNDS_PROCESS_MODE%type default 'T',
20: EXPENDITURE_ORGANIZATION_ID pa_bc_packets.EXPENDITURE_ORGANIZATION_ID%type,
21: DOCUMENT_HEADER_ID pa_bc_packets.DOCUMENT_HEADER_ID%type,

Line 18: DOCUMENT_TYPE pa_bc_packets.DOCUMENT_TYPE%type,

14: SET_OF_BOOKS_ID pa_bc_packets.SET_OF_BOOKS_ID%type,
15: JE_CATEGORY_NAME pa_bc_packets.JE_CATEGORY_NAME%type,
16: JE_SOURCE_NAME pa_bc_packets.JE_SOURCE_NAME%type,
17: STATUS_CODE pa_bc_packets.STATUS_CODE%type default 'P', -- P pending
18: DOCUMENT_TYPE pa_bc_packets.DOCUMENT_TYPE%type,
19: FUNDS_PROCESS_MODE pa_bc_packets.FUNDS_PROCESS_MODE%type default 'T',
20: EXPENDITURE_ORGANIZATION_ID pa_bc_packets.EXPENDITURE_ORGANIZATION_ID%type,
21: DOCUMENT_HEADER_ID pa_bc_packets.DOCUMENT_HEADER_ID%type,
22: DOCUMENT_DISTRIBUTION_ID pa_bc_packets.DOCUMENT_DISTRIBUTION_ID%type,

Line 19: FUNDS_PROCESS_MODE pa_bc_packets.FUNDS_PROCESS_MODE%type default 'T',

15: JE_CATEGORY_NAME pa_bc_packets.JE_CATEGORY_NAME%type,
16: JE_SOURCE_NAME pa_bc_packets.JE_SOURCE_NAME%type,
17: STATUS_CODE pa_bc_packets.STATUS_CODE%type default 'P', -- P pending
18: DOCUMENT_TYPE pa_bc_packets.DOCUMENT_TYPE%type,
19: FUNDS_PROCESS_MODE pa_bc_packets.FUNDS_PROCESS_MODE%type default 'T',
20: EXPENDITURE_ORGANIZATION_ID pa_bc_packets.EXPENDITURE_ORGANIZATION_ID%type,
21: DOCUMENT_HEADER_ID pa_bc_packets.DOCUMENT_HEADER_ID%type,
22: DOCUMENT_DISTRIBUTION_ID pa_bc_packets.DOCUMENT_DISTRIBUTION_ID%type,
23: BUDGET_VERSION_ID pa_bc_packets.BUDGET_VERSION_ID%type default Null,

Line 20: EXPENDITURE_ORGANIZATION_ID pa_bc_packets.EXPENDITURE_ORGANIZATION_ID%type,

16: JE_SOURCE_NAME pa_bc_packets.JE_SOURCE_NAME%type,
17: STATUS_CODE pa_bc_packets.STATUS_CODE%type default 'P', -- P pending
18: DOCUMENT_TYPE pa_bc_packets.DOCUMENT_TYPE%type,
19: FUNDS_PROCESS_MODE pa_bc_packets.FUNDS_PROCESS_MODE%type default 'T',
20: EXPENDITURE_ORGANIZATION_ID pa_bc_packets.EXPENDITURE_ORGANIZATION_ID%type,
21: DOCUMENT_HEADER_ID pa_bc_packets.DOCUMENT_HEADER_ID%type,
22: DOCUMENT_DISTRIBUTION_ID pa_bc_packets.DOCUMENT_DISTRIBUTION_ID%type,
23: BUDGET_VERSION_ID pa_bc_packets.BUDGET_VERSION_ID%type default Null,
24: BURDEN_COST_FLAG pa_bc_packets.BURDEN_COST_FLAG%type default 'N',

Line 21: DOCUMENT_HEADER_ID pa_bc_packets.DOCUMENT_HEADER_ID%type,

17: STATUS_CODE pa_bc_packets.STATUS_CODE%type default 'P', -- P pending
18: DOCUMENT_TYPE pa_bc_packets.DOCUMENT_TYPE%type,
19: FUNDS_PROCESS_MODE pa_bc_packets.FUNDS_PROCESS_MODE%type default 'T',
20: EXPENDITURE_ORGANIZATION_ID pa_bc_packets.EXPENDITURE_ORGANIZATION_ID%type,
21: DOCUMENT_HEADER_ID pa_bc_packets.DOCUMENT_HEADER_ID%type,
22: DOCUMENT_DISTRIBUTION_ID pa_bc_packets.DOCUMENT_DISTRIBUTION_ID%type,
23: BUDGET_VERSION_ID pa_bc_packets.BUDGET_VERSION_ID%type default Null,
24: BURDEN_COST_FLAG pa_bc_packets.BURDEN_COST_FLAG%type default 'N',
25: BALANCE_POSTED_FLAG pa_bc_packets.BALANCE_POSTED_FLAG%type default 'N',

Line 22: DOCUMENT_DISTRIBUTION_ID pa_bc_packets.DOCUMENT_DISTRIBUTION_ID%type,

18: DOCUMENT_TYPE pa_bc_packets.DOCUMENT_TYPE%type,
19: FUNDS_PROCESS_MODE pa_bc_packets.FUNDS_PROCESS_MODE%type default 'T',
20: EXPENDITURE_ORGANIZATION_ID pa_bc_packets.EXPENDITURE_ORGANIZATION_ID%type,
21: DOCUMENT_HEADER_ID pa_bc_packets.DOCUMENT_HEADER_ID%type,
22: DOCUMENT_DISTRIBUTION_ID pa_bc_packets.DOCUMENT_DISTRIBUTION_ID%type,
23: BUDGET_VERSION_ID pa_bc_packets.BUDGET_VERSION_ID%type default Null,
24: BURDEN_COST_FLAG pa_bc_packets.BURDEN_COST_FLAG%type default 'N',
25: BALANCE_POSTED_FLAG pa_bc_packets.BALANCE_POSTED_FLAG%type default 'N',
26: ACTUAL_FLAG pa_bc_packets.ACTUAL_FLAG%type default 'E', -- 'A' for Actual , 'E' for Encumbrance

Line 23: BUDGET_VERSION_ID pa_bc_packets.BUDGET_VERSION_ID%type default Null,

19: FUNDS_PROCESS_MODE pa_bc_packets.FUNDS_PROCESS_MODE%type default 'T',
20: EXPENDITURE_ORGANIZATION_ID pa_bc_packets.EXPENDITURE_ORGANIZATION_ID%type,
21: DOCUMENT_HEADER_ID pa_bc_packets.DOCUMENT_HEADER_ID%type,
22: DOCUMENT_DISTRIBUTION_ID pa_bc_packets.DOCUMENT_DISTRIBUTION_ID%type,
23: BUDGET_VERSION_ID pa_bc_packets.BUDGET_VERSION_ID%type default Null,
24: BURDEN_COST_FLAG pa_bc_packets.BURDEN_COST_FLAG%type default 'N',
25: BALANCE_POSTED_FLAG pa_bc_packets.BALANCE_POSTED_FLAG%type default 'N',
26: ACTUAL_FLAG pa_bc_packets.ACTUAL_FLAG%type default 'E', -- 'A' for Actual , 'E' for Encumbrance
27: GL_DATE pa_bc_packets.GL_DATE%type default Null,

Line 24: BURDEN_COST_FLAG pa_bc_packets.BURDEN_COST_FLAG%type default 'N',

20: EXPENDITURE_ORGANIZATION_ID pa_bc_packets.EXPENDITURE_ORGANIZATION_ID%type,
21: DOCUMENT_HEADER_ID pa_bc_packets.DOCUMENT_HEADER_ID%type,
22: DOCUMENT_DISTRIBUTION_ID pa_bc_packets.DOCUMENT_DISTRIBUTION_ID%type,
23: BUDGET_VERSION_ID pa_bc_packets.BUDGET_VERSION_ID%type default Null,
24: BURDEN_COST_FLAG pa_bc_packets.BURDEN_COST_FLAG%type default 'N',
25: BALANCE_POSTED_FLAG pa_bc_packets.BALANCE_POSTED_FLAG%type default 'N',
26: ACTUAL_FLAG pa_bc_packets.ACTUAL_FLAG%type default 'E', -- 'A' for Actual , 'E' for Encumbrance
27: GL_DATE pa_bc_packets.GL_DATE%type default Null,
28: PERIOD_NAME pa_bc_packets.PERIOD_NAME%type, -- must be populated

Line 25: BALANCE_POSTED_FLAG pa_bc_packets.BALANCE_POSTED_FLAG%type default 'N',

21: DOCUMENT_HEADER_ID pa_bc_packets.DOCUMENT_HEADER_ID%type,
22: DOCUMENT_DISTRIBUTION_ID pa_bc_packets.DOCUMENT_DISTRIBUTION_ID%type,
23: BUDGET_VERSION_ID pa_bc_packets.BUDGET_VERSION_ID%type default Null,
24: BURDEN_COST_FLAG pa_bc_packets.BURDEN_COST_FLAG%type default 'N',
25: BALANCE_POSTED_FLAG pa_bc_packets.BALANCE_POSTED_FLAG%type default 'N',
26: ACTUAL_FLAG pa_bc_packets.ACTUAL_FLAG%type default 'E', -- 'A' for Actual , 'E' for Encumbrance
27: GL_DATE pa_bc_packets.GL_DATE%type default Null,
28: PERIOD_NAME pa_bc_packets.PERIOD_NAME%type, -- must be populated
29: PERIOD_YEAR pa_bc_packets.PERIOD_YEAR%type,

Line 26: ACTUAL_FLAG pa_bc_packets.ACTUAL_FLAG%type default 'E', -- 'A' for Actual , 'E' for Encumbrance

22: DOCUMENT_DISTRIBUTION_ID pa_bc_packets.DOCUMENT_DISTRIBUTION_ID%type,
23: BUDGET_VERSION_ID pa_bc_packets.BUDGET_VERSION_ID%type default Null,
24: BURDEN_COST_FLAG pa_bc_packets.BURDEN_COST_FLAG%type default 'N',
25: BALANCE_POSTED_FLAG pa_bc_packets.BALANCE_POSTED_FLAG%type default 'N',
26: ACTUAL_FLAG pa_bc_packets.ACTUAL_FLAG%type default 'E', -- 'A' for Actual , 'E' for Encumbrance
27: GL_DATE pa_bc_packets.GL_DATE%type default Null,
28: PERIOD_NAME pa_bc_packets.PERIOD_NAME%type, -- must be populated
29: PERIOD_YEAR pa_bc_packets.PERIOD_YEAR%type,
30: PERIOD_NUM pa_bc_packets.PERIOD_NUM%type,

Line 27: GL_DATE pa_bc_packets.GL_DATE%type default Null,

23: BUDGET_VERSION_ID pa_bc_packets.BUDGET_VERSION_ID%type default Null,
24: BURDEN_COST_FLAG pa_bc_packets.BURDEN_COST_FLAG%type default 'N',
25: BALANCE_POSTED_FLAG pa_bc_packets.BALANCE_POSTED_FLAG%type default 'N',
26: ACTUAL_FLAG pa_bc_packets.ACTUAL_FLAG%type default 'E', -- 'A' for Actual , 'E' for Encumbrance
27: GL_DATE pa_bc_packets.GL_DATE%type default Null,
28: PERIOD_NAME pa_bc_packets.PERIOD_NAME%type, -- must be populated
29: PERIOD_YEAR pa_bc_packets.PERIOD_YEAR%type,
30: PERIOD_NUM pa_bc_packets.PERIOD_NUM%type,
31: ENCUMBRANCE_TYPE_ID pa_bc_packets.ENCUMBRANCE_TYPE_ID%type, -- must be populated

Line 28: PERIOD_NAME pa_bc_packets.PERIOD_NAME%type, -- must be populated

24: BURDEN_COST_FLAG pa_bc_packets.BURDEN_COST_FLAG%type default 'N',
25: BALANCE_POSTED_FLAG pa_bc_packets.BALANCE_POSTED_FLAG%type default 'N',
26: ACTUAL_FLAG pa_bc_packets.ACTUAL_FLAG%type default 'E', -- 'A' for Actual , 'E' for Encumbrance
27: GL_DATE pa_bc_packets.GL_DATE%type default Null,
28: PERIOD_NAME pa_bc_packets.PERIOD_NAME%type, -- must be populated
29: PERIOD_YEAR pa_bc_packets.PERIOD_YEAR%type,
30: PERIOD_NUM pa_bc_packets.PERIOD_NUM%type,
31: ENCUMBRANCE_TYPE_ID pa_bc_packets.ENCUMBRANCE_TYPE_ID%type, -- must be populated
32: PROJ_ENCUMBRANCE_TYPE_ID pa_bc_packets.PROJ_ENCUMBRANCE_TYPE_ID%type default Null,

Line 29: PERIOD_YEAR pa_bc_packets.PERIOD_YEAR%type,

25: BALANCE_POSTED_FLAG pa_bc_packets.BALANCE_POSTED_FLAG%type default 'N',
26: ACTUAL_FLAG pa_bc_packets.ACTUAL_FLAG%type default 'E', -- 'A' for Actual , 'E' for Encumbrance
27: GL_DATE pa_bc_packets.GL_DATE%type default Null,
28: PERIOD_NAME pa_bc_packets.PERIOD_NAME%type, -- must be populated
29: PERIOD_YEAR pa_bc_packets.PERIOD_YEAR%type,
30: PERIOD_NUM pa_bc_packets.PERIOD_NUM%type,
31: ENCUMBRANCE_TYPE_ID pa_bc_packets.ENCUMBRANCE_TYPE_ID%type, -- must be populated
32: PROJ_ENCUMBRANCE_TYPE_ID pa_bc_packets.PROJ_ENCUMBRANCE_TYPE_ID%type default Null,
33: TOP_TASK_ID pa_bc_packets.TOP_TASK_ID%type default null,

Line 30: PERIOD_NUM pa_bc_packets.PERIOD_NUM%type,

26: ACTUAL_FLAG pa_bc_packets.ACTUAL_FLAG%type default 'E', -- 'A' for Actual , 'E' for Encumbrance
27: GL_DATE pa_bc_packets.GL_DATE%type default Null,
28: PERIOD_NAME pa_bc_packets.PERIOD_NAME%type, -- must be populated
29: PERIOD_YEAR pa_bc_packets.PERIOD_YEAR%type,
30: PERIOD_NUM pa_bc_packets.PERIOD_NUM%type,
31: ENCUMBRANCE_TYPE_ID pa_bc_packets.ENCUMBRANCE_TYPE_ID%type, -- must be populated
32: PROJ_ENCUMBRANCE_TYPE_ID pa_bc_packets.PROJ_ENCUMBRANCE_TYPE_ID%type default Null,
33: TOP_TASK_ID pa_bc_packets.TOP_TASK_ID%type default null,
34: PARENT_RESOURCE_ID pa_bc_packets.PARENT_RESOURCE_ID%type default null,

Line 31: ENCUMBRANCE_TYPE_ID pa_bc_packets.ENCUMBRANCE_TYPE_ID%type, -- must be populated

27: GL_DATE pa_bc_packets.GL_DATE%type default Null,
28: PERIOD_NAME pa_bc_packets.PERIOD_NAME%type, -- must be populated
29: PERIOD_YEAR pa_bc_packets.PERIOD_YEAR%type,
30: PERIOD_NUM pa_bc_packets.PERIOD_NUM%type,
31: ENCUMBRANCE_TYPE_ID pa_bc_packets.ENCUMBRANCE_TYPE_ID%type, -- must be populated
32: PROJ_ENCUMBRANCE_TYPE_ID pa_bc_packets.PROJ_ENCUMBRANCE_TYPE_ID%type default Null,
33: TOP_TASK_ID pa_bc_packets.TOP_TASK_ID%type default null,
34: PARENT_RESOURCE_ID pa_bc_packets.PARENT_RESOURCE_ID%type default null,
35: RESOURCE_LIST_MEMBER_ID pa_bc_packets.RESOURCE_LIST_MEMBER_ID%type default null,

Line 32: PROJ_ENCUMBRANCE_TYPE_ID pa_bc_packets.PROJ_ENCUMBRANCE_TYPE_ID%type default Null,

28: PERIOD_NAME pa_bc_packets.PERIOD_NAME%type, -- must be populated
29: PERIOD_YEAR pa_bc_packets.PERIOD_YEAR%type,
30: PERIOD_NUM pa_bc_packets.PERIOD_NUM%type,
31: ENCUMBRANCE_TYPE_ID pa_bc_packets.ENCUMBRANCE_TYPE_ID%type, -- must be populated
32: PROJ_ENCUMBRANCE_TYPE_ID pa_bc_packets.PROJ_ENCUMBRANCE_TYPE_ID%type default Null,
33: TOP_TASK_ID pa_bc_packets.TOP_TASK_ID%type default null,
34: PARENT_RESOURCE_ID pa_bc_packets.PARENT_RESOURCE_ID%type default null,
35: RESOURCE_LIST_MEMBER_ID pa_bc_packets.RESOURCE_LIST_MEMBER_ID%type default null,
36: ENTERED_DR pa_bc_packets.ENTERED_DR%type,

Line 33: TOP_TASK_ID pa_bc_packets.TOP_TASK_ID%type default null,

29: PERIOD_YEAR pa_bc_packets.PERIOD_YEAR%type,
30: PERIOD_NUM pa_bc_packets.PERIOD_NUM%type,
31: ENCUMBRANCE_TYPE_ID pa_bc_packets.ENCUMBRANCE_TYPE_ID%type, -- must be populated
32: PROJ_ENCUMBRANCE_TYPE_ID pa_bc_packets.PROJ_ENCUMBRANCE_TYPE_ID%type default Null,
33: TOP_TASK_ID pa_bc_packets.TOP_TASK_ID%type default null,
34: PARENT_RESOURCE_ID pa_bc_packets.PARENT_RESOURCE_ID%type default null,
35: RESOURCE_LIST_MEMBER_ID pa_bc_packets.RESOURCE_LIST_MEMBER_ID%type default null,
36: ENTERED_DR pa_bc_packets.ENTERED_DR%type,
37: ENTERED_CR pa_bc_packets.ENTERED_CR%type,

Line 34: PARENT_RESOURCE_ID pa_bc_packets.PARENT_RESOURCE_ID%type default null,

30: PERIOD_NUM pa_bc_packets.PERIOD_NUM%type,
31: ENCUMBRANCE_TYPE_ID pa_bc_packets.ENCUMBRANCE_TYPE_ID%type, -- must be populated
32: PROJ_ENCUMBRANCE_TYPE_ID pa_bc_packets.PROJ_ENCUMBRANCE_TYPE_ID%type default Null,
33: TOP_TASK_ID pa_bc_packets.TOP_TASK_ID%type default null,
34: PARENT_RESOURCE_ID pa_bc_packets.PARENT_RESOURCE_ID%type default null,
35: RESOURCE_LIST_MEMBER_ID pa_bc_packets.RESOURCE_LIST_MEMBER_ID%type default null,
36: ENTERED_DR pa_bc_packets.ENTERED_DR%type,
37: ENTERED_CR pa_bc_packets.ENTERED_CR%type,
38: ACCOUNTED_DR pa_bc_packets.ACCOUNTED_DR%type,

Line 35: RESOURCE_LIST_MEMBER_ID pa_bc_packets.RESOURCE_LIST_MEMBER_ID%type default null,

31: ENCUMBRANCE_TYPE_ID pa_bc_packets.ENCUMBRANCE_TYPE_ID%type, -- must be populated
32: PROJ_ENCUMBRANCE_TYPE_ID pa_bc_packets.PROJ_ENCUMBRANCE_TYPE_ID%type default Null,
33: TOP_TASK_ID pa_bc_packets.TOP_TASK_ID%type default null,
34: PARENT_RESOURCE_ID pa_bc_packets.PARENT_RESOURCE_ID%type default null,
35: RESOURCE_LIST_MEMBER_ID pa_bc_packets.RESOURCE_LIST_MEMBER_ID%type default null,
36: ENTERED_DR pa_bc_packets.ENTERED_DR%type,
37: ENTERED_CR pa_bc_packets.ENTERED_CR%type,
38: ACCOUNTED_DR pa_bc_packets.ACCOUNTED_DR%type,
39: ACCOUNTED_CR pa_bc_packets.ACCOUNTED_CR%type,

Line 36: ENTERED_DR pa_bc_packets.ENTERED_DR%type,

32: PROJ_ENCUMBRANCE_TYPE_ID pa_bc_packets.PROJ_ENCUMBRANCE_TYPE_ID%type default Null,
33: TOP_TASK_ID pa_bc_packets.TOP_TASK_ID%type default null,
34: PARENT_RESOURCE_ID pa_bc_packets.PARENT_RESOURCE_ID%type default null,
35: RESOURCE_LIST_MEMBER_ID pa_bc_packets.RESOURCE_LIST_MEMBER_ID%type default null,
36: ENTERED_DR pa_bc_packets.ENTERED_DR%type,
37: ENTERED_CR pa_bc_packets.ENTERED_CR%type,
38: ACCOUNTED_DR pa_bc_packets.ACCOUNTED_DR%type,
39: ACCOUNTED_CR pa_bc_packets.ACCOUNTED_CR%type,
40: RESULT_CODE pa_bc_packets.RESULT_CODE%type default null,

Line 37: ENTERED_CR pa_bc_packets.ENTERED_CR%type,

33: TOP_TASK_ID pa_bc_packets.TOP_TASK_ID%type default null,
34: PARENT_RESOURCE_ID pa_bc_packets.PARENT_RESOURCE_ID%type default null,
35: RESOURCE_LIST_MEMBER_ID pa_bc_packets.RESOURCE_LIST_MEMBER_ID%type default null,
36: ENTERED_DR pa_bc_packets.ENTERED_DR%type,
37: ENTERED_CR pa_bc_packets.ENTERED_CR%type,
38: ACCOUNTED_DR pa_bc_packets.ACCOUNTED_DR%type,
39: ACCOUNTED_CR pa_bc_packets.ACCOUNTED_CR%type,
40: RESULT_CODE pa_bc_packets.RESULT_CODE%type default null,
41: OLD_BUDGET_CCID pa_bc_packets.OLD_BUDGET_CCID%type default null,

Line 38: ACCOUNTED_DR pa_bc_packets.ACCOUNTED_DR%type,

34: PARENT_RESOURCE_ID pa_bc_packets.PARENT_RESOURCE_ID%type default null,
35: RESOURCE_LIST_MEMBER_ID pa_bc_packets.RESOURCE_LIST_MEMBER_ID%type default null,
36: ENTERED_DR pa_bc_packets.ENTERED_DR%type,
37: ENTERED_CR pa_bc_packets.ENTERED_CR%type,
38: ACCOUNTED_DR pa_bc_packets.ACCOUNTED_DR%type,
39: ACCOUNTED_CR pa_bc_packets.ACCOUNTED_CR%type,
40: RESULT_CODE pa_bc_packets.RESULT_CODE%type default null,
41: OLD_BUDGET_CCID pa_bc_packets.OLD_BUDGET_CCID%type default null,
42: TXN_CCID pa_bc_packets.TXN_CCID%type, -- it should be populated with code combinationid

Line 39: ACCOUNTED_CR pa_bc_packets.ACCOUNTED_CR%type,

35: RESOURCE_LIST_MEMBER_ID pa_bc_packets.RESOURCE_LIST_MEMBER_ID%type default null,
36: ENTERED_DR pa_bc_packets.ENTERED_DR%type,
37: ENTERED_CR pa_bc_packets.ENTERED_CR%type,
38: ACCOUNTED_DR pa_bc_packets.ACCOUNTED_DR%type,
39: ACCOUNTED_CR pa_bc_packets.ACCOUNTED_CR%type,
40: RESULT_CODE pa_bc_packets.RESULT_CODE%type default null,
41: OLD_BUDGET_CCID pa_bc_packets.OLD_BUDGET_CCID%type default null,
42: TXN_CCID pa_bc_packets.TXN_CCID%type, -- it should be populated with code combinationid
43: ORG_ID pa_bc_packets.ORG_ID%type, -- it shoudl be populated

Line 40: RESULT_CODE pa_bc_packets.RESULT_CODE%type default null,

36: ENTERED_DR pa_bc_packets.ENTERED_DR%type,
37: ENTERED_CR pa_bc_packets.ENTERED_CR%type,
38: ACCOUNTED_DR pa_bc_packets.ACCOUNTED_DR%type,
39: ACCOUNTED_CR pa_bc_packets.ACCOUNTED_CR%type,
40: RESULT_CODE pa_bc_packets.RESULT_CODE%type default null,
41: OLD_BUDGET_CCID pa_bc_packets.OLD_BUDGET_CCID%type default null,
42: TXN_CCID pa_bc_packets.TXN_CCID%type, -- it should be populated with code combinationid
43: ORG_ID pa_bc_packets.ORG_ID%type, -- it shoudl be populated
44: LAST_UPDATE_DATE pa_bc_packets.LAST_UPDATE_DATE%type, -- standard who columns

Line 41: OLD_BUDGET_CCID pa_bc_packets.OLD_BUDGET_CCID%type default null,

37: ENTERED_CR pa_bc_packets.ENTERED_CR%type,
38: ACCOUNTED_DR pa_bc_packets.ACCOUNTED_DR%type,
39: ACCOUNTED_CR pa_bc_packets.ACCOUNTED_CR%type,
40: RESULT_CODE pa_bc_packets.RESULT_CODE%type default null,
41: OLD_BUDGET_CCID pa_bc_packets.OLD_BUDGET_CCID%type default null,
42: TXN_CCID pa_bc_packets.TXN_CCID%type, -- it should be populated with code combinationid
43: ORG_ID pa_bc_packets.ORG_ID%type, -- it shoudl be populated
44: LAST_UPDATE_DATE pa_bc_packets.LAST_UPDATE_DATE%type, -- standard who columns
45: LAST_UPDATED_BY pa_bc_packets.LAST_UPDATED_BY%type, -- standard who columns

Line 42: TXN_CCID pa_bc_packets.TXN_CCID%type, -- it should be populated with code combinationid

38: ACCOUNTED_DR pa_bc_packets.ACCOUNTED_DR%type,
39: ACCOUNTED_CR pa_bc_packets.ACCOUNTED_CR%type,
40: RESULT_CODE pa_bc_packets.RESULT_CODE%type default null,
41: OLD_BUDGET_CCID pa_bc_packets.OLD_BUDGET_CCID%type default null,
42: TXN_CCID pa_bc_packets.TXN_CCID%type, -- it should be populated with code combinationid
43: ORG_ID pa_bc_packets.ORG_ID%type, -- it shoudl be populated
44: LAST_UPDATE_DATE pa_bc_packets.LAST_UPDATE_DATE%type, -- standard who columns
45: LAST_UPDATED_BY pa_bc_packets.LAST_UPDATED_BY%type, -- standard who columns
46: CREATED_BY pa_bc_packets.CREATED_BY%type, -- standard who columns

Line 43: ORG_ID pa_bc_packets.ORG_ID%type, -- it shoudl be populated

39: ACCOUNTED_CR pa_bc_packets.ACCOUNTED_CR%type,
40: RESULT_CODE pa_bc_packets.RESULT_CODE%type default null,
41: OLD_BUDGET_CCID pa_bc_packets.OLD_BUDGET_CCID%type default null,
42: TXN_CCID pa_bc_packets.TXN_CCID%type, -- it should be populated with code combinationid
43: ORG_ID pa_bc_packets.ORG_ID%type, -- it shoudl be populated
44: LAST_UPDATE_DATE pa_bc_packets.LAST_UPDATE_DATE%type, -- standard who columns
45: LAST_UPDATED_BY pa_bc_packets.LAST_UPDATED_BY%type, -- standard who columns
46: CREATED_BY pa_bc_packets.CREATED_BY%type, -- standard who columns
47: CREATION_DATE pa_bc_packets.CREATION_DATE%type, -- standard who columns

Line 44: LAST_UPDATE_DATE pa_bc_packets.LAST_UPDATE_DATE%type, -- standard who columns

40: RESULT_CODE pa_bc_packets.RESULT_CODE%type default null,
41: OLD_BUDGET_CCID pa_bc_packets.OLD_BUDGET_CCID%type default null,
42: TXN_CCID pa_bc_packets.TXN_CCID%type, -- it should be populated with code combinationid
43: ORG_ID pa_bc_packets.ORG_ID%type, -- it shoudl be populated
44: LAST_UPDATE_DATE pa_bc_packets.LAST_UPDATE_DATE%type, -- standard who columns
45: LAST_UPDATED_BY pa_bc_packets.LAST_UPDATED_BY%type, -- standard who columns
46: CREATED_BY pa_bc_packets.CREATED_BY%type, -- standard who columns
47: CREATION_DATE pa_bc_packets.CREATION_DATE%type, -- standard who columns
48: LAST_UPDATE_LOGIN pa_bc_packets.LAST_UPDATE_LOGIN%type -- standard who columns

Line 45: LAST_UPDATED_BY pa_bc_packets.LAST_UPDATED_BY%type, -- standard who columns

41: OLD_BUDGET_CCID pa_bc_packets.OLD_BUDGET_CCID%type default null,
42: TXN_CCID pa_bc_packets.TXN_CCID%type, -- it should be populated with code combinationid
43: ORG_ID pa_bc_packets.ORG_ID%type, -- it shoudl be populated
44: LAST_UPDATE_DATE pa_bc_packets.LAST_UPDATE_DATE%type, -- standard who columns
45: LAST_UPDATED_BY pa_bc_packets.LAST_UPDATED_BY%type, -- standard who columns
46: CREATED_BY pa_bc_packets.CREATED_BY%type, -- standard who columns
47: CREATION_DATE pa_bc_packets.CREATION_DATE%type, -- standard who columns
48: LAST_UPDATE_LOGIN pa_bc_packets.LAST_UPDATE_LOGIN%type -- standard who columns
49: );

Line 46: CREATED_BY pa_bc_packets.CREATED_BY%type, -- standard who columns

42: TXN_CCID pa_bc_packets.TXN_CCID%type, -- it should be populated with code combinationid
43: ORG_ID pa_bc_packets.ORG_ID%type, -- it shoudl be populated
44: LAST_UPDATE_DATE pa_bc_packets.LAST_UPDATE_DATE%type, -- standard who columns
45: LAST_UPDATED_BY pa_bc_packets.LAST_UPDATED_BY%type, -- standard who columns
46: CREATED_BY pa_bc_packets.CREATED_BY%type, -- standard who columns
47: CREATION_DATE pa_bc_packets.CREATION_DATE%type, -- standard who columns
48: LAST_UPDATE_LOGIN pa_bc_packets.LAST_UPDATE_LOGIN%type -- standard who columns
49: );
50:

Line 47: CREATION_DATE pa_bc_packets.CREATION_DATE%type, -- standard who columns

43: ORG_ID pa_bc_packets.ORG_ID%type, -- it shoudl be populated
44: LAST_UPDATE_DATE pa_bc_packets.LAST_UPDATE_DATE%type, -- standard who columns
45: LAST_UPDATED_BY pa_bc_packets.LAST_UPDATED_BY%type, -- standard who columns
46: CREATED_BY pa_bc_packets.CREATED_BY%type, -- standard who columns
47: CREATION_DATE pa_bc_packets.CREATION_DATE%type, -- standard who columns
48: LAST_UPDATE_LOGIN pa_bc_packets.LAST_UPDATE_LOGIN%type -- standard who columns
49: );
50:
51: TYPE FC_Rec_Table IS TABLE OF FC_Record INDEX BY BINARY_INTEGER;

Line 48: LAST_UPDATE_LOGIN pa_bc_packets.LAST_UPDATE_LOGIN%type -- standard who columns

44: LAST_UPDATE_DATE pa_bc_packets.LAST_UPDATE_DATE%type, -- standard who columns
45: LAST_UPDATED_BY pa_bc_packets.LAST_UPDATED_BY%type, -- standard who columns
46: CREATED_BY pa_bc_packets.CREATED_BY%type, -- standard who columns
47: CREATION_DATE pa_bc_packets.CREATION_DATE%type, -- standard who columns
48: LAST_UPDATE_LOGIN pa_bc_packets.LAST_UPDATE_LOGIN%type -- standard who columns
49: );
50:
51: TYPE FC_Rec_Table IS TABLE OF FC_Record INDEX BY BINARY_INTEGER;
52:

Line 54: * pa_bc_packets. If the operation is success ,x_return_status will be set to 'S'

50:
51: TYPE FC_Rec_Table IS TABLE OF FC_Record INDEX BY BINARY_INTEGER;
52:
53: /** This is an autonmous Transaction API, which inserts records into
54: * pa_bc_packets. If the operation is success ,x_return_status will be set to 'S'
55: * else it will be set to 'T' - for fatal error and x_error_msg will return the sqlcode and sqlerrm
56: **/
57: PROCEDURE Load_pkts(
58: p_calling_module IN varchar2 default 'CCTRXIMPORT'

Line 90: * status of the pa_bc_packets and pa_bdgt_acct_balances will be updated

86: , x_error_msg OUT NOCOPY varchar2
87: );
88: /** This is tieback API for Contract commitment import process,Once the import process is completed
89: * this api will be called by passing the cbc result code. based on the cbc_result_code the
90: * status of the pa_bc_packets and pa_bdgt_acct_balances will be updated
91: * The return status of this API will be 'S' - success, 'F' - Failure, 'T' - Fatal error
92: **/
93: PROCEDURE Pa_enc_import_fck_tieback(
94: p_calling_module IN varchar2

Line 118: * all the transactions in pa_bc_packets to 'F155 or F156'

114:
115: /** Update the result code of the transactions based on the partial flag, calling mode and p_mode
116: * in autonomous transaction. After updating the result code call the status_code update API
117: * NOTE: THIS API will UPDATE only the RESULT CODE if IMPORT process is FAILS . THIS api marks
118: * all the transactions in pa_bc_packets to 'F155 or F156'
119: */
120: PROCEDURE tie_back_result_code
121: (p_calling_module in varchar2,
122: p_packet_id in number,