11: AR_TWO_NUMBER_DUMMY CONSTANT NUMBER(2) := -99;
12: AR_DATE_DUMMY CONSTANT DATE := to_date(1, 'J');
13:
14: /*-------------------------------------+
15: | WHO column values from ARP_GLOBAL |
16: +-------------------------------------*/
17: pg_request_id number;
18: pg_program_application_id number;
19: pg_program_id number;
1989:
1990: END dump_debug;
1991:
1992: BEGIN
1993: pg_request_id := arp_global.request_id;
1994: pg_program_application_id := arp_global.program_application_id;
1995: pg_program_id := arp_global.program_id;
1996: pg_program_update_date := arp_global.program_update_date;
1997: pg_last_updated_by := arp_global.last_updated_by;
1990: END dump_debug;
1991:
1992: BEGIN
1993: pg_request_id := arp_global.request_id;
1994: pg_program_application_id := arp_global.program_application_id;
1995: pg_program_id := arp_global.program_id;
1996: pg_program_update_date := arp_global.program_update_date;
1997: pg_last_updated_by := arp_global.last_updated_by;
1998: pg_last_update_date := arp_global.last_update_date;
1991:
1992: BEGIN
1993: pg_request_id := arp_global.request_id;
1994: pg_program_application_id := arp_global.program_application_id;
1995: pg_program_id := arp_global.program_id;
1996: pg_program_update_date := arp_global.program_update_date;
1997: pg_last_updated_by := arp_global.last_updated_by;
1998: pg_last_update_date := arp_global.last_update_date;
1999: pg_last_update_login := arp_global.last_update_login;
1992: BEGIN
1993: pg_request_id := arp_global.request_id;
1994: pg_program_application_id := arp_global.program_application_id;
1995: pg_program_id := arp_global.program_id;
1996: pg_program_update_date := arp_global.program_update_date;
1997: pg_last_updated_by := arp_global.last_updated_by;
1998: pg_last_update_date := arp_global.last_update_date;
1999: pg_last_update_login := arp_global.last_update_login;
2000: pg_set_of_books_id := arp_global.set_of_books_id;
1993: pg_request_id := arp_global.request_id;
1994: pg_program_application_id := arp_global.program_application_id;
1995: pg_program_id := arp_global.program_id;
1996: pg_program_update_date := arp_global.program_update_date;
1997: pg_last_updated_by := arp_global.last_updated_by;
1998: pg_last_update_date := arp_global.last_update_date;
1999: pg_last_update_login := arp_global.last_update_login;
2000: pg_set_of_books_id := arp_global.set_of_books_id;
2001: END ARP_PS_PKG;
1994: pg_program_application_id := arp_global.program_application_id;
1995: pg_program_id := arp_global.program_id;
1996: pg_program_update_date := arp_global.program_update_date;
1997: pg_last_updated_by := arp_global.last_updated_by;
1998: pg_last_update_date := arp_global.last_update_date;
1999: pg_last_update_login := arp_global.last_update_login;
2000: pg_set_of_books_id := arp_global.set_of_books_id;
2001: END ARP_PS_PKG;
1995: pg_program_id := arp_global.program_id;
1996: pg_program_update_date := arp_global.program_update_date;
1997: pg_last_updated_by := arp_global.last_updated_by;
1998: pg_last_update_date := arp_global.last_update_date;
1999: pg_last_update_login := arp_global.last_update_login;
2000: pg_set_of_books_id := arp_global.set_of_books_id;
2001: END ARP_PS_PKG;
1996: pg_program_update_date := arp_global.program_update_date;
1997: pg_last_updated_by := arp_global.last_updated_by;
1998: pg_last_update_date := arp_global.last_update_date;
1999: pg_last_update_login := arp_global.last_update_login;
2000: pg_set_of_books_id := arp_global.set_of_books_id;
2001: END ARP_PS_PKG;