1: PACKAGE PA_CC_IDENT
2: -- $Header: PACCINTS.pls 120.1.12020000.3 2012/10/05 10:41:57 bdixit ship $ |
3: AS
4: ExpOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
5: ExpOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6: ProjectIdTab PA_PLSQL_DATATYPES.IdTabTyp;
7: TaskIdTab PA_PLSQL_DATATYPES.IdTabTyp;
8: ExpItemDateTab PA_PLSQL_DATATYPES.DateTabTyp;
1: PACKAGE PA_CC_IDENT
2: -- $Header: PACCINTS.pls 120.1.12020000.3 2012/10/05 10:41:57 bdixit ship $ |
3: AS
4: ExpOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
5: ExpOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6: ProjectIdTab PA_PLSQL_DATATYPES.IdTabTyp;
7: TaskIdTab PA_PLSQL_DATATYPES.IdTabTyp;
8: ExpItemDateTab PA_PLSQL_DATATYPES.DateTabTyp;
9: ExpItemIdTab PA_PLSQL_DATATYPES.IdTabTyp;
2: -- $Header: PACCINTS.pls 120.1.12020000.3 2012/10/05 10:41:57 bdixit ship $ |
3: AS
4: ExpOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
5: ExpOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6: ProjectIdTab PA_PLSQL_DATATYPES.IdTabTyp;
7: TaskIdTab PA_PLSQL_DATATYPES.IdTabTyp;
8: ExpItemDateTab PA_PLSQL_DATATYPES.DateTabTyp;
9: ExpItemIdTab PA_PLSQL_DATATYPES.IdTabTyp;
10: ExpTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
3: AS
4: ExpOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
5: ExpOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6: ProjectIdTab PA_PLSQL_DATATYPES.IdTabTyp;
7: TaskIdTab PA_PLSQL_DATATYPES.IdTabTyp;
8: ExpItemDateTab PA_PLSQL_DATATYPES.DateTabTyp;
9: ExpItemIdTab PA_PLSQL_DATATYPES.IdTabTyp;
10: ExpTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
11: SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;
4: ExpOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
5: ExpOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6: ProjectIdTab PA_PLSQL_DATATYPES.IdTabTyp;
7: TaskIdTab PA_PLSQL_DATATYPES.IdTabTyp;
8: ExpItemDateTab PA_PLSQL_DATATYPES.DateTabTyp;
9: ExpItemIdTab PA_PLSQL_DATATYPES.IdTabTyp;
10: ExpTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
11: SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;
12: PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
5: ExpOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6: ProjectIdTab PA_PLSQL_DATATYPES.IdTabTyp;
7: TaskIdTab PA_PLSQL_DATATYPES.IdTabTyp;
8: ExpItemDateTab PA_PLSQL_DATATYPES.DateTabTyp;
9: ExpItemIdTab PA_PLSQL_DATATYPES.IdTabTyp;
10: ExpTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
11: SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;
12: PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
13: PrjOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6: ProjectIdTab PA_PLSQL_DATATYPES.IdTabTyp;
7: TaskIdTab PA_PLSQL_DATATYPES.IdTabTyp;
8: ExpItemDateTab PA_PLSQL_DATATYPES.DateTabTyp;
9: ExpItemIdTab PA_PLSQL_DATATYPES.IdTabTyp;
10: ExpTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
11: SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;
12: PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
13: PrjOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
14: PrjorgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
7: TaskIdTab PA_PLSQL_DATATYPES.IdTabTyp;
8: ExpItemDateTab PA_PLSQL_DATATYPES.DateTabTyp;
9: ExpItemIdTab PA_PLSQL_DATATYPES.IdTabTyp;
10: ExpTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
11: SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;
12: PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
13: PrjOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
14: PrjorgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
15: TransSourceTab PA_PLSQL_DATATYPES.Char30TabTyp;
8: ExpItemDateTab PA_PLSQL_DATATYPES.DateTabTyp;
9: ExpItemIdTab PA_PLSQL_DATATYPES.IdTabTyp;
10: ExpTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
11: SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;
12: PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
13: PrjOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
14: PrjorgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
15: TransSourceTab PA_PLSQL_DATATYPES.Char30TabTyp;
16: NLROrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
9: ExpItemIdTab PA_PLSQL_DATATYPES.IdTabTyp;
10: ExpTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
11: SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;
12: PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
13: PrjOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
14: PrjorgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
15: TransSourceTab PA_PLSQL_DATATYPES.Char30TabTyp;
16: NLROrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
17: PrvdrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
10: ExpTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
11: SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;
12: PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
13: PrjOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
14: PrjorgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
15: TransSourceTab PA_PLSQL_DATATYPES.Char30TabTyp;
16: NLROrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
17: PrvdrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
18: RecvrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
11: SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;
12: PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
13: PrjOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
14: PrjorgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
15: TransSourceTab PA_PLSQL_DATATYPES.Char30TabTyp;
16: NLROrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
17: PrvdrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
18: RecvrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
19: CrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
12: PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
13: PrjOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
14: PrjorgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
15: TransSourceTab PA_PLSQL_DATATYPES.Char30TabTyp;
16: NLROrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
17: PrvdrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
18: RecvrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
19: CrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
20: CrossChargeTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
13: PrjOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
14: PrjorgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
15: TransSourceTab PA_PLSQL_DATATYPES.Char30TabTyp;
16: NLROrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
17: PrvdrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
18: RecvrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
19: CrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
20: CrossChargeTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
21: PrvdrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
14: PrjorgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
15: TransSourceTab PA_PLSQL_DATATYPES.Char30TabTyp;
16: NLROrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
17: PrvdrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
18: RecvrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
19: CrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
20: CrossChargeTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
21: PrvdrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
22: RecvrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
15: TransSourceTab PA_PLSQL_DATATYPES.Char30TabTyp;
16: NLROrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
17: PrvdrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
18: RecvrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
19: CrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
20: CrossChargeTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
21: PrvdrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
22: RecvrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
23: PrvdrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
16: NLROrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
17: PrvdrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
18: RecvrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
19: CrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
20: CrossChargeTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
21: PrvdrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
22: RecvrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
23: PrvdrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
24: RecvrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
17: PrvdrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
18: RecvrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
19: CrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
20: CrossChargeTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
21: PrvdrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
22: RecvrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
23: PrvdrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
24: RecvrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
25: ErrorStageTab PA_PLSQL_DATATYPES.Char150TabTyp;
18: RecvrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
19: CrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
20: CrossChargeTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
21: PrvdrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
22: RecvrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
23: PrvdrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
24: RecvrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
25: ErrorStageTab PA_PLSQL_DATATYPES.Char150TabTyp;
26: ErrorCodeTab PA_PLSQL_DATATYPES.Char150TabTyp;
19: CrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
20: CrossChargeTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
21: PrvdrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
22: RecvrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
23: PrvdrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
24: RecvrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
25: ErrorStageTab PA_PLSQL_DATATYPES.Char150TabTyp;
26: ErrorCodeTab PA_PLSQL_DATATYPES.Char150TabTyp;
27: AcctRawCostTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
20: CrossChargeTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
21: PrvdrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
22: RecvrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
23: PrvdrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
24: RecvrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
25: ErrorStageTab PA_PLSQL_DATATYPES.Char150TabTyp;
26: ErrorCodeTab PA_PLSQL_DATATYPES.Char150TabTyp;
27: AcctRawCostTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
28: --
21: PrvdrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
22: RecvrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
23: PrvdrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
24: RecvrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
25: ErrorStageTab PA_PLSQL_DATATYPES.Char150TabTyp;
26: ErrorCodeTab PA_PLSQL_DATATYPES.Char150TabTyp;
27: AcctRawCostTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
28: --
29: -- AcctRateDateTab is supposed to be of datatype data. But due
22: RecvrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
23: PrvdrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
24: RecvrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
25: ErrorStageTab PA_PLSQL_DATATYPES.Char150TabTyp;
26: ErrorCodeTab PA_PLSQL_DATATYPES.Char150TabTyp;
27: AcctRawCostTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
28: --
29: -- AcctRateDateTab is supposed to be of datatype data. But due
30: -- to bug# 951161 currently we are createing this table with
23: PrvdrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
24: RecvrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
25: ErrorStageTab PA_PLSQL_DATATYPES.Char150TabTyp;
26: ErrorCodeTab PA_PLSQL_DATATYPES.Char150TabTyp;
27: AcctRawCostTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
28: --
29: -- AcctRateDateTab is supposed to be of datatype data. But due
30: -- to bug# 951161 currently we are createing this table with
31: -- datatype varchar2.
29: -- AcctRateDateTab is supposed to be of datatype data. But due
30: -- to bug# 951161 currently we are createing this table with
31: -- datatype varchar2.
32: --
33: AcctRateDateTab PA_PLSQL_DATATYPES.Char30TabTyp;
34: AcctRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
35: AcctRateTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
36: ProjRawCostTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
37: --
30: -- to bug# 951161 currently we are createing this table with
31: -- datatype varchar2.
32: --
33: AcctRateDateTab PA_PLSQL_DATATYPES.Char30TabTyp;
34: AcctRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
35: AcctRateTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
36: ProjRawCostTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
37: --
38: -- ProjRateDateTab is supposed to be of datatype data. But due
31: -- datatype varchar2.
32: --
33: AcctRateDateTab PA_PLSQL_DATATYPES.Char30TabTyp;
34: AcctRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
35: AcctRateTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
36: ProjRawCostTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
37: --
38: -- ProjRateDateTab is supposed to be of datatype data. But due
39: -- to bug# 951161 currently we are createing this table with
32: --
33: AcctRateDateTab PA_PLSQL_DATATYPES.Char30TabTyp;
34: AcctRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
35: AcctRateTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
36: ProjRawCostTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
37: --
38: -- ProjRateDateTab is supposed to be of datatype data. But due
39: -- to bug# 951161 currently we are createing this table with
40: -- datatype varchar2.
38: -- ProjRateDateTab is supposed to be of datatype data. But due
39: -- to bug# 951161 currently we are createing this table with
40: -- datatype varchar2.
41: --
42: ProjRateDateTab PA_PLSQL_DATATYPES.Char30TabTyp;
43: ProjRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
44: ProjRateTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
45: /** EPP **/
46: ProjFuncRawCostTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
39: -- to bug# 951161 currently we are createing this table with
40: -- datatype varchar2.
41: --
42: ProjRateDateTab PA_PLSQL_DATATYPES.Char30TabTyp;
43: ProjRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
44: ProjRateTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
45: /** EPP **/
46: ProjFuncRawCostTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
47: ProjFuncRateDateTab PA_PLSQL_DATATYPES.Char30TabTyp;
40: -- datatype varchar2.
41: --
42: ProjRateDateTab PA_PLSQL_DATATYPES.Char30TabTyp;
43: ProjRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
44: ProjRateTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
45: /** EPP **/
46: ProjFuncRawCostTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
47: ProjFuncRateDateTab PA_PLSQL_DATATYPES.Char30TabTyp;
48: ProjFuncRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
42: ProjRateDateTab PA_PLSQL_DATATYPES.Char30TabTyp;
43: ProjRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
44: ProjRateTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
45: /** EPP **/
46: ProjFuncRawCostTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
47: ProjFuncRateDateTab PA_PLSQL_DATATYPES.Char30TabTyp;
48: ProjFuncRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
49: ProjFuncRateTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
50: /** EPP **/
43: ProjRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
44: ProjRateTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
45: /** EPP **/
46: ProjFuncRawCostTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
47: ProjFuncRateDateTab PA_PLSQL_DATATYPES.Char30TabTyp;
48: ProjFuncRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
49: ProjFuncRateTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
50: /** EPP **/
51: -- StageTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
44: ProjRateTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
45: /** EPP **/
46: ProjFuncRawCostTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
47: ProjFuncRateDateTab PA_PLSQL_DATATYPES.Char30TabTyp;
48: ProjFuncRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
49: ProjFuncRateTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
50: /** EPP **/
51: -- StageTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
52: DenomCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
45: /** EPP **/
46: ProjFuncRawCostTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
47: ProjFuncRateDateTab PA_PLSQL_DATATYPES.Char30TabTyp;
48: ProjFuncRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
49: ProjFuncRateTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
50: /** EPP **/
51: -- StageTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
52: DenomCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
53: StatusTab PA_PLSQL_DATATYPES.Char30TabTyp;
47: ProjFuncRateDateTab PA_PLSQL_DATATYPES.Char30TabTyp;
48: ProjFuncRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
49: ProjFuncRateTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
50: /** EPP **/
51: -- StageTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
52: DenomCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
53: StatusTab PA_PLSQL_DATATYPES.Char30TabTyp;
54:
55:
48: ProjFuncRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
49: ProjFuncRateTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
50: /** EPP **/
51: -- StageTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
52: DenomCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
53: StatusTab PA_PLSQL_DATATYPES.Char30TabTyp;
54:
55:
56: PROCEDURE PA_CC_IDENTIFY_TXN_FI(
49: ProjFuncRateTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
50: /** EPP **/
51: -- StageTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
52: DenomCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
53: StatusTab PA_PLSQL_DATATYPES.Char30TabTyp;
54:
55:
56: PROCEDURE PA_CC_IDENTIFY_TXN_FI(
57: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
53: StatusTab PA_PLSQL_DATATYPES.Char30TabTyp;
54:
55:
56: PROCEDURE PA_CC_IDENTIFY_TXN_FI(
57: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
58: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
59: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
60: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
61: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
54:
55:
56: PROCEDURE PA_CC_IDENTIFY_TXN_FI(
57: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
58: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
59: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
60: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
61: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
62: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
55:
56: PROCEDURE PA_CC_IDENTIFY_TXN_FI(
57: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
58: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
59: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
60: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
61: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
62: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
63: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
56: PROCEDURE PA_CC_IDENTIFY_TXN_FI(
57: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
58: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
59: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
60: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
61: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
62: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
63: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
64: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
57: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
58: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
59: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
60: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
61: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
62: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
63: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
64: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
65: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
58: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
59: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
60: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
61: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
62: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
63: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
64: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
65: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
66: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
59: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
60: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
61: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
62: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
63: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
64: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
65: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
66: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
67: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
60: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
61: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
62: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
63: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
64: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
65: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
66: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
67: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
68: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
61: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
62: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
63: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
64: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
65: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
66: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
67: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
68: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
69: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
62: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
63: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
64: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
65: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
66: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
67: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
68: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
69: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
70: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
63: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
64: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
65: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
66: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
67: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
68: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
69: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
70: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
71: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
64: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
65: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
66: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
67: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
68: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
69: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
70: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
71: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
72: /* Added nocopy for 2672653 */
65: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
66: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
67: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
68: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
69: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
70: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
71: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
72: /* Added nocopy for 2672653 */
73: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
66: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
67: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
68: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
69: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
70: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
71: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
72: /* Added nocopy for 2672653 */
73: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
74: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
67: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
68: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
69: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
70: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
71: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
72: /* Added nocopy for 2672653 */
73: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
74: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
75: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
69: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
70: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
71: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
72: /* Added nocopy for 2672653 */
73: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
74: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
75: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
76: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
77: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
70: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
71: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
72: /* Added nocopy for 2672653 */
73: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
74: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
75: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
76: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
77: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
78: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
71: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
72: /* Added nocopy for 2672653 */
73: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
74: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
75: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
76: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
77: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
78: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
79: X_PrvdrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
72: /* Added nocopy for 2672653 */
73: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
74: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
75: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
76: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
77: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
78: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
79: X_PrvdrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
80: X_Error_Stage OUT NOCOPY VARCHAR2,
73: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
74: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
75: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
76: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
77: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
78: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
79: X_PrvdrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
80: X_Error_Stage OUT NOCOPY VARCHAR2,
81: X_Error_Code OUT NOCOPY NUMBER);
74: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
75: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
76: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
77: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
78: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
79: X_PrvdrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
80: X_Error_Stage OUT NOCOPY VARCHAR2,
81: X_Error_Code OUT NOCOPY NUMBER);
82:
75: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
76: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
77: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
78: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
79: X_PrvdrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
80: X_Error_Stage OUT NOCOPY VARCHAR2,
81: X_Error_Code OUT NOCOPY NUMBER);
82:
83: PROCEDURE PA_CC_IDENTIFY_TXN_ADJ (
107: /* Added calling module for 3234973 */
108: X_Calling_Module IN VARCHAR2 DEFAULT 'TRANSACTION') ;
109:
110: PROCEDURE PA_CC_IDENTIFY_TXN(
111: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
112: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
113: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
114: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
115: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
108: X_Calling_Module IN VARCHAR2 DEFAULT 'TRANSACTION') ;
109:
110: PROCEDURE PA_CC_IDENTIFY_TXN(
111: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
112: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
113: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
114: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
115: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
116: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
109:
110: PROCEDURE PA_CC_IDENTIFY_TXN(
111: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
112: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
113: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
114: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
115: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
116: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
117: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
110: PROCEDURE PA_CC_IDENTIFY_TXN(
111: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
112: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
113: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
114: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
115: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
116: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
117: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
118: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
111: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
112: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
113: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
114: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
115: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
116: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
117: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
118: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
119: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
112: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
113: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
114: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
115: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
116: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
117: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
118: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
119: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
120: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
113: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
114: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
115: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
116: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
117: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
118: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
119: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
120: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
121: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
114: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
115: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
116: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
117: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
118: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
119: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
120: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
121: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
122: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
115: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
116: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
117: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
118: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
119: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
120: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
121: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
122: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
123: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
116: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
117: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
118: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
119: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
120: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
121: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
122: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
123: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
124: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
117: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
118: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
119: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
120: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
121: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
122: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
123: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
124: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
125: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
118: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
119: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
120: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
121: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
122: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
123: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
124: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
125: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
126: /* Added nocopy for 2672653 */
119: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
120: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
121: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
122: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
123: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
124: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
125: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
126: /* Added nocopy for 2672653 */
127: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
120: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
121: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
122: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
123: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
124: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
125: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
126: /* Added nocopy for 2672653 */
127: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
128: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
121: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
122: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
123: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
124: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
125: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
126: /* Added nocopy for 2672653 */
127: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
128: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
129: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
123: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
124: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
125: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
126: /* Added nocopy for 2672653 */
127: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
128: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
129: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
130: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
131: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
124: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
125: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
126: /* Added nocopy for 2672653 */
127: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
128: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
129: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
130: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
131: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
132: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
125: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
126: /* Added nocopy for 2672653 */
127: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
128: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
129: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
130: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
131: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
132: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
133: X_Error_Stage OUT NOCOPY VARCHAR2,
126: /* Added nocopy for 2672653 */
127: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
128: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
129: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
130: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
131: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
132: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
133: X_Error_Stage OUT NOCOPY VARCHAR2,
134: X_Error_Code OUT NOCOPY NUMBER,
127: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
128: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
129: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
130: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
131: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
132: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
133: X_Error_Stage OUT NOCOPY VARCHAR2,
134: X_Error_Code OUT NOCOPY NUMBER,
135: /* Added calling module for 3234973 */
128: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
129: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
130: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
131: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
132: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
133: X_Error_Stage OUT NOCOPY VARCHAR2,
134: X_Error_Code OUT NOCOPY NUMBER,
135: /* Added calling module for 3234973 */
136: X_Calling_Module IN VARCHAR2 DEFAULT 'TRANSACTION') ;
135: /* Added calling module for 3234973 */
136: X_Calling_Module IN VARCHAR2 DEFAULT 'TRANSACTION') ;
137:
138: PROCEDURE PA_CC_GET_PRVDR_RECVR_ORGS (
139: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
140: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
141: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
142: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
143: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
136: X_Calling_Module IN VARCHAR2 DEFAULT 'TRANSACTION') ;
137:
138: PROCEDURE PA_CC_GET_PRVDR_RECVR_ORGS (
139: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
140: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
141: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
142: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
143: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
144: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
137:
138: PROCEDURE PA_CC_GET_PRVDR_RECVR_ORGS (
139: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
140: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
141: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
142: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
143: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
144: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
145: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
138: PROCEDURE PA_CC_GET_PRVDR_RECVR_ORGS (
139: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
140: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
141: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
142: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
143: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
144: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
145: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
146: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
139: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
140: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
141: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
142: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
143: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
144: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
145: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
146: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
147: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
140: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
141: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
142: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
143: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
144: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
145: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
146: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
147: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
148: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
141: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
142: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
143: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
144: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
145: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
146: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
147: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
148: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
149: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
142: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
143: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
144: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
145: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
146: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
147: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
148: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
149: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
150: /* Added nocopy for 2672653 */
143: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
144: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
145: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
146: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
147: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
148: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
149: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
150: /* Added nocopy for 2672653 */
151: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp, -- added bug 14173646
144: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
145: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
146: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
147: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
148: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
149: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
150: /* Added nocopy for 2672653 */
151: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp, -- added bug 14173646
152: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
145: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
146: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
147: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
148: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
149: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
150: /* Added nocopy for 2672653 */
151: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp, -- added bug 14173646
152: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
153: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
147: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
148: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
149: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
150: /* Added nocopy for 2672653 */
151: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp, -- added bug 14173646
152: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
153: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
154: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
155: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
148: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
149: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
150: /* Added nocopy for 2672653 */
151: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp, -- added bug 14173646
152: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
153: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
154: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
155: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
156: X_CCProcessIOCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
149: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
150: /* Added nocopy for 2672653 */
151: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp, -- added bug 14173646
152: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
153: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
154: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
155: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
156: X_CCProcessIOCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
157: X_CCProcessIUCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
150: /* Added nocopy for 2672653 */
151: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp, -- added bug 14173646
152: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
153: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
154: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
155: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
156: X_CCProcessIOCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
157: X_CCProcessIUCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
158: X_CCPrjFlagTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
151: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp, -- added bug 14173646
152: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
153: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
154: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
155: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
156: X_CCProcessIOCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
157: X_CCProcessIUCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
158: X_CCPrjFlagTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
159: X_Error_Stage OUT NOCOPY VARCHAR2,
152: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
153: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
154: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
155: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
156: X_CCProcessIOCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
157: X_CCProcessIUCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
158: X_CCPrjFlagTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
159: X_Error_Stage OUT NOCOPY VARCHAR2,
160: X_Error_Code OUT NOCOPY NUMBER,
153: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
154: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
155: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
156: X_CCProcessIOCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
157: X_CCProcessIUCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
158: X_CCPrjFlagTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
159: X_Error_Stage OUT NOCOPY VARCHAR2,
160: X_Error_Code OUT NOCOPY NUMBER,
161: /* Added calling module for 3234973 */
154: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
155: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
156: X_CCProcessIOCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
157: X_CCProcessIUCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
158: X_CCPrjFlagTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
159: X_Error_Stage OUT NOCOPY VARCHAR2,
160: X_Error_Code OUT NOCOPY NUMBER,
161: /* Added calling module for 3234973 */
162: X_Calling_Module IN VARCHAR2 DEFAULT 'TRANSACTION');
161: /* Added calling module for 3234973 */
162: X_Calling_Module IN VARCHAR2 DEFAULT 'TRANSACTION');
163:
164: PROCEDURE PA_CC_GET_CROSS_CHARGE_TYPE (
165: P_PrvdrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
166: P_RecvrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
167: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
168: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
169: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
162: X_Calling_Module IN VARCHAR2 DEFAULT 'TRANSACTION');
163:
164: PROCEDURE PA_CC_GET_CROSS_CHARGE_TYPE (
165: P_PrvdrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
166: P_RecvrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
167: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
168: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
169: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
170: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
163:
164: PROCEDURE PA_CC_GET_CROSS_CHARGE_TYPE (
165: P_PrvdrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
166: P_RecvrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
167: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
168: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
169: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
170: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
171: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
164: PROCEDURE PA_CC_GET_CROSS_CHARGE_TYPE (
165: P_PrvdrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
166: P_RecvrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
167: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
168: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
169: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
170: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
171: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
172: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
165: P_PrvdrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
166: P_RecvrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
167: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
168: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
169: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
170: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
171: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
172: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
173: P_PrvdrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
166: P_RecvrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
167: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
168: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
169: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
170: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
171: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
172: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
173: P_PrvdrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
174: P_RecvrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
167: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
168: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
169: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
170: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
171: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
172: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
173: P_PrvdrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
174: P_RecvrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
175: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
168: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
169: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
170: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
171: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
172: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
173: P_PrvdrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
174: P_RecvrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
175: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
176: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
169: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
170: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
171: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
172: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
173: P_PrvdrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
174: P_RecvrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
175: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
176: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
177: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
170: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
171: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
172: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
173: P_PrvdrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
174: P_RecvrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
175: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
176: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
177: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
178: P_CCProcessIOCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
171: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
172: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
173: P_PrvdrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
174: P_RecvrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
175: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
176: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
177: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
178: P_CCProcessIOCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
179: P_CCProcessIUCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
172: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
173: P_PrvdrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
174: P_RecvrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
175: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
176: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
177: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
178: P_CCProcessIOCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
179: P_CCProcessIUCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
180: P_CCPrjFlagTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
173: P_PrvdrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
174: P_RecvrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
175: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
176: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
177: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
178: P_CCProcessIOCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
179: P_CCProcessIUCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
180: P_CCPrjFlagTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
181: P_calling_mode IN VARCHAR2 default 'TRANSACTION',
174: P_RecvrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
175: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
176: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
177: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
178: P_CCProcessIOCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
179: P_CCProcessIUCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
180: P_CCPrjFlagTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
181: P_calling_mode IN VARCHAR2 default 'TRANSACTION',
182: /* Added nocopy for 2672653 */
175: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
176: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
177: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
178: P_CCProcessIOCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
179: P_CCProcessIUCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
180: P_CCPrjFlagTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
181: P_calling_mode IN VARCHAR2 default 'TRANSACTION',
182: /* Added nocopy for 2672653 */
183: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
176: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
177: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
178: P_CCProcessIOCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
179: P_CCProcessIUCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
180: P_CCPrjFlagTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
181: P_calling_mode IN VARCHAR2 default 'TRANSACTION',
182: /* Added nocopy for 2672653 */
183: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
184: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
179: P_CCProcessIUCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
180: P_CCPrjFlagTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
181: P_calling_mode IN VARCHAR2 default 'TRANSACTION',
182: /* Added nocopy for 2672653 */
183: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
184: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
185: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
186: X_Error_Stage OUT NOCOPY VARCHAR2,
187: X_Error_Code OUT NOCOPY NUMBER);
180: P_CCPrjFlagTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
181: P_calling_mode IN VARCHAR2 default 'TRANSACTION',
182: /* Added nocopy for 2672653 */
183: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
184: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
185: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
186: X_Error_Stage OUT NOCOPY VARCHAR2,
187: X_Error_Code OUT NOCOPY NUMBER);
188:
181: P_calling_mode IN VARCHAR2 default 'TRANSACTION',
182: /* Added nocopy for 2672653 */
183: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
184: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
185: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
186: X_Error_Stage OUT NOCOPY VARCHAR2,
187: X_Error_Code OUT NOCOPY NUMBER);
188:
189: FUNCTION GetLegalEntity( p_org_id IN NUMBER ) RETURN NUMBER;