eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_CC_IDENT dependencies on PA_PLSQL_DATATYPES

Line 37: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

33: -- This API derives the provider,receiver orgs and assumes that
34: -- to process the records in plsql tables the param x_statusTab should be null
35: -- other wise it will be treated as a error records.
36: PROCEDURE PA_CC_IDENTIFY_TXN_FI(
37: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
38: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
39: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
40: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
41: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,

Line 38: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,

34: -- to process the records in plsql tables the param x_statusTab should be null
35: -- other wise it will be treated as a error records.
36: PROCEDURE PA_CC_IDENTIFY_TXN_FI(
37: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
38: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
39: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
40: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
41: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
42: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 39: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

35: -- other wise it will be treated as a error records.
36: PROCEDURE PA_CC_IDENTIFY_TXN_FI(
37: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
38: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
39: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
40: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
41: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
42: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
43: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 40: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

36: PROCEDURE PA_CC_IDENTIFY_TXN_FI(
37: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
38: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
39: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
40: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
41: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
42: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
43: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
44: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

Line 41: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,

37: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
38: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
39: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
40: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
41: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
42: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
43: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
44: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
45: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

Line 42: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

38: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
39: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
40: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
41: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
42: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
43: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
44: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
45: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
46: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 43: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

39: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
40: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
41: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
42: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
43: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
44: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
45: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
46: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
47: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 44: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

40: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
41: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
42: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
43: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
44: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
45: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
46: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
47: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
48: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

Line 45: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

41: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
42: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
43: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
44: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
45: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
46: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
47: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
48: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
49: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 46: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

42: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
43: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
44: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
45: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
46: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
47: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
48: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
49: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
50: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 47: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

43: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
44: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
45: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
46: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
47: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
48: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
49: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
50: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
51: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 48: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

44: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
45: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
46: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
47: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
48: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
49: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
50: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
51: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
52: /* Added nocopy for 2672653 */

Line 49: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

45: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
46: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
47: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
48: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
49: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
50: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
51: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
52: /* Added nocopy for 2672653 */
53: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

Line 50: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

46: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
47: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
48: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
49: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
50: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
51: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
52: /* Added nocopy for 2672653 */
53: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
54: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,

Line 51: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

47: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
48: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
49: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
50: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
51: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
52: /* Added nocopy for 2672653 */
53: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
54: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
55: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,

Line 53: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

49: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
50: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
51: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
52: /* Added nocopy for 2672653 */
53: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
54: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
55: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
56: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
57: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

Line 54: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,

50: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
51: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
52: /* Added nocopy for 2672653 */
53: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
54: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
55: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
56: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
57: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
58: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

Line 55: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,

51: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
52: /* Added nocopy for 2672653 */
53: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
54: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
55: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
56: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
57: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
58: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
59: X_PrvdrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

Line 56: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

52: /* Added nocopy for 2672653 */
53: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
54: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
55: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
56: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
57: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
58: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
59: X_PrvdrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
60: X_Error_Stage OUT NOCOPY VARCHAR2,

Line 57: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

53: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
54: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
55: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
56: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
57: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
58: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
59: X_PrvdrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
60: X_Error_Stage OUT NOCOPY VARCHAR2,
61: X_Error_Code OUT NOCOPY NUMBER) IS

Line 58: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

54: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
55: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
56: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
57: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
58: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
59: X_PrvdrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
60: X_Error_Stage OUT NOCOPY VARCHAR2,
61: X_Error_Code OUT NOCOPY NUMBER) IS
62:

Line 59: X_PrvdrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

55: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
56: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
57: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
58: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
59: X_PrvdrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
60: X_Error_Stage OUT NOCOPY VARCHAR2,
61: X_Error_Code OUT NOCOPY NUMBER) IS
62:
63: l_PrevProjectId pa_projects_all.project_id%type := Null;

Line 77: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;

73: l_current_process_iu_code pa_implementations_all.cc_process_iu_code%type;
74: l_PrevCCProcessIOCode pa_implementations_all.cc_process_io_code%type;
75: l_PrevCCProcessIUCode pa_implementations_all.cc_process_iu_code%type;
76: l_prevexporgid pa_projects_all.org_id%type := Null;
77: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
78: l_CCProcessIUCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
79: l_CCPrjFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
80: l_current_org_id pa_projects_all.org_id%type := Null;
81: l_PrevPrvdrOrgId pa_projects_all.org_id%type := Null;

Line 78: l_CCProcessIUCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;

74: l_PrevCCProcessIOCode pa_implementations_all.cc_process_io_code%type;
75: l_PrevCCProcessIUCode pa_implementations_all.cc_process_iu_code%type;
76: l_prevexporgid pa_projects_all.org_id%type := Null;
77: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
78: l_CCProcessIUCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
79: l_CCPrjFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
80: l_current_org_id pa_projects_all.org_id%type := Null;
81: l_PrevPrvdrOrgId pa_projects_all.org_id%type := Null;
82:

Line 79: l_CCPrjFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;

75: l_PrevCCProcessIUCode pa_implementations_all.cc_process_iu_code%type;
76: l_prevexporgid pa_projects_all.org_id%type := Null;
77: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
78: l_CCProcessIUCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
79: l_CCPrjFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
80: l_current_org_id pa_projects_all.org_id%type := Null;
81: l_PrevPrvdrOrgId pa_projects_all.org_id%type := Null;
82:
83:

Line 307: l_ExpOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;

303:
304: -- The following PL/SQL tables are created to store the values passed in to
305: -- this procedure.
306:
307: l_ExpOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
308: l_ExpOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
309: l_ProjectIdTab PA_PLSQL_DATATYPES.IdTabTyp;
310: l_TaskIdTab PA_PLSQL_DATATYPES.IdTabTyp;
311: l_ExpItemDateTab PA_PLSQL_DATATYPES.DateTabTyp;

Line 308: l_ExpOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;

304: -- The following PL/SQL tables are created to store the values passed in to
305: -- this procedure.
306:
307: l_ExpOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
308: l_ExpOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
309: l_ProjectIdTab PA_PLSQL_DATATYPES.IdTabTyp;
310: l_TaskIdTab PA_PLSQL_DATATYPES.IdTabTyp;
311: l_ExpItemDateTab PA_PLSQL_DATATYPES.DateTabTyp;
312: l_ExpItemIdTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 309: l_ProjectIdTab PA_PLSQL_DATATYPES.IdTabTyp;

305: -- this procedure.
306:
307: l_ExpOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
308: l_ExpOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
309: l_ProjectIdTab PA_PLSQL_DATATYPES.IdTabTyp;
310: l_TaskIdTab PA_PLSQL_DATATYPES.IdTabTyp;
311: l_ExpItemDateTab PA_PLSQL_DATATYPES.DateTabTyp;
312: l_ExpItemIdTab PA_PLSQL_DATATYPES.IdTabTyp;
313: l_PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 310: l_TaskIdTab PA_PLSQL_DATATYPES.IdTabTyp;

306:
307: l_ExpOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
308: l_ExpOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
309: l_ProjectIdTab PA_PLSQL_DATATYPES.IdTabTyp;
310: l_TaskIdTab PA_PLSQL_DATATYPES.IdTabTyp;
311: l_ExpItemDateTab PA_PLSQL_DATATYPES.DateTabTyp;
312: l_ExpItemIdTab PA_PLSQL_DATATYPES.IdTabTyp;
313: l_PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
314: l_ExpTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 311: l_ExpItemDateTab PA_PLSQL_DATATYPES.DateTabTyp;

307: l_ExpOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
308: l_ExpOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
309: l_ProjectIdTab PA_PLSQL_DATATYPES.IdTabTyp;
310: l_TaskIdTab PA_PLSQL_DATATYPES.IdTabTyp;
311: l_ExpItemDateTab PA_PLSQL_DATATYPES.DateTabTyp;
312: l_ExpItemIdTab PA_PLSQL_DATATYPES.IdTabTyp;
313: l_PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
314: l_ExpTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
315: l_SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 312: l_ExpItemIdTab PA_PLSQL_DATATYPES.IdTabTyp;

308: l_ExpOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
309: l_ProjectIdTab PA_PLSQL_DATATYPES.IdTabTyp;
310: l_TaskIdTab PA_PLSQL_DATATYPES.IdTabTyp;
311: l_ExpItemDateTab PA_PLSQL_DATATYPES.DateTabTyp;
312: l_ExpItemIdTab PA_PLSQL_DATATYPES.IdTabTyp;
313: l_PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
314: l_ExpTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
315: l_SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;
316: l_PrjOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 313: l_PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;

309: l_ProjectIdTab PA_PLSQL_DATATYPES.IdTabTyp;
310: l_TaskIdTab PA_PLSQL_DATATYPES.IdTabTyp;
311: l_ExpItemDateTab PA_PLSQL_DATATYPES.DateTabTyp;
312: l_ExpItemIdTab PA_PLSQL_DATATYPES.IdTabTyp;
313: l_PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
314: l_ExpTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
315: l_SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;
316: l_PrjOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
317: l_PrjorgIdTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 314: l_ExpTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;

310: l_TaskIdTab PA_PLSQL_DATATYPES.IdTabTyp;
311: l_ExpItemDateTab PA_PLSQL_DATATYPES.DateTabTyp;
312: l_ExpItemIdTab PA_PLSQL_DATATYPES.IdTabTyp;
313: l_PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
314: l_ExpTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
315: l_SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;
316: l_PrjOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
317: l_PrjorgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
318: l_TransSourceTab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 315: l_SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;

311: l_ExpItemDateTab PA_PLSQL_DATATYPES.DateTabTyp;
312: l_ExpItemIdTab PA_PLSQL_DATATYPES.IdTabTyp;
313: l_PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
314: l_ExpTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
315: l_SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;
316: l_PrjOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
317: l_PrjorgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
318: l_TransSourceTab PA_PLSQL_DATATYPES.Char30TabTyp;
319: l_NLROrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 316: l_PrjOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;

312: l_ExpItemIdTab PA_PLSQL_DATATYPES.IdTabTyp;
313: l_PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
314: l_ExpTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
315: l_SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;
316: l_PrjOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
317: l_PrjorgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
318: l_TransSourceTab PA_PLSQL_DATATYPES.Char30TabTyp;
319: l_NLROrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
320: l_PrvdrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 317: l_PrjorgIdTab PA_PLSQL_DATATYPES.IdTabTyp;

313: l_PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
314: l_ExpTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
315: l_SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;
316: l_PrjOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
317: l_PrjorgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
318: l_TransSourceTab PA_PLSQL_DATATYPES.Char30TabTyp;
319: l_NLROrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
320: l_PrvdrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
321: l_RecvrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 318: l_TransSourceTab PA_PLSQL_DATATYPES.Char30TabTyp;

314: l_ExpTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
315: l_SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;
316: l_PrjOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
317: l_PrjorgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
318: l_TransSourceTab PA_PLSQL_DATATYPES.Char30TabTyp;
319: l_NLROrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
320: l_PrvdrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
321: l_RecvrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
322: l_CrossChargeTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;

Line 319: l_NLROrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;

315: l_SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;
316: l_PrjOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
317: l_PrjorgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
318: l_TransSourceTab PA_PLSQL_DATATYPES.Char30TabTyp;
319: l_NLROrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
320: l_PrvdrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
321: l_RecvrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
322: l_CrossChargeTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
323: l_CrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;

Line 320: l_PrvdrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;

316: l_PrjOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
317: l_PrjorgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
318: l_TransSourceTab PA_PLSQL_DATATYPES.Char30TabTyp;
319: l_NLROrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
320: l_PrvdrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
321: l_RecvrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
322: l_CrossChargeTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
323: l_CrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
324: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;

Line 321: l_RecvrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;

317: l_PrjorgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
318: l_TransSourceTab PA_PLSQL_DATATYPES.Char30TabTyp;
319: l_NLROrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
320: l_PrvdrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
321: l_RecvrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
322: l_CrossChargeTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
323: l_CrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
324: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
325: l_CCProcessIUCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;

Line 322: l_CrossChargeTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;

318: l_TransSourceTab PA_PLSQL_DATATYPES.Char30TabTyp;
319: l_NLROrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
320: l_PrvdrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
321: l_RecvrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
322: l_CrossChargeTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
323: l_CrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
324: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
325: l_CCProcessIUCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
326: l_PrvdrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 323: l_CrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;

319: l_NLROrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
320: l_PrvdrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
321: l_RecvrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
322: l_CrossChargeTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
323: l_CrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
324: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
325: l_CCProcessIUCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
326: l_PrvdrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
327: l_RecvrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 324: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;

320: l_PrvdrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
321: l_RecvrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
322: l_CrossChargeTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
323: l_CrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
324: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
325: l_CCProcessIUCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
326: l_PrvdrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
327: l_RecvrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
328: l_PrvdrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 325: l_CCProcessIUCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;

321: l_RecvrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
322: l_CrossChargeTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
323: l_CrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
324: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
325: l_CCProcessIUCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
326: l_PrvdrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
327: l_RecvrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
328: l_PrvdrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
329: l_RecvrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 326: l_PrvdrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;

322: l_CrossChargeTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
323: l_CrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
324: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
325: l_CCProcessIUCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
326: l_PrvdrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
327: l_RecvrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
328: l_PrvdrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
329: l_RecvrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
330: l_Error_Stage VARCHAR2(2000);

Line 327: l_RecvrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;

323: l_CrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
324: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
325: l_CCProcessIUCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
326: l_PrvdrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
327: l_RecvrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
328: l_PrvdrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
329: l_RecvrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
330: l_Error_Stage VARCHAR2(2000);
331: l_Error_Code NUMBER;

Line 328: l_PrvdrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;

324: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
325: l_CCProcessIUCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
326: l_PrvdrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
327: l_RecvrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
328: l_PrvdrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
329: l_RecvrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
330: l_Error_Stage VARCHAR2(2000);
331: l_Error_Code NUMBER;
332: l_StageTab PA_PLSQL_DATATYPES.NewAmtTabTyp;

Line 329: l_RecvrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;

325: l_CCProcessIUCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
326: l_PrvdrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
327: l_RecvrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
328: l_PrvdrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
329: l_RecvrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
330: l_Error_Stage VARCHAR2(2000);
331: l_Error_Code NUMBER;
332: l_StageTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
333: l_StatusTab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 332: l_StageTab PA_PLSQL_DATATYPES.NewAmtTabTyp;

328: l_PrvdrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
329: l_RecvrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
330: l_Error_Stage VARCHAR2(2000);
331: l_Error_Code NUMBER;
332: l_StageTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
333: l_StatusTab PA_PLSQL_DATATYPES.Char30TabTyp;
334:
335: BEGIN
336:

Line 333: l_StatusTab PA_PLSQL_DATATYPES.Char30TabTyp;

329: l_RecvrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
330: l_Error_Stage VARCHAR2(2000);
331: l_Error_Code NUMBER;
332: l_StageTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
333: l_StatusTab PA_PLSQL_DATATYPES.Char30TabTyp;
334:
335: BEGIN
336:
337: -- Assign all the input values to the tables. These tables will be passed

Line 421: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

417:
418: END PA_CC_IDENTIFY_TXN_ADJ;
419:
420: PROCEDURE PA_CC_IDENTIFY_TXN(
421: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
422: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
423: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
424: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
425: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,

Line 422: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,

418: END PA_CC_IDENTIFY_TXN_ADJ;
419:
420: PROCEDURE PA_CC_IDENTIFY_TXN(
421: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
422: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
423: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
424: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
425: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
426: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 423: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

419:
420: PROCEDURE PA_CC_IDENTIFY_TXN(
421: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
422: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
423: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
424: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
425: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
426: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
427: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 424: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

420: PROCEDURE PA_CC_IDENTIFY_TXN(
421: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
422: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
423: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
424: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
425: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
426: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
427: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
428: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

Line 425: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,

421: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
422: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
423: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
424: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
425: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
426: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
427: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
428: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
429: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

Line 426: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

422: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
423: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
424: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
425: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
426: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
427: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
428: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
429: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
430: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 427: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

423: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
424: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
425: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
426: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
427: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
428: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
429: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
430: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
431: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 428: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

424: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
425: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
426: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
427: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
428: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
429: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
430: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
431: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
432: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

Line 429: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

425: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
426: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
427: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
428: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
429: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
430: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
431: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
432: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
433: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 430: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

426: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
427: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
428: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
429: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
430: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
431: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
432: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
433: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
434: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 431: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

427: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
428: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
429: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
430: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
431: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
432: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
433: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
434: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
435: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 432: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

428: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
429: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
430: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
431: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
432: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
433: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
434: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
435: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
436: /* Added nocopy for 2672653 */

Line 433: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

429: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
430: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
431: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
432: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
433: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
434: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
435: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
436: /* Added nocopy for 2672653 */
437: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

Line 434: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

430: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
431: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
432: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
433: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
434: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
435: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
436: /* Added nocopy for 2672653 */
437: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
438: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,

Line 435: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

431: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
432: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
433: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
434: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
435: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
436: /* Added nocopy for 2672653 */
437: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
438: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
439: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,

Line 437: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

433: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
434: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
435: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
436: /* Added nocopy for 2672653 */
437: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
438: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
439: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
440: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
441: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

Line 438: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,

434: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
435: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
436: /* Added nocopy for 2672653 */
437: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
438: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
439: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
440: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
441: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
442: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

Line 439: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,

435: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
436: /* Added nocopy for 2672653 */
437: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
438: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
439: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
440: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
441: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
442: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
443: X_Error_Stage OUT NOCOPY VARCHAR2,

Line 440: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

436: /* Added nocopy for 2672653 */
437: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
438: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
439: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
440: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
441: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
442: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
443: X_Error_Stage OUT NOCOPY VARCHAR2,
444: X_Error_Code OUT NOCOPY NUMBER,

Line 441: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

437: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
438: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
439: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
440: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
441: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
442: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
443: X_Error_Stage OUT NOCOPY VARCHAR2,
444: X_Error_Code OUT NOCOPY NUMBER,
445: /* Added calling module for 3234973 */

Line 442: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

438: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
439: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
440: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
441: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
442: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
443: X_Error_Stage OUT NOCOPY VARCHAR2,
444: X_Error_Code OUT NOCOPY NUMBER,
445: /* Added calling module for 3234973 */
446: X_Calling_Module IN VARCHAR2)

Line 450: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;

446: X_Calling_Module IN VARCHAR2)
447:
448: IS
449:
450: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
451: l_CCProcessIUCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
452: l_CCPrjFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
453:
454:

Line 451: l_CCProcessIUCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;

447:
448: IS
449:
450: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
451: l_CCProcessIUCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
452: l_CCPrjFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
453:
454:
455: l_CCProcessIOCode VARCHAR2(1);

Line 452: l_CCPrjFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;

448: IS
449:
450: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
451: l_CCProcessIUCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
452: l_CCPrjFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
453:
454:
455: l_CCProcessIOCode VARCHAR2(1);
456: l_CCProcessIUCode VARCHAR2(1);

Line 542: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

538:
539: END PA_CC_IDENTIFY_TXN;
540:
541: PROCEDURE PA_CC_GET_PRVDR_RECVR_ORGS (
542: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
543: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
544: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
545: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
546: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

Line 543: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,

539: END PA_CC_IDENTIFY_TXN;
540:
541: PROCEDURE PA_CC_GET_PRVDR_RECVR_ORGS (
542: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
543: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
544: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
545: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
546: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
547: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 544: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

540:
541: PROCEDURE PA_CC_GET_PRVDR_RECVR_ORGS (
542: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
543: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
544: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
545: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
546: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
547: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
548: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 545: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

541: PROCEDURE PA_CC_GET_PRVDR_RECVR_ORGS (
542: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
543: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
544: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
545: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
546: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
547: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
548: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
549: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,

Line 546: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

542: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
543: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
544: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
545: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
546: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
547: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
548: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
549: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
550: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

Line 547: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

543: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
544: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
545: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
546: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
547: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
548: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
549: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
550: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
551: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 548: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

544: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
545: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
546: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
547: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
548: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
549: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
550: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
551: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
552: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 549: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,

545: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
546: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
547: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
548: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
549: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
550: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
551: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
552: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
553: /* Added nocopy for 2672653 */

Line 550: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

546: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
547: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
548: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
549: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
550: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
551: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
552: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
553: /* Added nocopy for 2672653 */
554: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

Line 551: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

547: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
548: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
549: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
550: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
551: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
552: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
553: /* Added nocopy for 2672653 */
554: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
555: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

Line 552: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

548: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
549: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
550: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
551: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
552: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
553: /* Added nocopy for 2672653 */
554: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
555: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
556: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

Line 554: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

550: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
551: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
552: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
553: /* Added nocopy for 2672653 */
554: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
555: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
556: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
557: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
558: X_CCProcessIOCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,

Line 555: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

551: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
552: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
553: /* Added nocopy for 2672653 */
554: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
555: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
556: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
557: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
558: X_CCProcessIOCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
559: X_CCProcessIUCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,

Line 556: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

552: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
553: /* Added nocopy for 2672653 */
554: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
555: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
556: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
557: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
558: X_CCProcessIOCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
559: X_CCProcessIUCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
560: X_CCPrjFlagTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,

Line 557: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

553: /* Added nocopy for 2672653 */
554: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
555: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
556: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
557: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
558: X_CCProcessIOCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
559: X_CCProcessIUCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
560: X_CCPrjFlagTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
561: X_Error_Stage OUT NOCOPY VARCHAR2,

Line 558: X_CCProcessIOCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,

554: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
555: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
556: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
557: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
558: X_CCProcessIOCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
559: X_CCProcessIUCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
560: X_CCPrjFlagTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
561: X_Error_Stage OUT NOCOPY VARCHAR2,
562: X_Error_Code OUT NOCOPY NUMBER,

Line 559: X_CCProcessIUCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,

555: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
556: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
557: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
558: X_CCProcessIOCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
559: X_CCProcessIUCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
560: X_CCPrjFlagTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
561: X_Error_Stage OUT NOCOPY VARCHAR2,
562: X_Error_Code OUT NOCOPY NUMBER,
563: /* Added calling module for 3234973 */

Line 560: X_CCPrjFlagTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,

556: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
557: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
558: X_CCProcessIOCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
559: X_CCProcessIUCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
560: X_CCPrjFlagTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
561: X_Error_Stage OUT NOCOPY VARCHAR2,
562: X_Error_Code OUT NOCOPY NUMBER,
563: /* Added calling module for 3234973 */
564: X_Calling_Module IN VARCHAR2) IS

Line 985: P_PrvdrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

981:
982: END PA_CC_GET_PRVDR_RECVR_ORGS ;
983:
984: PROCEDURE PA_CC_GET_CROSS_CHARGE_TYPE (
985: P_PrvdrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
986: P_RecvrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
987: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
988: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
989: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

Line 986: P_RecvrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

982: END PA_CC_GET_PRVDR_RECVR_ORGS ;
983:
984: PROCEDURE PA_CC_GET_CROSS_CHARGE_TYPE (
985: P_PrvdrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
986: P_RecvrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
987: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
988: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
989: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
990: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 987: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

983:
984: PROCEDURE PA_CC_GET_CROSS_CHARGE_TYPE (
985: P_PrvdrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
986: P_RecvrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
987: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
988: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
989: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
990: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
991: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 988: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

984: PROCEDURE PA_CC_GET_CROSS_CHARGE_TYPE (
985: P_PrvdrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
986: P_RecvrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
987: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
988: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
989: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
990: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
991: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
992: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,

Line 989: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

985: P_PrvdrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
986: P_RecvrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
987: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
988: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
989: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
990: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
991: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
992: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
993: P_PrvdrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 990: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

986: P_RecvrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
987: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
988: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
989: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
990: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
991: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
992: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
993: P_PrvdrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
994: P_RecvrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 991: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

987: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
988: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
989: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
990: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
991: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
992: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
993: P_PrvdrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
994: P_RecvrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
995: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 992: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,

988: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
989: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
990: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
991: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
992: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
993: P_PrvdrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
994: P_RecvrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
995: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
996: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 993: P_PrvdrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

989: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
990: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
991: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
992: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
993: P_PrvdrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
994: P_RecvrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
995: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
996: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
997: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

Line 994: P_RecvrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

990: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
991: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
992: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
993: P_PrvdrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
994: P_RecvrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
995: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
996: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
997: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
998: P_CCProcessIOCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,

Line 995: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

991: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
992: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
993: P_PrvdrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
994: P_RecvrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
995: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
996: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
997: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
998: P_CCProcessIOCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
999: P_CCProcessIUCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,

Line 996: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

992: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
993: P_PrvdrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
994: P_RecvrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
995: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
996: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
997: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
998: P_CCProcessIOCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
999: P_CCProcessIUCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
1000: P_CCPrjFlagTab IN PA_PLSQL_DATATYPES.Char1TabTyp,

Line 997: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

993: P_PrvdrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
994: P_RecvrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
995: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
996: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
997: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
998: P_CCProcessIOCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
999: P_CCProcessIUCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
1000: P_CCPrjFlagTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
1001: P_calling_mode IN VARCHAR2 ,

Line 998: P_CCProcessIOCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,

994: P_RecvrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
995: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
996: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
997: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
998: P_CCProcessIOCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
999: P_CCProcessIUCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
1000: P_CCPrjFlagTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
1001: P_calling_mode IN VARCHAR2 ,
1002: /* Added nocopy for 2672653 */

Line 999: P_CCProcessIUCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,

995: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
996: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
997: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
998: P_CCProcessIOCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
999: P_CCProcessIUCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
1000: P_CCPrjFlagTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
1001: P_calling_mode IN VARCHAR2 ,
1002: /* Added nocopy for 2672653 */
1003: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

Line 1000: P_CCPrjFlagTab IN PA_PLSQL_DATATYPES.Char1TabTyp,

996: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
997: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
998: P_CCProcessIOCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
999: P_CCProcessIUCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
1000: P_CCPrjFlagTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
1001: P_calling_mode IN VARCHAR2 ,
1002: /* Added nocopy for 2672653 */
1003: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1004: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,

Line 1003: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

999: P_CCProcessIUCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
1000: P_CCPrjFlagTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
1001: P_calling_mode IN VARCHAR2 ,
1002: /* Added nocopy for 2672653 */
1003: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1004: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
1005: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
1006: X_Error_Stage OUT NOCOPY VARCHAR2,
1007: X_Error_Code OUT NOCOPY NUMBER) IS

Line 1004: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,

1000: P_CCPrjFlagTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
1001: P_calling_mode IN VARCHAR2 ,
1002: /* Added nocopy for 2672653 */
1003: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1004: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
1005: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
1006: X_Error_Stage OUT NOCOPY VARCHAR2,
1007: X_Error_Code OUT NOCOPY NUMBER) IS
1008:

Line 1005: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,

1001: P_calling_mode IN VARCHAR2 ,
1002: /* Added nocopy for 2672653 */
1003: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1004: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
1005: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
1006: X_Error_Stage OUT NOCOPY VARCHAR2,
1007: X_Error_Code OUT NOCOPY NUMBER) IS
1008:
1009: ----------------------------------------------------------------------------------------

Line 1028: l_CallExtnTab PA_PLSQL_DATATYPES.Char1TabTyp;

1024: l_PrevCrossChargeCode VARCHAR2(1);
1025: l_PrevCrossChargeType VARCHAR2(3);
1026:
1027: ----------------------------------------------------------------------------------------
1028: l_CallExtnTab PA_PLSQL_DATATYPES.Char1TabTyp;
1029: l_OvrridCrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
1030: l_MaxRecs NUMBER;
1031: l_MinRecs NUMBER;
1032: l_Recvr_Organization_Id NUMBER;

Line 1029: l_OvrridCrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;

1025: l_PrevCrossChargeType VARCHAR2(3);
1026:
1027: ----------------------------------------------------------------------------------------
1028: l_CallExtnTab PA_PLSQL_DATATYPES.Char1TabTyp;
1029: l_OvrridCrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
1030: l_MaxRecs NUMBER;
1031: l_MinRecs NUMBER;
1032: l_Recvr_Organization_Id NUMBER;
1033: l_Recvr_Org_Id NUMBER;