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_UnmatchedNegativeTxnFlagTab PA_PLSQL_DATATYPES.Char1TabTyp

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_UnmatchedNegativeTxnFlagTab PA_PLSQL_DATATYPES.Char1TabTyp
323: default PA_PLSQL_DATATYPES.EmptyChar1Tab; -- added bug 14173646

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_UnmatchedNegativeTxnFlagTab PA_PLSQL_DATATYPES.Char1TabTyp
323: default PA_PLSQL_DATATYPES.EmptyChar1Tab; -- added bug 14173646
324: l_CrossChargeTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;

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_UnmatchedNegativeTxnFlagTab PA_PLSQL_DATATYPES.Char1TabTyp
323: default PA_PLSQL_DATATYPES.EmptyChar1Tab; -- added bug 14173646
324: l_CrossChargeTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
325: l_CrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;

Line 322: l_UnmatchedNegativeTxnFlagTab PA_PLSQL_DATATYPES.Char1TabTyp

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_UnmatchedNegativeTxnFlagTab PA_PLSQL_DATATYPES.Char1TabTyp
323: default PA_PLSQL_DATATYPES.EmptyChar1Tab; -- added bug 14173646
324: l_CrossChargeTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
325: l_CrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
326: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;

Line 323: default PA_PLSQL_DATATYPES.EmptyChar1Tab; -- added bug 14173646

319: l_NLROrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
320: l_PrvdrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
321: l_RecvrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
322: l_UnmatchedNegativeTxnFlagTab PA_PLSQL_DATATYPES.Char1TabTyp
323: default PA_PLSQL_DATATYPES.EmptyChar1Tab; -- added bug 14173646
324: l_CrossChargeTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
325: l_CrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
326: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
327: l_CCProcessIUCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;

Line 324: l_CrossChargeTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;

320: l_PrvdrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
321: l_RecvrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
322: l_UnmatchedNegativeTxnFlagTab PA_PLSQL_DATATYPES.Char1TabTyp
323: default PA_PLSQL_DATATYPES.EmptyChar1Tab; -- added bug 14173646
324: l_CrossChargeTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
325: l_CrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
326: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
327: l_CCProcessIUCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
328: l_PrvdrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 325: l_CrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;

321: l_RecvrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
322: l_UnmatchedNegativeTxnFlagTab PA_PLSQL_DATATYPES.Char1TabTyp
323: default PA_PLSQL_DATATYPES.EmptyChar1Tab; -- added bug 14173646
324: l_CrossChargeTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
325: l_CrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
326: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
327: l_CCProcessIUCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
328: l_PrvdrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
329: l_RecvrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 326: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;

322: l_UnmatchedNegativeTxnFlagTab PA_PLSQL_DATATYPES.Char1TabTyp
323: default PA_PLSQL_DATATYPES.EmptyChar1Tab; -- added bug 14173646
324: l_CrossChargeTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
325: l_CrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
326: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
327: l_CCProcessIUCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
328: l_PrvdrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
329: l_RecvrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
330: l_PrvdrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 327: l_CCProcessIUCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;

323: default PA_PLSQL_DATATYPES.EmptyChar1Tab; -- added bug 14173646
324: l_CrossChargeTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
325: l_CrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
326: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
327: l_CCProcessIUCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
328: l_PrvdrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
329: l_RecvrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
330: l_PrvdrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
331: l_RecvrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 328: l_PrvdrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;

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

Line 329: l_RecvrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;

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

Line 330: l_PrvdrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;

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

Line 331: l_RecvrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;

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

Line 334: l_StageTab PA_PLSQL_DATATYPES.NewAmtTabTyp;

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

Line 335: l_StatusTab PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 432: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

