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,
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,
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
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:
26: --
27: --
28: TYPE unassignedDocRec IS RECORD (
29: document_id
30: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
31: calling_app_id
32: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
33: calling_app_doc_id1
34: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
28: TYPE unassignedDocRec IS RECORD (
29: document_id
30: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
31: calling_app_id
32: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
33: calling_app_doc_id1
34: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
35: calling_app_doc_id2
36: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
30: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
31: calling_app_id
32: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
33: calling_app_doc_id1
34: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
35: calling_app_doc_id2
36: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
37: calling_app_doc_id3
38: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
32: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
33: calling_app_doc_id1
34: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
35: calling_app_doc_id2
36: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
37: calling_app_doc_id3
38: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
39: calling_app_doc_id4
40: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
34: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
35: calling_app_doc_id2
36: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
37: calling_app_doc_id3
38: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
39: calling_app_doc_id4
40: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
41: calling_app_doc_id5
42: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
36: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
37: calling_app_doc_id3
38: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
39: calling_app_doc_id4
40: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
41: calling_app_doc_id5
42: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
43: pay_proc_ttype_cd
44: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
38: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
39: calling_app_doc_id4
40: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
41: calling_app_doc_id5
42: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
43: pay_proc_ttype_cd
44: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
45: int_bank_acct_id
46: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE := -1,
40: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
41: calling_app_doc_id5
42: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
43: pay_proc_ttype_cd
44: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
45: int_bank_acct_id
46: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE := -1,
47: pay_profile_id
48: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE := -1
42: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
43: pay_proc_ttype_cd
44: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
45: int_bank_acct_id
46: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE := -1,
47: pay_profile_id
48: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE := -1
49: );
50:
44: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
45: int_bank_acct_id
46: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE := -1,
47: pay_profile_id
48: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE := -1
49: );
50:
51: TYPE unassignedDocsTabType IS TABLE OF unassignedDocRec
52: INDEX BY BINARY_INTEGER;
54: --
55: --
56: TYPE assignCriteriaType IS RECORD (
57: document_id
58: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
59: calling_app_id
60: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
61: calling_app_doc_id1
62: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
56: TYPE assignCriteriaType IS RECORD (
57: document_id
58: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
59: calling_app_id
60: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
61: calling_app_doc_id1
62: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
63: calling_app_doc_id2
64: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
58: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
59: calling_app_id
60: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
61: calling_app_doc_id1
62: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
63: calling_app_doc_id2
64: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
65: calling_app_doc_id3
66: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
60: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
61: calling_app_doc_id1
62: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
63: calling_app_doc_id2
64: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
65: calling_app_doc_id3
66: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
67: calling_app_doc_id4
68: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
62: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
63: calling_app_doc_id2
64: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
65: calling_app_doc_id3
66: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
67: calling_app_doc_id4
68: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
69: calling_app_doc_id5
70: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
64: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
65: calling_app_doc_id3
66: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
67: calling_app_doc_id4
68: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
69: calling_app_doc_id5
70: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
71: pay_proc_ttype_cd
72: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
66: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
67: calling_app_doc_id4
68: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
69: calling_app_doc_id5
70: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
71: pay_proc_ttype_cd
72: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
73: int_bank_acct_id
74: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
68: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
69: calling_app_doc_id5
70: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
71: pay_proc_ttype_cd
72: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
73: int_bank_acct_id
74: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
75: payment_profile_id
76: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
70: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
71: pay_proc_ttype_cd
72: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
73: int_bank_acct_id
74: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
75: payment_profile_id
76: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
77: payment_currency
78: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
72: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
73: int_bank_acct_id
74: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
75: payment_profile_id
76: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
77: payment_currency
78: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
79: payment_method
80: IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
74: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
75: payment_profile_id
76: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
77: payment_currency
78: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
79: payment_method
80: IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
81: payment_format
82: IBY_DOCS_PAYABLE_ALL.payment_format_code%TYPE,
76: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
77: payment_currency
78: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
79: payment_method
80: IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
81: payment_format
82: IBY_DOCS_PAYABLE_ALL.payment_format_code%TYPE,
83: org_id
84: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
78: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
79: payment_method
80: IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
81: payment_format
82: IBY_DOCS_PAYABLE_ALL.payment_format_code%TYPE,
83: org_id
84: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
85: org_type
86: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
80: IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
81: payment_format
82: IBY_DOCS_PAYABLE_ALL.payment_format_code%TYPE,
83: org_id
84: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
85: org_type
86: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
87: payment_date
88: IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
82: IBY_DOCS_PAYABLE_ALL.payment_format_code%TYPE,
83: org_id
84: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
85: org_type
86: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
87: payment_date
88: IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
89: ext_payee_id
90: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE
84: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
85: org_type
86: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
87: payment_date
88: IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
89: ext_payee_id
90: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE
91: );
92:
86: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
87: payment_date
88: IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
89: ext_payee_id
90: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE
91: );
92:
93: --
94: -- Table of assignment criteria.
98:
99: --
100: -- Table of bank accounts. Used by dummy CE API is available
101: --
102: TYPE bankAccounts IS TABLE OF IBY_DOCS_PAYABLE_ALL.
103: internal_bank_account_id%TYPE INDEX BY BINARY_INTEGER;
104:
105: --
106: --
106: --
107: --
108: TYPE setDocAttributesRec IS RECORD (
109: doc_id
110: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
111: ca_id
112: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
113: ca_doc_id1
114: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
108: TYPE setDocAttributesRec IS RECORD (
109: doc_id
110: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
111: ca_id
112: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
113: ca_doc_id1
114: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
115: ca_doc_id2
116: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
110: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
111: ca_id
112: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
113: ca_doc_id1
114: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
115: ca_doc_id2
116: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
117: ca_doc_id3
118: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
112: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
113: ca_doc_id1
114: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
115: ca_doc_id2
116: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
117: ca_doc_id3
118: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
119: ca_doc_id4
120: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
114: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
115: ca_doc_id2
116: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
117: ca_doc_id3
118: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
119: ca_doc_id4
120: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
121: ca_doc_id5
122: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
116: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
117: ca_doc_id3
118: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
119: ca_doc_id4
120: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
121: ca_doc_id5
122: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
123: pp_tt_cd
124: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
118: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
119: ca_doc_id4
120: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
121: ca_doc_id5
122: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
123: pp_tt_cd
124: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
125: int_bank_acct_id
126: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
120: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
121: ca_doc_id5
122: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
123: pp_tt_cd
124: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
125: int_bank_acct_id
126: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
127: pay_profile_id
128: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
122: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
123: pp_tt_cd
124: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
125: int_bank_acct_id
126: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
127: pay_profile_id
128: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
129: status
130: IBY_DOCS_PAYABLE_ALL.document_status%TYPE
124: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
125: int_bank_acct_id
126: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
127: pay_profile_id
128: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
129: status
130: IBY_DOCS_PAYABLE_ALL.document_status%TYPE
131: );
132:
126: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
127: pay_profile_id
128: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
129: status
130: IBY_DOCS_PAYABLE_ALL.document_status%TYPE
131: );
132:
133: --
134: -- Used to update of the IBY_DOCS_PAYABLE_ALL table.
130: IBY_DOCS_PAYABLE_ALL.document_status%TYPE
131: );
132:
133: --
134: -- Used to update of the IBY_DOCS_PAYABLE_ALL table.
135: --
136: TYPE setDocAttribsTabType IS TABLE OF setDocAttributesRec
137: INDEX BY BINARY_INTEGER;
138:
239: | NOTES:
240: |
241: *---------------------------------------------------------------------*/
242: PROCEDURE dummyCEAPI(
243: p_payCurrency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
244: p_pmtDate IN IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
245: p_OrgID IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
246: x_bankAccounts IN OUT NOCOPY IBY_ASSIGN_PUB.bankAccounts
247: );
240: |
241: *---------------------------------------------------------------------*/
242: PROCEDURE dummyCEAPI(
243: p_payCurrency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
244: p_pmtDate IN IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
245: p_OrgID IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
246: x_bankAccounts IN OUT NOCOPY IBY_ASSIGN_PUB.bankAccounts
247: );
248:
241: *---------------------------------------------------------------------*/
242: PROCEDURE dummyCEAPI(
243: p_payCurrency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
244: p_pmtDate IN IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
245: p_OrgID IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
246: x_bankAccounts IN OUT NOCOPY IBY_ASSIGN_PUB.bankAccounts
247: );
248:
249: /*--------------------------------------------------------------------
290: | NOTES:
291: |
292: *---------------------------------------------------------------------*/
293: FUNCTION getProfileFromProfileDrivers(
294: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
295: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
296: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
297: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
298: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
291: |
292: *---------------------------------------------------------------------*/
293: FUNCTION getProfileFromProfileDrivers(
294: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
295: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
296: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
297: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
298: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
299: ) RETURN NUMBER;
292: *---------------------------------------------------------------------*/
293: FUNCTION getProfileFromProfileDrivers(
294: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
295: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
296: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
297: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
298: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
299: ) RETURN NUMBER;
300:
293: FUNCTION getProfileFromProfileDrivers(
294: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
295: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
296: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
297: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
298: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
299: ) RETURN NUMBER;
300:
301: /*--------------------------------------------------------------------
294: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
295: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
296: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
297: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
298: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
299: ) RETURN NUMBER;
300:
301: /*--------------------------------------------------------------------
302: | NAME:
318: | NOTES:
319: |
320: *---------------------------------------------------------------------*/
321: FUNCTION getProfileFromPayeeFormat(
322: p_payee_id IN IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE
323: ) RETURN NUMBER;
324:
325: /*--------------------------------------------------------------------
326: | NAME: