DBA Data[Home] [Help]

APPS.ARP_CR_HISTORY_PKG dependencies on ARP_GLOBAL

Line 16: | WHO column values from ARP_GLOBAL |

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;

Line 373: arp_global.last_updated_by, /* FP Bug 5715840 arp_standard.profile.user_id,*/

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,

Line 375: arp_global.last_updated_by, /* FP Bug 5715840 arp_standard.profile.user_id,*/

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,

Line 377: NVL( arp_global.last_update_login,

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,

Line 475: last_updated_by = arp_global.last_updated_by, /* FP Bug 5715840 arp_standard.profile.user_id,*/

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

Line 478: NVL( arp_global.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,

Line 1040: pg_request_id := arp_global.request_id;

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;

Line 1041: pg_program_application_id := arp_global.program_application_id;

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;

Line 1042: pg_program_id := arp_global.program_id;

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;

Line 1043: pg_program_update_date := arp_global.program_update_date;

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;

Line 1044: pg_last_updated_by := arp_global.last_updated_by;

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: --

Line 1045: pg_last_update_date := arp_global.last_update_date;

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;

Line 1046: pg_last_update_login := arp_global.last_update_login;

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;

Line 1047: pg_set_of_books_id := arp_global.set_of_books_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;