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
1239: | NOTES:
1240: |
1241: *---------------------------------------------------------------------*/
1242: PROCEDURE set_profile_attribs(
1243: p_profile_id IN IBY_PAYMENT_PROFILES.payment_profile_id%TYPE
1244: );
1245:
1246: /*--------------------------------------------------------------------
1247: | NAME:
1263: | NOTES:
1264: |
1265: *---------------------------------------------------------------------*/
1266: PROCEDURE get_profile_process_attribs(
1267: p_profile_id IN IBY_PAYMENT_PROFILES.payment_profile_id%TYPE,
1268: x_profile_attribs IN OUT NOCOPY profileProcessAttribs
1269: );
1270:
1271: /*--------------------------------------------------------------------
1287: | NOTES:
1288: |
1289: *---------------------------------------------------------------------*/
1290: PROCEDURE checkIfDefaultPmtDocOnProfile (
1291: p_profile_id IN IBY_PAYMENT_PROFILES.payment_profile_id%TYPE,
1292: x_profile_name IN OUT NOCOPY IBY_PAYMENT_PROFILES.system_profile_name%TYPE,
1293: x_return_flag IN OUT NOCOPY BOOLEAN
1294: );
1295:
1288: |
1289: *---------------------------------------------------------------------*/
1290: PROCEDURE checkIfDefaultPmtDocOnProfile (
1291: p_profile_id IN IBY_PAYMENT_PROFILES.payment_profile_id%TYPE,
1292: x_profile_name IN OUT NOCOPY IBY_PAYMENT_PROFILES.system_profile_name%TYPE,
1293: x_return_flag IN OUT NOCOPY BOOLEAN
1294: );
1295:
1296: /*--------------------------------------------------------------------