6:
7: var_award_id gms_awards_all.award_id%TYPE;
8: var_customer_id gms_awards_all.funding_source_id%TYPE;
9: var_bill_to_customer_id gms_awards_all.bill_to_customer_id%TYPE;
10: old_customer_id ra_customer_merges.duplicate_id%TYPE;
11: new_customer_id ra_customer_merges.customer_id%TYPE;
12: old_loc_customer_id ra_customer_merges.duplicate_id%TYPE;
13: new_loc_customer_id ra_customer_merges.customer_id%TYPE;
14:
7: var_award_id gms_awards_all.award_id%TYPE;
8: var_customer_id gms_awards_all.funding_source_id%TYPE;
9: var_bill_to_customer_id gms_awards_all.bill_to_customer_id%TYPE;
10: old_customer_id ra_customer_merges.duplicate_id%TYPE;
11: new_customer_id ra_customer_merges.customer_id%TYPE;
12: old_loc_customer_id ra_customer_merges.duplicate_id%TYPE;
13: new_loc_customer_id ra_customer_merges.customer_id%TYPE;
14:
15: PROCEDURE MERGE ( req_id IN NUMBER, set_no IN NUMBER, process_mode IN VARCHAR2 );
8: var_customer_id gms_awards_all.funding_source_id%TYPE;
9: var_bill_to_customer_id gms_awards_all.bill_to_customer_id%TYPE;
10: old_customer_id ra_customer_merges.duplicate_id%TYPE;
11: new_customer_id ra_customer_merges.customer_id%TYPE;
12: old_loc_customer_id ra_customer_merges.duplicate_id%TYPE;
13: new_loc_customer_id ra_customer_merges.customer_id%TYPE;
14:
15: PROCEDURE MERGE ( req_id IN NUMBER, set_no IN NUMBER, process_mode IN VARCHAR2 );
16: --
9: var_bill_to_customer_id gms_awards_all.bill_to_customer_id%TYPE;
10: old_customer_id ra_customer_merges.duplicate_id%TYPE;
11: new_customer_id ra_customer_merges.customer_id%TYPE;
12: old_loc_customer_id ra_customer_merges.duplicate_id%TYPE;
13: new_loc_customer_id ra_customer_merges.customer_id%TYPE;
14:
15: PROCEDURE MERGE ( req_id IN NUMBER, set_no IN NUMBER, process_mode IN VARCHAR2 );
16: --
17: END GMS_CMERGE;