10: AR_NUMBER_DUMMY CONSTANT NUMBER(15) := -999999999999999;
11: AR_DATE_DUMMY CONSTANT DATE := to_date(1, 'J');
12:
13: /*-------------------------------------+
14: | WHO column values from ARP_GLOBAL |
15: +-------------------------------------*/
16:
17: pg_request_id number;
18: pg_program_application_id number;
941: END nowaitlock_fetch_f_trx_id;
942:
943: BEGIN
944: /* Populate the package header level variables from global variables */
945: pg_request_id := arp_global.request_id;
946: pg_program_application_id := arp_global.program_application_id;
947: pg_program_id := arp_global.program_id;
948: pg_program_update_date := arp_global.program_update_date;
949: pg_last_updated_by := arp_global.last_updated_by;
942:
943: BEGIN
944: /* Populate the package header level variables from global variables */
945: pg_request_id := arp_global.request_id;
946: pg_program_application_id := arp_global.program_application_id;
947: pg_program_id := arp_global.program_id;
948: pg_program_update_date := arp_global.program_update_date;
949: pg_last_updated_by := arp_global.last_updated_by;
950: pg_last_update_date := arp_global.last_update_date;
943: BEGIN
944: /* Populate the package header level variables from global variables */
945: pg_request_id := arp_global.request_id;
946: pg_program_application_id := arp_global.program_application_id;
947: pg_program_id := arp_global.program_id;
948: pg_program_update_date := arp_global.program_update_date;
949: pg_last_updated_by := arp_global.last_updated_by;
950: pg_last_update_date := arp_global.last_update_date;
951: pg_last_update_login := arp_global.last_update_login;
944: /* Populate the package header level variables from global variables */
945: pg_request_id := arp_global.request_id;
946: pg_program_application_id := arp_global.program_application_id;
947: pg_program_id := arp_global.program_id;
948: pg_program_update_date := arp_global.program_update_date;
949: pg_last_updated_by := arp_global.last_updated_by;
950: pg_last_update_date := arp_global.last_update_date;
951: pg_last_update_login := arp_global.last_update_login;
952: pg_set_of_books_id := arp_global.set_of_books_id;
945: pg_request_id := arp_global.request_id;
946: pg_program_application_id := arp_global.program_application_id;
947: pg_program_id := arp_global.program_id;
948: pg_program_update_date := arp_global.program_update_date;
949: pg_last_updated_by := arp_global.last_updated_by;
950: pg_last_update_date := arp_global.last_update_date;
951: pg_last_update_login := arp_global.last_update_login;
952: pg_set_of_books_id := arp_global.set_of_books_id;
953:
946: pg_program_application_id := arp_global.program_application_id;
947: pg_program_id := arp_global.program_id;
948: pg_program_update_date := arp_global.program_update_date;
949: pg_last_updated_by := arp_global.last_updated_by;
950: pg_last_update_date := arp_global.last_update_date;
951: pg_last_update_login := arp_global.last_update_login;
952: pg_set_of_books_id := arp_global.set_of_books_id;
953:
954: END ARP_TRANSACTION_HISTORY_PKG;
947: pg_program_id := arp_global.program_id;
948: pg_program_update_date := arp_global.program_update_date;
949: pg_last_updated_by := arp_global.last_updated_by;
950: pg_last_update_date := arp_global.last_update_date;
951: pg_last_update_login := arp_global.last_update_login;
952: pg_set_of_books_id := arp_global.set_of_books_id;
953:
954: END ARP_TRANSACTION_HISTORY_PKG;
948: pg_program_update_date := arp_global.program_update_date;
949: pg_last_updated_by := arp_global.last_updated_by;
950: pg_last_update_date := arp_global.last_update_date;
951: pg_last_update_login := arp_global.last_update_login;
952: pg_set_of_books_id := arp_global.set_of_books_id;
953:
954: END ARP_TRANSACTION_HISTORY_PKG;