428:
429: END PA_CC_IDENTIFY_TXN_ADJ;
430:
431: PROCEDURE PA_CC_IDENTIFY_TXN(
432: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
433: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
434: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
435: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
436: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,

Line 433: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,

429: END PA_CC_IDENTIFY_TXN_ADJ;
430:
431: PROCEDURE PA_CC_IDENTIFY_TXN(
432: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
433: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
434: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
435: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
436: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
437: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 434: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

430:
431: PROCEDURE PA_CC_IDENTIFY_TXN(
432: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
433: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
434: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
435: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
436: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
437: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
438: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 435: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

431: PROCEDURE PA_CC_IDENTIFY_TXN(
432: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
433: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
434: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
435: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
436: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
437: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
438: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
439: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

Line 436: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,

432: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
433: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
434: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
435: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
436: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
437: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
438: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
439: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
440: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

Line 437: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

433: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
434: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
435: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
436: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
437: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
438: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
439: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
440: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
441: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 438: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

434: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
435: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
436: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
437: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
438: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
439: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
440: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
441: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
442: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 439: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

435: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
436: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
437: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
438: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
439: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
440: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
441: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
442: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
443: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

Line 440: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

436: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
437: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
438: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
439: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
440: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
441: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
442: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
443: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
444: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 441: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

437: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
438: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
439: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
440: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
441: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
442: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
443: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
444: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
445: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 442: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

438: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
439: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
440: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
441: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
442: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
443: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
444: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
445: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
446: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 443: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

439: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
440: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
441: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
442: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
443: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
444: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
445: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
446: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
447: /* Added nocopy for 2672653 */

Line 444: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

440: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
441: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
442: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
443: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
444: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
445: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
446: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
447: /* Added nocopy for 2672653 */
448: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

Line 445: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

441: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
442: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
443: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
444: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
445: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
446: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
447: /* Added nocopy for 2672653 */
448: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
449: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,

Line 446: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

442: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
443: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
444: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
445: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
446: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
447: /* Added nocopy for 2672653 */
448: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
449: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
450: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,

Line 448: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

444: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
445: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
446: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
447: /* Added nocopy for 2672653 */
448: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
449: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
450: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
451: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
452: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

Line 449: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,

445: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
446: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
447: /* Added nocopy for 2672653 */
448: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
449: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
450: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
451: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
452: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
453: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

Line 450: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,

446: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
447: /* Added nocopy for 2672653 */
448: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
449: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
450: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
451: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
452: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
453: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
454: X_Error_Stage OUT NOCOPY VARCHAR2,

Line 451: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

447: /* Added nocopy for 2672653 */
448: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
449: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
450: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
451: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
452: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
453: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
454: X_Error_Stage OUT NOCOPY VARCHAR2,
455: X_Error_Code OUT NOCOPY NUMBER,

Line 452: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

448: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
449: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
450: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
451: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
452: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
453: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
454: X_Error_Stage OUT NOCOPY VARCHAR2,
455: X_Error_Code OUT NOCOPY NUMBER,
456: /* Added calling module for 3234973 */

Line 453: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

449: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
450: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
451: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
452: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
453: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
454: X_Error_Stage OUT NOCOPY VARCHAR2,
455: X_Error_Code OUT NOCOPY NUMBER,
456: /* Added calling module for 3234973 */
457: X_Calling_Module IN VARCHAR2)

Line 461: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;

457: X_Calling_Module IN VARCHAR2)
458:
459: IS
460:
461: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
462: l_CCProcessIUCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
463: l_CCPrjFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
464:
465:

Line 462: l_CCProcessIUCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;

458:
459: IS
460:
461: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
462: l_CCProcessIUCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
463: l_CCPrjFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
464:
465:
466: l_CCProcessIOCode VARCHAR2(1);

Line 463: l_CCPrjFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;

459: IS
460:
461: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
462: l_CCProcessIUCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
463: l_CCPrjFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
464:
465:
466: l_CCProcessIOCode VARCHAR2(1);
467: l_CCProcessIUCode VARCHAR2(1);

Line 554: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

550:
551: END PA_CC_IDENTIFY_TXN;
552:
553: PROCEDURE PA_CC_GET_PRVDR_RECVR_ORGS (
554: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
555: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
556: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
557: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
558: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

Line 555: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,

551: END PA_CC_IDENTIFY_TXN;
552:
553: PROCEDURE PA_CC_GET_PRVDR_RECVR_ORGS (
554: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
555: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
556: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
557: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
558: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
559: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 556: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

552:
553: PROCEDURE PA_CC_GET_PRVDR_RECVR_ORGS (
554: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
555: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
556: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
557: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
558: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
559: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
560: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 557: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

553: PROCEDURE PA_CC_GET_PRVDR_RECVR_ORGS (
554: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
555: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
556: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
557: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
558: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
559: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
560: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
561: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,

Line 558: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

554: P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
555: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
556: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
557: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
558: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
559: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
560: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
561: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
562: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

Line 559: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

555: P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
556: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
557: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
558: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
559: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
560: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
561: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
562: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
563: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 560: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

556: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
557: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
558: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
559: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
560: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
561: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
562: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
563: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
564: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 561: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,

557: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
558: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
559: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
560: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
561: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
562: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
563: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
564: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
565: /* Added nocopy for 2672653 */

Line 562: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

558: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
559: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
560: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
561: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
562: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
563: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
564: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
565: /* Added nocopy for 2672653 */
566: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp, -- added bug 14173646

Line 563: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

559: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
560: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
561: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
562: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
563: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
564: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
565: /* Added nocopy for 2672653 */
566: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp, -- added bug 14173646
567: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

Line 564: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

560: P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
561: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
562: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
563: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
564: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
565: /* Added nocopy for 2672653 */
566: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp, -- added bug 14173646
567: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
568: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

Line 566: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp, -- added bug 14173646

562: P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
563: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
564: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
565: /* Added nocopy for 2672653 */
566: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp, -- added bug 14173646
567: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
568: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
569: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
570: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

Line 567: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

563: P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
564: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
565: /* Added nocopy for 2672653 */
566: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp, -- added bug 14173646
567: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
568: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
569: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
570: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
571: X_CCProcessIOCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,

Line 568: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

564: P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
565: /* Added nocopy for 2672653 */
566: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp, -- added bug 14173646
567: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
568: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
569: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
570: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
571: X_CCProcessIOCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
572: X_CCProcessIUCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,

Line 569: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

565: /* Added nocopy for 2672653 */
566: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp, -- added bug 14173646
567: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
568: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
569: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
570: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
571: X_CCProcessIOCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
572: X_CCProcessIUCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
573: X_CCPrjFlagTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,

Line 570: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

566: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp, -- added bug 14173646
567: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
568: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
569: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
570: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
571: X_CCProcessIOCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
572: X_CCProcessIUCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
573: X_CCPrjFlagTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
574: X_Error_Stage OUT NOCOPY VARCHAR2,

Line 571: X_CCProcessIOCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,

567: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
568: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
569: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
570: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
571: X_CCProcessIOCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
572: X_CCProcessIUCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
573: X_CCPrjFlagTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
574: X_Error_Stage OUT NOCOPY VARCHAR2,
575: X_Error_Code OUT NOCOPY NUMBER,

Line 572: X_CCProcessIUCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,

568: X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
569: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
570: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
571: X_CCProcessIOCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
572: X_CCProcessIUCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
573: X_CCPrjFlagTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
574: X_Error_Stage OUT NOCOPY VARCHAR2,
575: X_Error_Code OUT NOCOPY NUMBER,
576: /* Added calling module for 3234973 */

Line 573: X_CCPrjFlagTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,

569: X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
570: X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
571: X_CCProcessIOCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
572: X_CCProcessIUCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
573: X_CCPrjFlagTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
574: X_Error_Stage OUT NOCOPY VARCHAR2,
575: X_Error_Code OUT NOCOPY NUMBER,
576: /* Added calling module for 3234973 */
577: X_Calling_Module IN VARCHAR2) IS

Line 605: l_UnmatchedNegativeTxnFlagTab PA_PLSQL_DATATYPES.Char1TabTyp

601: l_current_process_io_code VARCHAR2(1);
602: l_current_process_iu_code VARCHAR2(1);
603: l_PrevCCProcessIOCode VARCHAR2(1);
604: l_PrevCCProcessIUCode VARCHAR2(1);
605: l_UnmatchedNegativeTxnFlagTab PA_PLSQL_DATATYPES.Char1TabTyp
606: default PA_PLSQL_DATATYPES.EmptyChar1Tab; -- added bug 14173646
607:
608:
609: /* added the GetAdjExpid cursor as part of Bug 12955494 */

Line 606: default PA_PLSQL_DATATYPES.EmptyChar1Tab; -- added bug 14173646

602: l_current_process_iu_code VARCHAR2(1);
603: l_PrevCCProcessIOCode VARCHAR2(1);
604: l_PrevCCProcessIUCode VARCHAR2(1);
605: l_UnmatchedNegativeTxnFlagTab PA_PLSQL_DATATYPES.Char1TabTyp
606: default PA_PLSQL_DATATYPES.EmptyChar1Tab; -- added bug 14173646
607:
608:
609: /* added the GetAdjExpid cursor as part of Bug 12955494 */
610:

Line 1051: P_PrvdrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

1047:
1048: END PA_CC_GET_PRVDR_RECVR_ORGS ;
1049:
1050: PROCEDURE PA_CC_GET_CROSS_CHARGE_TYPE (
1051: P_PrvdrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1052: P_RecvrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1053: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1054: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1055: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

Line 1052: P_RecvrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

1048: END PA_CC_GET_PRVDR_RECVR_ORGS ;
1049:
1050: PROCEDURE PA_CC_GET_CROSS_CHARGE_TYPE (
1051: P_PrvdrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1052: P_RecvrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1053: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1054: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1055: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
1056: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 1053: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

1049:
1050: PROCEDURE PA_CC_GET_CROSS_CHARGE_TYPE (
1051: P_PrvdrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1052: P_RecvrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1053: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1054: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1055: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
1056: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1057: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 1054: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

1050: PROCEDURE PA_CC_GET_CROSS_CHARGE_TYPE (
1051: P_PrvdrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1052: P_RecvrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1053: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1054: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1055: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
1056: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1057: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1058: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,

Line 1055: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

1051: P_PrvdrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1052: P_RecvrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1053: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1054: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1055: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
1056: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1057: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1058: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
1059: P_PrvdrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 1056: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

1052: P_RecvrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1053: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1054: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1055: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
1056: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1057: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1058: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
1059: P_PrvdrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1060: P_RecvrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 1057: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

1053: P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1054: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1055: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
1056: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1057: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1058: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
1059: P_PrvdrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1060: P_RecvrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1061: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 1058: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,

1054: P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1055: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
1056: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1057: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1058: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
1059: P_PrvdrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1060: P_RecvrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1061: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1062: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 1059: P_PrvdrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

1055: P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
1056: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1057: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1058: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
1059: P_PrvdrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1060: P_RecvrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1061: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1062: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1063: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

Line 1060: P_RecvrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

1056: P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1057: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1058: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
1059: P_PrvdrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1060: P_RecvrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1061: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1062: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1063: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
1064: P_CCProcessIOCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,

Line 1061: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

1057: P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1058: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
1059: P_PrvdrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1060: P_RecvrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1061: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1062: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1063: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
1064: P_CCProcessIOCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
1065: P_CCProcessIUCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,

Line 1062: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,

1058: P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
1059: P_PrvdrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1060: P_RecvrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1061: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1062: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1063: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
1064: P_CCProcessIOCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
1065: P_CCProcessIUCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
1066: P_CCPrjFlagTab IN PA_PLSQL_DATATYPES.Char1TabTyp,

Line 1063: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,

1059: P_PrvdrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1060: P_RecvrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1061: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1062: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1063: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
1064: P_CCProcessIOCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
1065: P_CCProcessIUCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
1066: P_CCPrjFlagTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
1067: P_calling_mode IN VARCHAR2 ,

Line 1064: P_CCProcessIOCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,

1060: P_RecvrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1061: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1062: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1063: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
1064: P_CCProcessIOCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
1065: P_CCProcessIUCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
1066: P_CCPrjFlagTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
1067: P_calling_mode IN VARCHAR2 ,
1068: /* Added nocopy for 2672653 */

Line 1065: P_CCProcessIUCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,

1061: P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1062: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1063: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
1064: P_CCProcessIOCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
1065: P_CCProcessIUCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
1066: P_CCPrjFlagTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
1067: P_calling_mode IN VARCHAR2 ,
1068: /* Added nocopy for 2672653 */
1069: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

Line 1066: P_CCPrjFlagTab IN PA_PLSQL_DATATYPES.Char1TabTyp,

1062: P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
1063: P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
1064: P_CCProcessIOCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
1065: P_CCProcessIUCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
1066: P_CCPrjFlagTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
1067: P_calling_mode IN VARCHAR2 ,
1068: /* Added nocopy for 2672653 */
1069: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1070: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,

Line 1069: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

1065: P_CCProcessIUCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
1066: P_CCPrjFlagTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
1067: P_calling_mode IN VARCHAR2 ,
1068: /* Added nocopy for 2672653 */
1069: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1070: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
1071: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
1072: X_Error_Stage OUT NOCOPY VARCHAR2,
1073: X_Error_Code OUT NOCOPY NUMBER) IS

Line 1070: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,

1066: P_CCPrjFlagTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
1067: P_calling_mode IN VARCHAR2 ,
1068: /* Added nocopy for 2672653 */
1069: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1070: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
1071: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
1072: X_Error_Stage OUT NOCOPY VARCHAR2,
1073: X_Error_Code OUT NOCOPY NUMBER) IS
1074:

Line 1071: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,

1067: P_calling_mode IN VARCHAR2 ,
1068: /* Added nocopy for 2672653 */
1069: X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1070: X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
1071: X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
1072: X_Error_Stage OUT NOCOPY VARCHAR2,
1073: X_Error_Code OUT NOCOPY NUMBER) IS
1074:
1075: ----------------------------------------------------------------------------------------

Line 1094: l_CallExtnTab PA_PLSQL_DATATYPES.Char1TabTyp;

1090: l_PrevCrossChargeCode VARCHAR2(1);
1091: l_PrevCrossChargeType VARCHAR2(3);
1092:
1093: ----------------------------------------------------------------------------------------
1094: l_CallExtnTab PA_PLSQL_DATATYPES.Char1TabTyp;
1095: l_OvrridCrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
1096: l_MaxRecs NUMBER;
1097: l_MinRecs NUMBER;
1098: l_Recvr_Organization_Id NUMBER;

Line 1095: l_OvrridCrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;

1091: l_PrevCrossChargeType VARCHAR2(3);
1092:
1093: ----------------------------------------------------------------------------------------
1094: l_CallExtnTab PA_PLSQL_DATATYPES.Char1TabTyp;
1095: l_OvrridCrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
1096: l_MaxRecs NUMBER;
1097: l_MinRecs NUMBER;
1098: l_Recvr_Organization_Id NUMBER;
1099: l_Recvr_Org_Id NUMBER;

Line 1113: l_UnmatchedNegativeTxnFlagTab PA_PLSQL_DATATYPES.Char1TabTyp

1109: l_cross_charge_type VARCHAR2(3);
1110: l_cc_tr_src_process_flag VARCHAR2(1);
1111: l_cc_prj_process_flag VARCHAR2(1);
1112: l_calling_module VARCHAR2(100);
1113: l_UnmatchedNegativeTxnFlagTab PA_PLSQL_DATATYPES.Char1TabTyp
1114: default PA_PLSQL_DATATYPES.EmptyChar1Tab; -- added bug 14173646
1115:
1116:
1117: CURSOR GetCCOrgRel(c_prvdr_org_id NUMBER,

Line 1114: default PA_PLSQL_DATATYPES.EmptyChar1Tab; -- added bug 14173646

1110: l_cc_tr_src_process_flag VARCHAR2(1);
1111: l_cc_prj_process_flag VARCHAR2(1);
1112: l_calling_module VARCHAR2(100);
1113: l_UnmatchedNegativeTxnFlagTab PA_PLSQL_DATATYPES.Char1TabTyp
1114: default PA_PLSQL_DATATYPES.EmptyChar1Tab; -- added bug 14173646
1115:
1116:
1117: CURSOR GetCCOrgRel(c_prvdr_org_id NUMBER,
1118: c_recvr_org_id NUMBER) IS