416: SELECT global_attribute1,
417: global_attribute2
418: INTO x_enable_bank_coll,
419: x_enable_association
420: FROM ap_system_parameters;
421:
422: IF x_enable_bank_coll = 'Y' THEN
423: IF x_enable_association = 'Y' THEN
424: associate_coll_doc( bank_collection_id_e, association_method_e,
461: association_method_e IN VARCHAR2,
462: bank_collection_id_s IN OUT NOCOPY NUMBER,
463: associate_flag_s IN OUT NOCOPY VARCHAR2 )
464: IS
465: x_enable_bank_coll ap_system_parameters.global_attribute1%TYPE;
466: x_enable_association ap_system_parameters.global_attribute2%TYPE;
467: x_payment_status_flag ap_payment_schedules.payment_status_flag%TYPE;
468: /*-----------------------------------------------------------*/
469: /* ASSOCIATE_TRADE_NOTE */
462: bank_collection_id_s IN OUT NOCOPY NUMBER,
463: associate_flag_s IN OUT NOCOPY VARCHAR2 )
464: IS
465: x_enable_bank_coll ap_system_parameters.global_attribute1%TYPE;
466: x_enable_association ap_system_parameters.global_attribute2%TYPE;
467: x_payment_status_flag ap_payment_schedules.payment_status_flag%TYPE;
468: /*-----------------------------------------------------------*/
469: /* ASSOCIATE_TRADE_NOTE */
470: /*-----------------------------------------------------------*/
865:
866: BEGIN
867: SELECT global_attribute1
868: INTO x_enable_bank_coll
869: FROM ap_system_parameters;
870:
871: SELECT global_attribute1
872: INTO x_enable_association
873: FROM ap_invoices