[Home] [Help]
25:
26: -- Bug 5709596
27: -- Table of Payment Process Profiles
28: --
29: TYPE paymentProfilesTabType IS TABLE OF IBY_PAYMENT_PROFILES%ROWTYPE
30: INDEX BY BINARY_INTEGER;
31:
32: paymentProfilesTab paymentProfilesTabType;
33:
391: IBY_PMT_CREATION_RULES.group_by_due_date_flag%TYPE
392: INDEX BY BINARY_INTEGER;
393:
394: TYPE t_processing_type IS TABLE OF
395: IBY_PAYMENT_PROFILES.processing_type%TYPE
396: INDEX BY BINARY_INTEGER;
397: TYPE t_declaration_option IS TABLE OF
398: IBY_PAYMENT_PROFILES.declaration_option%TYPE
399: INDEX BY BINARY_INTEGER;
394: TYPE t_processing_type IS TABLE OF
395: IBY_PAYMENT_PROFILES.processing_type%TYPE
396: INDEX BY BINARY_INTEGER;
397: TYPE t_declaration_option IS TABLE OF
398: IBY_PAYMENT_PROFILES.declaration_option%TYPE
399: INDEX BY BINARY_INTEGER;
400: TYPE t_dcl_only_foren_curr_pmt_flag IS TABLE OF
401: IBY_PAYMENT_PROFILES.dcl_only_foreign_curr_pmt_flag%TYPE
402: INDEX BY BINARY_INTEGER;
397: TYPE t_declaration_option IS TABLE OF
398: IBY_PAYMENT_PROFILES.declaration_option%TYPE
399: INDEX BY BINARY_INTEGER;
400: TYPE t_dcl_only_foren_curr_pmt_flag IS TABLE OF
401: IBY_PAYMENT_PROFILES.dcl_only_foreign_curr_pmt_flag%TYPE
402: INDEX BY BINARY_INTEGER;
403: TYPE t_dcl_curr_fx_rate_type IS TABLE OF
404: IBY_PAYMENT_PROFILES.declaration_curr_fx_rate_type%TYPE
405: INDEX BY BINARY_INTEGER;
400: TYPE t_dcl_only_foren_curr_pmt_flag IS TABLE OF
401: IBY_PAYMENT_PROFILES.dcl_only_foreign_curr_pmt_flag%TYPE
402: INDEX BY BINARY_INTEGER;
403: TYPE t_dcl_curr_fx_rate_type IS TABLE OF
404: IBY_PAYMENT_PROFILES.declaration_curr_fx_rate_type%TYPE
405: INDEX BY BINARY_INTEGER;
406: TYPE t_declaration_currency_code IS TABLE OF
407: IBY_PAYMENT_PROFILES.declaration_currency_code%TYPE
408: INDEX BY BINARY_INTEGER;
403: TYPE t_dcl_curr_fx_rate_type IS TABLE OF
404: IBY_PAYMENT_PROFILES.declaration_curr_fx_rate_type%TYPE
405: INDEX BY BINARY_INTEGER;
406: TYPE t_declaration_currency_code IS TABLE OF
407: IBY_PAYMENT_PROFILES.declaration_currency_code%TYPE
408: INDEX BY BINARY_INTEGER;
409: TYPE t_declaration_threshold_amount IS TABLE OF
410: IBY_PAYMENT_PROFILES.declaration_threshold_amount%TYPE
411: INDEX BY BINARY_INTEGER;
406: TYPE t_declaration_currency_code IS TABLE OF
407: IBY_PAYMENT_PROFILES.declaration_currency_code%TYPE
408: INDEX BY BINARY_INTEGER;
409: TYPE t_declaration_threshold_amount IS TABLE OF
410: IBY_PAYMENT_PROFILES.declaration_threshold_amount%TYPE
411: INDEX BY BINARY_INTEGER;
412:
413: TYPE t_maximum_payment_amount IS TABLE OF
414: IBY_PAY_SERVICE_REQUESTS.maximum_payment_amount%TYPE
1132: | NOTES:
1133: |
1134: *---------------------------------------------------------------------*/
1135: PROCEDURE set_profile_attribs(
1136: p_profile_id IN IBY_PAYMENT_PROFILES.payment_profile_id%TYPE
1137: );
1138:
1139: /*--------------------------------------------------------------------
1140: | NAME:
1156: | NOTES:
1157: |
1158: *---------------------------------------------------------------------*/
1159: PROCEDURE get_profile_process_attribs(
1160: p_profile_id IN IBY_PAYMENT_PROFILES.payment_profile_id%TYPE,
1161: x_profile_attribs IN OUT NOCOPY profileProcessAttribs
1162: );
1163:
1164: /*--------------------------------------------------------------------
1180: | NOTES:
1181: |
1182: *---------------------------------------------------------------------*/
1183: PROCEDURE checkIfDefaultPmtDocOnProfile (
1184: p_profile_id IN IBY_PAYMENT_PROFILES.payment_profile_id%TYPE,
1185: x_profile_name IN OUT NOCOPY IBY_PAYMENT_PROFILES.system_profile_name%TYPE,
1186: x_return_flag IN OUT NOCOPY BOOLEAN
1187: );
1188:
1181: |
1182: *---------------------------------------------------------------------*/
1183: PROCEDURE checkIfDefaultPmtDocOnProfile (
1184: p_profile_id IN IBY_PAYMENT_PROFILES.payment_profile_id%TYPE,
1185: x_profile_name IN OUT NOCOPY IBY_PAYMENT_PROFILES.system_profile_name%TYPE,
1186: x_return_flag IN OUT NOCOPY BOOLEAN
1187: );
1188:
1189: /*--------------------------------------------------------------------