12: AR_NUMBER_DUMMY CONSTANT NUMBER(15) := -999999999999999;
13: AR_DATE_DUMMY CONSTANT DATE := to_date(1, 'J');
14: --
15: /*-------------------------------------+
16: | WHO column values from ARP_GLOBAL |
17: +-------------------------------------*/
18: --
19: pg_request_id number;
20: pg_program_application_id number;
369: DECODE( arp_standard.profile.program_id,
370: NULL, NULL,
371: SYSDATE
372: ),
373: arp_global.last_updated_by, /* FP Bug 5715840 arp_standard.profile.user_id,*/
374: SYSDATE,
375: arp_global.last_updated_by, /* FP Bug 5715840 arp_standard.profile.user_id,*/
376: SYSDATE,
377: NVL( arp_global.last_update_login,
371: SYSDATE
372: ),
373: arp_global.last_updated_by, /* FP Bug 5715840 arp_standard.profile.user_id,*/
374: SYSDATE,
375: arp_global.last_updated_by, /* FP Bug 5715840 arp_standard.profile.user_id,*/
376: SYSDATE,
377: NVL( arp_global.last_update_login,
378: p_crh_rec.last_update_login ),
379: p_crh_rec.prv_stat_cash_receipt_hist_id,
373: arp_global.last_updated_by, /* FP Bug 5715840 arp_standard.profile.user_id,*/
374: SYSDATE,
375: arp_global.last_updated_by, /* FP Bug 5715840 arp_standard.profile.user_id,*/
376: SYSDATE,
377: NVL( arp_global.last_update_login,
378: p_crh_rec.last_update_login ),
379: p_crh_rec.prv_stat_cash_receipt_hist_id,
380: p_crh_rec.created_from,
381: p_crh_rec.reversal_created_from,
471: DECODE( arp_standard.profile.program_id,
472: NULL, NULL,
473: SYSDATE
474: ),
475: last_updated_by = arp_global.last_updated_by, /* FP Bug 5715840 arp_standard.profile.user_id,*/
476: last_update_date = SYSDATE,
477: last_update_login =
478: NVL( arp_global.last_update_login,
479: p_crh_rec.last_update_login ),
474: ),
475: last_updated_by = arp_global.last_updated_by, /* FP Bug 5715840 arp_standard.profile.user_id,*/
476: last_update_date = SYSDATE,
477: last_update_login =
478: NVL( arp_global.last_update_login,
479: p_crh_rec.last_update_login ),
480: prv_stat_cash_receipt_hist_id =
481: p_crh_rec.prv_stat_cash_receipt_hist_id,
482: created_from = p_crh_rec.created_from,
1036:
1037: --
1038: BEGIN
1039: --
1040: pg_request_id := arp_global.request_id;
1041: pg_program_application_id := arp_global.program_application_id;
1042: pg_program_id := arp_global.program_id;
1043: pg_program_update_date := arp_global.program_update_date;
1044: pg_last_updated_by := arp_global.last_updated_by;
1037: --
1038: BEGIN
1039: --
1040: pg_request_id := arp_global.request_id;
1041: pg_program_application_id := arp_global.program_application_id;
1042: pg_program_id := arp_global.program_id;
1043: pg_program_update_date := arp_global.program_update_date;
1044: pg_last_updated_by := arp_global.last_updated_by;
1045: pg_last_update_date := arp_global.last_update_date;
1038: BEGIN
1039: --
1040: pg_request_id := arp_global.request_id;
1041: pg_program_application_id := arp_global.program_application_id;
1042: pg_program_id := arp_global.program_id;
1043: pg_program_update_date := arp_global.program_update_date;
1044: pg_last_updated_by := arp_global.last_updated_by;
1045: pg_last_update_date := arp_global.last_update_date;
1046: pg_last_update_login := arp_global.last_update_login;
1039: --
1040: pg_request_id := arp_global.request_id;
1041: pg_program_application_id := arp_global.program_application_id;
1042: pg_program_id := arp_global.program_id;
1043: pg_program_update_date := arp_global.program_update_date;
1044: pg_last_updated_by := arp_global.last_updated_by;
1045: pg_last_update_date := arp_global.last_update_date;
1046: pg_last_update_login := arp_global.last_update_login;
1047: pg_set_of_books_id := arp_global.set_of_books_id;
1040: pg_request_id := arp_global.request_id;
1041: pg_program_application_id := arp_global.program_application_id;
1042: pg_program_id := arp_global.program_id;
1043: pg_program_update_date := arp_global.program_update_date;
1044: pg_last_updated_by := arp_global.last_updated_by;
1045: pg_last_update_date := arp_global.last_update_date;
1046: pg_last_update_login := arp_global.last_update_login;
1047: pg_set_of_books_id := arp_global.set_of_books_id;
1048: --
1041: pg_program_application_id := arp_global.program_application_id;
1042: pg_program_id := arp_global.program_id;
1043: pg_program_update_date := arp_global.program_update_date;
1044: pg_last_updated_by := arp_global.last_updated_by;
1045: pg_last_update_date := arp_global.last_update_date;
1046: pg_last_update_login := arp_global.last_update_login;
1047: pg_set_of_books_id := arp_global.set_of_books_id;
1048: --
1049: END ARP_CR_HISTORY_PKG;
1042: pg_program_id := arp_global.program_id;
1043: pg_program_update_date := arp_global.program_update_date;
1044: pg_last_updated_by := arp_global.last_updated_by;
1045: pg_last_update_date := arp_global.last_update_date;
1046: pg_last_update_login := arp_global.last_update_login;
1047: pg_set_of_books_id := arp_global.set_of_books_id;
1048: --
1049: END ARP_CR_HISTORY_PKG;
1043: pg_program_update_date := arp_global.program_update_date;
1044: pg_last_updated_by := arp_global.last_updated_by;
1045: pg_last_update_date := arp_global.last_update_date;
1046: pg_last_update_login := arp_global.last_update_login;
1047: pg_set_of_books_id := arp_global.set_of_books_id;
1048: --
1049: END ARP_CR_HISTORY_PKG;