DBA Data[Home] [Help]

APPS.GMS_CMERGE dependencies on RA_CUSTOMER_MERGES

Line 10: old_customer_id ra_customer_merges.duplicate_id%TYPE;

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:

Line 11: new_customer_id ra_customer_merges.customer_id%TYPE;

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 );

Line 12: old_loc_customer_id ra_customer_merges.duplicate_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 );
16: --

Line 13: new_loc_customer_id ra_customer_merges.customer_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: --
17: END GMS_CMERGE;