DBA Data[Home] [Help]

APPS.PN_EXP_TO_AR dependencies on FND_GLOBAL

Line 581: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

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

Line 582: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

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

Line 1105: l_last_updated_by := FND_GLOBAL.USER_ID;

1101: fnd_message.set_token ('NUM',(l_next-l_start));
1102: pnp_debug_pkg.put_log_msg(fnd_message.get);
1103:
1104: l_rec_insert_flag := TRUE;
1105: l_last_updated_by := FND_GLOBAL.USER_ID;
1106: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1107: l_last_update_date := sysdate;
1108:
1109: /* if we reached here, we have a group worth inserting

Line 1106: l_last_update_login := FND_GLOBAL.LOGIN_ID;

1102: pnp_debug_pkg.put_log_msg(fnd_message.get);
1103:
1104: l_rec_insert_flag := TRUE;
1105: l_last_updated_by := FND_GLOBAL.USER_ID;
1106: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1107: l_last_update_date := sysdate;
1108:
1109: /* if we reached here, we have a group worth inserting
1110: loop through the PL/SQL table and insert

Line 1879: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

1875: l_term_name RA_TERMS.name%TYPE;
1876: l_pay_method_name AR_RECEIPT_METHODS.name%TYPE;
1877: l_amt NUMBER;
1878: l_prior_payment_schedule_id NUMBER := -999;
1879: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
1880: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1881: l_last_update_date DATE := sysdate;
1882: l_start_date RA_CUST_TRX_LINE_GL_DIST.gl_date%TYPE ;
1883: l_context VARCHAR2(2000);

Line 1880: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

1876: l_pay_method_name AR_RECEIPT_METHODS.name%TYPE;
1877: l_amt NUMBER;
1878: l_prior_payment_schedule_id NUMBER := -999;
1879: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
1880: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1881: l_last_update_date DATE := sysdate;
1882: l_start_date RA_CUST_TRX_LINE_GL_DIST.gl_date%TYPE ;
1883: l_context VARCHAR2(2000);
1884: l_batch_name RA_BATCH_SOURCES.name%TYPE;

Line 2673: l_last_updated_by := FND_GLOBAL.USER_ID;

2669: pnp_debug_pkg.put_log_msg(fnd_message.get);
2670:
2671: END IF;
2672:
2673: l_last_updated_by := FND_GLOBAL.USER_ID;
2674: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2675: l_last_update_date := sysdate;
2676:
2677: pnp_debug_pkg.log('Inserting into distributions');

Line 2674: l_last_update_login := FND_GLOBAL.LOGIN_ID;

2670:
2671: END IF;
2672:
2673: l_last_updated_by := FND_GLOBAL.USER_ID;
2674: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2675: l_last_update_date := sysdate;
2676:
2677: pnp_debug_pkg.log('Inserting into distributions');
2678: l_context := 'Inserting into Distributions';