DBA Data[Home] [Help]

APPS.PN_EXP_TO_AR dependencies on FND_GLOBAL

Line 585: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

581: l_term_name RA_TERMS.NAME%TYPE;
582: l_pay_method_name AR_RECEIPT_METHODS.NAME%TYPE;
583: l_amt NUMBER;
584: l_prior_payment_schedule_id NUMBER := -999;
585: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
586: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
587: l_last_update_date DATE := sysdate;
588: l_context VARCHAR2(200);
589: l_batch_name RA_BATCH_SOURCES.NAME%TYPE;

Line 586: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

582: l_pay_method_name AR_RECEIPT_METHODS.NAME%TYPE;
583: l_amt NUMBER;
584: l_prior_payment_schedule_id NUMBER := -999;
585: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
586: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
587: l_last_update_date DATE := sysdate;
588: l_context VARCHAR2(200);
589: l_batch_name RA_BATCH_SOURCES.NAME%TYPE;
590: l_precision NUMBER;

Line 1120: l_last_updated_by := FND_GLOBAL.USER_ID;

1116: fnd_message.set_token ('NUM',(l_next-l_start));
1117: pnp_debug_pkg.put_log_msg(fnd_message.get);
1118:
1119: l_rec_insert_flag := TRUE;
1120: l_last_updated_by := FND_GLOBAL.USER_ID;
1121: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1122: l_last_update_date := sysdate;
1123:
1124: /* if we reached here, we have a group worth inserting

Line 1121: l_last_update_login := FND_GLOBAL.LOGIN_ID;

1117: pnp_debug_pkg.put_log_msg(fnd_message.get);
1118:
1119: l_rec_insert_flag := TRUE;
1120: l_last_updated_by := FND_GLOBAL.USER_ID;
1121: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1122: l_last_update_date := sysdate;
1123:
1124: /* if we reached here, we have a group worth inserting
1125: loop through the PL/SQL table and insert

Line 1925: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

1921: l_term_name RA_TERMS.name%TYPE;
1922: l_pay_method_name AR_RECEIPT_METHODS.name%TYPE;
1923: l_amt NUMBER;
1924: l_prior_payment_schedule_id NUMBER := -999;
1925: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
1926: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1927: l_last_update_date DATE := sysdate;
1928: l_start_date RA_CUST_TRX_LINE_GL_DIST.gl_date%TYPE ;
1929: l_context VARCHAR2(2000);

Line 1926: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

1922: l_pay_method_name AR_RECEIPT_METHODS.name%TYPE;
1923: l_amt NUMBER;
1924: l_prior_payment_schedule_id NUMBER := -999;
1925: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
1926: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1927: l_last_update_date DATE := sysdate;
1928: l_start_date RA_CUST_TRX_LINE_GL_DIST.gl_date%TYPE ;
1929: l_context VARCHAR2(2000);
1930: l_batch_name RA_BATCH_SOURCES.name%TYPE;

Line 2724: l_last_updated_by := FND_GLOBAL.USER_ID;

2720: pnp_debug_pkg.put_log_msg(fnd_message.get);
2721:
2722: END IF;
2723:
2724: l_last_updated_by := FND_GLOBAL.USER_ID;
2725: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2726: l_last_update_date := sysdate;
2727:
2728: pnp_debug_pkg.log('Inserting into distributions');

Line 2725: l_last_update_login := FND_GLOBAL.LOGIN_ID;

2721:
2722: END IF;
2723:
2724: l_last_updated_by := FND_GLOBAL.USER_ID;
2725: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2726: l_last_update_date := sysdate;
2727:
2728: pnp_debug_pkg.log('Inserting into distributions');
2729: l_context := 'Inserting into Distributions';