DBA Data[Home] [Help]

APPS.BIM_CAMPAIGN_FACTS dependencies on FND_GLOBAL

Line 125: l_user_id NUMBER := FND_GLOBAL.USER_ID();

121: v_error_text VARCHAR2(1500);
122: l_last_update_date DATE;
123: l_start_date DATE;
124: l_end_date DATE;
125: l_user_id NUMBER := FND_GLOBAL.USER_ID();
126: l_sysdate DATE := SYSDATE;
127: l_api_version_number CONSTANT NUMBER := 1.0;
128: l_api_name CONSTANT VARCHAR2(30) := 'AMS_CAMPAIGN_FACTS';
129: l_success VARCHAR2(3);

Line 334: l_user_id NUMBER := FND_GLOBAL.USER_ID();

330: p_start_date IN DATE DEFAULT NULL,
331: p_end_date IN DATE DEFAULT NULL
332: )
333: IS
334: l_user_id NUMBER := FND_GLOBAL.USER_ID();
335: l_sysdate DATE := SYSDATE;
336: l_api_version_number CONSTANT NUMBER := 1.0;
337: l_api_name CONSTANT VARCHAR2(30) := 'AMS_CAMPAIGN_FACTS';
338: l_success VARCHAR2(3);

Line 442: l_user_id NUMBER := FND_GLOBAL.USER_ID();

438: ,x_msg_data OUT NOCOPY VARCHAR2
439: ,x_return_status OUT NOCOPY VARCHAR2
440: )
441: IS
442: l_user_id NUMBER := FND_GLOBAL.USER_ID();
443: l_start_date DATE;
444: l_end_date DATE;
445: l_last_update_date DATE;
446: l_success VARCHAR2(3);

Line 2639: l_user_id NUMBER := FND_GLOBAL.USER_ID();

2635: ,x_msg_data OUT NOCOPY VARCHAR2
2636: ,x_return_status OUT NOCOPY VARCHAR2
2637: )
2638: IS
2639: l_user_id NUMBER := FND_GLOBAL.USER_ID();
2640: l_start_date DATE;
2641: l_end_date DATE;
2642: l_last_update_date DATE;
2643: l_success VARCHAR2(3);

Line 4855: l_user_id NUMBER := FND_GLOBAL.USER_ID();

4851: ,x_return_status OUT NOCOPY VARCHAR2
4852: ,p_date IN DATE
4853: ) IS
4854: l_weekend_date DATE;
4855: l_user_id NUMBER := FND_GLOBAL.USER_ID();
4856: l_seq NUMBER;
4857: l_seqw NUMBER;
4858: l_api_version_number CONSTANT NUMBER := 1.0;
4859: l_api_name CONSTANT VARCHAR2(30) := 'CAMPAIGN_DAILY_LOAD';