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.IBY_ASSIGN_PUB dependencies on IBY_DOCS_PAYABLE_ALL

Line 8: IBY_DOCS_PAYABLE_ALL.payment_service_request_id%TYPE,

4: --
5: --
6: TYPE updateDocAttributesRec IS RECORD (
7: payment_request_id
8: IBY_DOCS_PAYABLE_ALL.payment_service_request_id%TYPE,
9: int_bank_acct_id
10: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
11: pay_profile_id
12: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,

Line 10: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,

6: TYPE updateDocAttributesRec IS RECORD (
7: payment_request_id
8: IBY_DOCS_PAYABLE_ALL.payment_service_request_id%TYPE,
9: int_bank_acct_id
10: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
11: pay_profile_id
12: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
13: bank_acct_flag
14: BOOLEAN,

Line 12: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,

8: IBY_DOCS_PAYABLE_ALL.payment_service_request_id%TYPE,
9: int_bank_acct_id
10: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
11: pay_profile_id
12: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
13: bank_acct_flag
14: BOOLEAN,
15: pay_profile_flag
16: BOOLEAN

Line 20: -- Used to update of the IBY_DOCS_PAYABLE_ALL table.

16: BOOLEAN
17: );
18:
19: --
20: -- Used to update of the IBY_DOCS_PAYABLE_ALL table.
21: --
22: --TYPE updateDocsTabType IS TABLE OF updateDocAttributesRec
23: -- INDEX BY BINARY_INTEGER;
24:

Line 30: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,

26: --
27: --
28: TYPE unassignedDocRec IS RECORD (
29: document_id
30: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
31: payment_currency_code
32: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
33: org_id
34: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,

Line 32: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,

28: TYPE unassignedDocRec IS RECORD (
29: document_id
30: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
31: payment_currency_code
32: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
33: org_id
34: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
35: payment_method_code
36: IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,

Line 34: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,

30: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
31: payment_currency_code
32: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
33: org_id
34: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
35: payment_method_code
36: IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
37: calling_app_id
38: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,

Line 36: IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,

32: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
33: org_id
34: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
35: payment_method_code
36: IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
37: calling_app_id
38: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
39: calling_app_doc_id1
40: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,

Line 38: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,

34: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
35: payment_method_code
36: IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
37: calling_app_id
38: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
39: calling_app_doc_id1
40: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
41: calling_app_doc_id2
42: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,

Line 40: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,

36: IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
37: calling_app_id
38: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
39: calling_app_doc_id1
40: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
41: calling_app_doc_id2
42: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
43: calling_app_doc_id3
44: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,

Line 42: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,

38: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
39: calling_app_doc_id1
40: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
41: calling_app_doc_id2
42: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
43: calling_app_doc_id3
44: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
45: calling_app_doc_id4
46: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,

Line 44: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,

40: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
41: calling_app_doc_id2
42: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
43: calling_app_doc_id3
44: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
45: calling_app_doc_id4
46: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
47: calling_app_doc_id5
48: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,

Line 46: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,

42: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
43: calling_app_doc_id3
44: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
45: calling_app_doc_id4
46: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
47: calling_app_doc_id5
48: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
49: pay_proc_ttype_cd
50: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,

Line 48: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,

44: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
45: calling_app_doc_id4
46: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
47: calling_app_doc_id5
48: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
49: pay_proc_ttype_cd
50: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
51: int_bank_acct_id
52: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE := -1,

Line 50: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,

46: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
47: calling_app_doc_id5
48: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
49: pay_proc_ttype_cd
50: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
51: int_bank_acct_id
52: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE := -1,
53: pay_profile_id
54: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE := -1

Line 52: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE := -1,

48: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
49: pay_proc_ttype_cd
50: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
51: int_bank_acct_id
52: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE := -1,
53: pay_profile_id
54: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE := -1
55: );
56:

Line 54: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE := -1

50: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
51: int_bank_acct_id
52: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE := -1,
53: pay_profile_id
54: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE := -1
55: );
56:
57: TYPE unassignedDocsTabType IS TABLE OF unassignedDocRec
58: INDEX BY BINARY_INTEGER;

Line 64: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,

60: --
61: --
62: TYPE assignCriteriaType IS RECORD (
63: document_id
64: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
65: calling_app_id
66: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
67: calling_app_doc_id1
68: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,

Line 66: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,

62: TYPE assignCriteriaType IS RECORD (
63: document_id
64: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
65: calling_app_id
66: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
67: calling_app_doc_id1
68: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
69: calling_app_doc_id2
70: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,

Line 68: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,

64: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
65: calling_app_id
66: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
67: calling_app_doc_id1
68: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
69: calling_app_doc_id2
70: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
71: calling_app_doc_id3
72: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,

Line 70: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,

66: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
67: calling_app_doc_id1
68: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
69: calling_app_doc_id2
70: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
71: calling_app_doc_id3
72: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
73: calling_app_doc_id4
74: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,

Line 72: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,

68: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
69: calling_app_doc_id2
70: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
71: calling_app_doc_id3
72: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
73: calling_app_doc_id4
74: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
75: calling_app_doc_id5
76: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,

Line 74: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,

70: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
71: calling_app_doc_id3
72: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
73: calling_app_doc_id4
74: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
75: calling_app_doc_id5
76: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
77: pay_proc_ttype_cd
78: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,

Line 76: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,

72: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
73: calling_app_doc_id4
74: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
75: calling_app_doc_id5
76: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
77: pay_proc_ttype_cd
78: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
79: int_bank_acct_id
80: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,

Line 78: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,

74: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
75: calling_app_doc_id5
76: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
77: pay_proc_ttype_cd
78: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
79: int_bank_acct_id
80: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
81: payment_profile_id
82: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,

Line 80: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,

76: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
77: pay_proc_ttype_cd
78: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
79: int_bank_acct_id
80: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
81: payment_profile_id
82: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
83: payment_currency
84: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,

Line 82: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,

78: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
79: int_bank_acct_id
80: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
81: payment_profile_id
82: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
83: payment_currency
84: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
85: payment_method
86: IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,

Line 84: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,

80: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
81: payment_profile_id
82: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
83: payment_currency
84: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
85: payment_method
86: IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
87: payment_format
88: IBY_DOCS_PAYABLE_ALL.payment_format_code%TYPE,

Line 86: IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,

82: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
83: payment_currency
84: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
85: payment_method
86: IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
87: payment_format
88: IBY_DOCS_PAYABLE_ALL.payment_format_code%TYPE,
89: org_id
90: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,

Line 88: IBY_DOCS_PAYABLE_ALL.payment_format_code%TYPE,

84: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
85: payment_method
86: IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
87: payment_format
88: IBY_DOCS_PAYABLE_ALL.payment_format_code%TYPE,
89: org_id
90: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
91: org_type
92: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,

Line 90: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,

86: IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
87: payment_format
88: IBY_DOCS_PAYABLE_ALL.payment_format_code%TYPE,
89: org_id
90: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
91: org_type
92: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
93: payment_date
94: IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,

Line 92: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,

88: IBY_DOCS_PAYABLE_ALL.payment_format_code%TYPE,
89: org_id
90: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
91: org_type
92: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
93: payment_date
94: IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
95: ext_payee_id
96: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE

Line 94: IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,

90: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
91: org_type
92: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
93: payment_date
94: IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
95: ext_payee_id
96: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE
97: );
98:

Line 96: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE

92: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
93: payment_date
94: IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
95: ext_payee_id
96: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE
97: );
98:
99: --
100: -- Table of assignment criteria.

Line 108: TYPE bankAccounts IS TABLE OF IBY_DOCS_PAYABLE_ALL.

104:
105: --
106: -- Table of bank accounts. Used by dummy CE API is available
107: --
108: TYPE bankAccounts IS TABLE OF IBY_DOCS_PAYABLE_ALL.
109: internal_bank_account_id%TYPE INDEX BY BINARY_INTEGER;
110:
111: --
112: --

Line 116: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,

112: --
113: --
114: TYPE setDocAttributesRec IS RECORD (
115: doc_id
116: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
117: ca_id
118: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
119: ca_doc_id1
120: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,

Line 118: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,

114: TYPE setDocAttributesRec IS RECORD (
115: doc_id
116: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
117: ca_id
118: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
119: ca_doc_id1
120: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
121: ca_doc_id2
122: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,

Line 120: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,

116: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
117: ca_id
118: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
119: ca_doc_id1
120: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
121: ca_doc_id2
122: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
123: ca_doc_id3
124: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,

Line 122: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,

118: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
119: ca_doc_id1
120: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
121: ca_doc_id2
122: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
123: ca_doc_id3
124: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
125: ca_doc_id4
126: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,

Line 124: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,

120: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
121: ca_doc_id2
122: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
123: ca_doc_id3
124: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
125: ca_doc_id4
126: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
127: ca_doc_id5
128: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,

Line 126: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,

122: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
123: ca_doc_id3
124: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
125: ca_doc_id4
126: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
127: ca_doc_id5
128: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
129: pp_tt_cd
130: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,

Line 128: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,

124: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
125: ca_doc_id4
126: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
127: ca_doc_id5
128: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
129: pp_tt_cd
130: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
131: int_bank_acct_id
132: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,

Line 130: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,

126: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
127: ca_doc_id5
128: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
129: pp_tt_cd
130: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
131: int_bank_acct_id
132: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
133: pay_profile_id
134: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,

Line 132: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,

128: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
129: pp_tt_cd
130: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
131: int_bank_acct_id
132: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
133: pay_profile_id
134: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
135: status
136: IBY_DOCS_PAYABLE_ALL.document_status%TYPE

Line 134: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,

130: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
131: int_bank_acct_id
132: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
133: pay_profile_id
134: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
135: status
136: IBY_DOCS_PAYABLE_ALL.document_status%TYPE
137: );
138:

Line 136: IBY_DOCS_PAYABLE_ALL.document_status%TYPE

132: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
133: pay_profile_id
134: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
135: status
136: IBY_DOCS_PAYABLE_ALL.document_status%TYPE
137: );
138:
139: --
140: -- Used to update of the IBY_DOCS_PAYABLE_ALL table.

Line 140: -- Used to update of the IBY_DOCS_PAYABLE_ALL table.

136: IBY_DOCS_PAYABLE_ALL.document_status%TYPE
137: );
138:
139: --
140: -- Used to update of the IBY_DOCS_PAYABLE_ALL table.
141: --
142: TYPE setDocAttribsTabType IS TABLE OF setDocAttributesRec
143: INDEX BY BINARY_INTEGER;
144:

