DBA Data[Home] [Help]

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: 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,

Line 32: IBY_DOCS_PAYABLE_ALL.calling_app_id%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,

Line 34: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%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,

Line 36: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%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,

Line 38: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%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,

Line 40: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%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,

Line 42: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%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,

Line 44: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,

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

Line 46: IBY_DOCS_PAYABLE_ALL.internal_bank_account_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:

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

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;

Line 58: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,

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,

Line 60: IBY_DOCS_PAYABLE_ALL.calling_app_id%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,

Line 62: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%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,

Line 64: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%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,

Line 66: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%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,

Line 68: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%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,

Line 70: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%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,

Line 72: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%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,

Line 74: IBY_DOCS_PAYABLE_ALL.internal_bank_account_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,

Line 76: IBY_DOCS_PAYABLE_ALL.payment_profile_id%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,

Line 78: IBY_DOCS_PAYABLE_ALL.payment_currency_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,

Line 80: IBY_DOCS_PAYABLE_ALL.payment_method_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,

Line 82: IBY_DOCS_PAYABLE_ALL.payment_format_code%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,

Line 84: IBY_DOCS_PAYABLE_ALL.org_id%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,

Line 86: IBY_DOCS_PAYABLE_ALL.org_type%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

Line 88: IBY_DOCS_PAYABLE_ALL.payment_date%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:

Line 90: IBY_DOCS_PAYABLE_ALL.ext_payee_id%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:
93: --
94: -- Table of assignment criteria.

Line 102: TYPE bankAccounts IS TABLE OF IBY_DOCS_PAYABLE_ALL.

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: --

Line 110: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,

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,

Line 112: IBY_DOCS_PAYABLE_ALL.calling_app_id%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,

Line 114: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%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,

Line 116: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%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,

Line 118: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%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,

Line 120: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%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,

Line 122: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%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,

Line 124: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%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,

Line 126: IBY_DOCS_PAYABLE_ALL.internal_bank_account_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

Line 128: IBY_DOCS_PAYABLE_ALL.payment_profile_id%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:

Line 130: IBY_DOCS_PAYABLE_ALL.document_status%TYPE

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.

Line 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:

Line 243: p_payCurrency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,

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: );

Line 244: p_pmtDate IN IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,

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:

Line 245: p_OrgID IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,

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: /*--------------------------------------------------------------------

Line 294: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,

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

Line 295: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_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;

Line 296: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,

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:

Line 297: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,

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: /*--------------------------------------------------------------------

Line 298: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE

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:

Line 322: p_payee_id IN IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE

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: