DBA Data[Home] [Help]

APPS.OKL_LOCKBOX_HOOK dependencies on STANDARD

Line 135: or in addition to standard matching options, you can use this feature.

131: add a matching rule to Lockbox functionality.
132: If for example you need to match matching numbers and date passed to
133: Lockbox with numbers and dates in your own custom tables
134: custom_table.custom_number and custom_table.custom_date, instead of
135: or in addition to standard matching options, you can use this feature.
136: Or you can use this feature to match with other numbers and dates in
137: the existing Receivables tables, as the need arises.
138:
139: This procedure expects a row in the AR_LOOKUPS table with lookup_type

Line 143: finds it to be one of the non-standard (NOT built in core AR), it will

139: This procedure expects a row in the AR_LOOKUPS table with lookup_type
140: = 'ARLPLB_MATCHING_OPTION' and valid values for other columns required
141: for the customized option.
142: The master program arp_process_lockbox will fetch that row and if it
143: finds it to be one of the non-standard (NOT built in core AR), it will
144: pass the control to this procedure with the corresponding lookup_code
145: in your database.
146: The procedure should return a string that Dynamic SQL can use to open and
147: parse a cursor. You need to create this SQL string to replace the string