Line 249: p_payCurrency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,

245: | NOTES:
246: |
247: *---------------------------------------------------------------------*/
248: PROCEDURE dummyCEAPI(
249: p_payCurrency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
250: p_pmtDate IN IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
251: p_OrgID IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
252: x_bankAccounts IN OUT NOCOPY IBY_ASSIGN_PUB.bankAccounts
253: );

Line 250: p_pmtDate IN IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,

246: |
247: *---------------------------------------------------------------------*/
248: PROCEDURE dummyCEAPI(
249: p_payCurrency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
250: p_pmtDate IN IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
251: p_OrgID IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
252: x_bankAccounts IN OUT NOCOPY IBY_ASSIGN_PUB.bankAccounts
253: );
254:

Line 251: p_OrgID IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,

247: *---------------------------------------------------------------------*/
248: PROCEDURE dummyCEAPI(
249: p_payCurrency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
250: p_pmtDate IN IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
251: p_OrgID IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
252: x_bankAccounts IN OUT NOCOPY IBY_ASSIGN_PUB.bankAccounts
253: );
254:
255: /*--------------------------------------------------------------------

Line 300: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,

296: | NOTES:
297: |
298: *---------------------------------------------------------------------*/
299: FUNCTION getProfileFromProfileDrivers(
300: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
301: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
302: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
303: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
304: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE

Line 301: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,

297: |
298: *---------------------------------------------------------------------*/
299: FUNCTION getProfileFromProfileDrivers(
300: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
301: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
302: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
303: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
304: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
305: ) RETURN NUMBER;

Line 302: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,

298: *---------------------------------------------------------------------*/
299: FUNCTION getProfileFromProfileDrivers(
300: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
301: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
302: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
303: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
304: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
305: ) RETURN NUMBER;
306:

Line 303: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,

299: FUNCTION getProfileFromProfileDrivers(
300: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
301: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
302: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
303: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
304: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
305: ) RETURN NUMBER;
306:
307: /*--------------------------------------------------------------------

Line 304: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE

300: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
301: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
302: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
303: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
304: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
305: ) RETURN NUMBER;
306:
307: /*--------------------------------------------------------------------
308: | NAME:

Line 328: p_payee_id IN IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE

324: | NOTES:
325: |
326: *---------------------------------------------------------------------*/
327: FUNCTION getProfileFromPayeeFormat(
328: p_payee_id IN IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE
329: ) RETURN NUMBER;
330:
331: /*--------------------------------------------------------------------
332: | NAME: