DBA Data[Home] [Help]

APPS.CSF_DEBRIEF_PVT dependencies on FND_GLOBAL

Line 14: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSF_DEBRIEF_PVT';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csfvdbfb.pls';
13:
14: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
15: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
16: G_UPDATE NUMBER := 1;
17: G_CREATE NUMBER := 2;
18:

Line 15: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSF_DEBRIEF_PVT';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csfvdbfb.pls';
13:
14: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
15: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
16: G_UPDATE NUMBER := 1;
17: G_CREATE NUMBER := 2;
18:
19: procedure log(p_procedure in varchar2,p_message in varchar2) as

Line 157: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

153: X_Msg_Count OUT NOCOPY NUMBER,
154: X_Msg_Data OUT NOCOPY VARCHAR2
155: )
156: IS
157: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
158: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
159: l_row_id varchar2(100) := null;
160: l_api_name CONSTANT VARCHAR2(30) := 'Create_Debrief';
161: l_api_version_number CONSTANT NUMBER := 1.0;

Line 158: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

154: X_Msg_Data OUT NOCOPY VARCHAR2
155: )
156: IS
157: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
158: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
159: l_row_id varchar2(100) := null;
160: l_api_name CONSTANT VARCHAR2(30) := 'Create_Debrief';
161: l_api_version_number CONSTANT NUMBER := 1.0;
162: l_return_status VARCHAR2(1);

Line 520: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

516: )
517: IS
518:
519:
520: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
521: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
522: l_api_name CONSTANT VARCHAR2(30) := 'Update_debrief';
523: l_api_version_number CONSTANT NUMBER := 1.0;
524:

Line 521: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

517: IS
518:
519:
520: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
521: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
522: l_api_name CONSTANT VARCHAR2(30) := 'Update_debrief';
523: l_api_version_number CONSTANT NUMBER := 1.0;
524:
525: -- Local Variables

Line 952: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

948: X_Msg_Count OUT NOCOPY NUMBER,
949: X_Msg_Data OUT NOCOPY VARCHAR2
950: )
951: IS
952: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
953: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
954: l_api_name CONSTANT VARCHAR2(30) := 'Create_debrief_lines';
955: l_api_version_number CONSTANT NUMBER := 1.0;
956: x_row_id varchar2(100) := 100;

Line 953: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

949: X_Msg_Data OUT NOCOPY VARCHAR2
950: )
951: IS
952: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
953: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
954: l_api_name CONSTANT VARCHAR2(30) := 'Create_debrief_lines';
955: l_api_version_number CONSTANT NUMBER := 1.0;
956: x_row_id varchar2(100) := 100;
957: l_request_id number;

Line 1855: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

1851: X_Msg_Data OUT NOCOPY VARCHAR2
1852: )
1853: IS
1854:
1855: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
1856: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1857: l_hr_uom varchar2(100) := fnd_profile.value('CSF_UOM_HOURS');
1858: l_quantity number;
1859: l_cp_status_id number;

Line 1856: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

1852: )
1853: IS
1854:
1855: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
1856: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1857: l_hr_uom varchar2(100) := fnd_profile.value('CSF_UOM_HOURS');
1858: l_quantity number;
1859: l_cp_status_id number;
1860: l_cp_status varchar2(30);

Line 3598: l_debrief_line(l_record_counter).created_by := fnd_global.user_id;

3594: l_debrief_line(l_record_counter).debrief_header_id := l_debrief_header_id;
3595: l_debrief_line(l_record_counter).service_date := l_travel_end_date;
3596: l_debrief_line(l_record_counter).labor_start_date := l_travel_start_date;
3597: l_debrief_line(l_record_counter).labor_end_date := l_travel_end_date;
3598: l_debrief_line(l_record_counter).created_by := fnd_global.user_id;
3599: l_debrief_line(l_record_counter).creation_date := sysdate;
3600: l_debrief_line(l_record_counter).last_updated_by := fnd_global.user_id;
3601: l_debrief_line(l_record_counter).last_update_date := sysdate;
3602: l_debrief_line(l_record_counter).last_update_login := fnd_global.user_id;

Line 3600: l_debrief_line(l_record_counter).last_updated_by := fnd_global.user_id;

3596: l_debrief_line(l_record_counter).labor_start_date := l_travel_start_date;
3597: l_debrief_line(l_record_counter).labor_end_date := l_travel_end_date;
3598: l_debrief_line(l_record_counter).created_by := fnd_global.user_id;
3599: l_debrief_line(l_record_counter).creation_date := sysdate;
3600: l_debrief_line(l_record_counter).last_updated_by := fnd_global.user_id;
3601: l_debrief_line(l_record_counter).last_update_date := sysdate;
3602: l_debrief_line(l_record_counter).last_update_login := fnd_global.user_id;
3603: l_debrief_line(l_record_counter).business_process_id :=
3604: l_business_process_id;

Line 3602: l_debrief_line(l_record_counter).last_update_login := fnd_global.user_id;

3598: l_debrief_line(l_record_counter).created_by := fnd_global.user_id;
3599: l_debrief_line(l_record_counter).creation_date := sysdate;
3600: l_debrief_line(l_record_counter).last_updated_by := fnd_global.user_id;
3601: l_debrief_line(l_record_counter).last_update_date := sysdate;
3602: l_debrief_line(l_record_counter).last_update_login := fnd_global.user_id;
3603: l_debrief_line(l_record_counter).business_process_id :=
3604: l_business_process_id;
3605: l_debrief_line(l_record_counter).transaction_type_id :=
3606: l_transaction_type_id;

Line 3620: l_debrief_line(l_record_counter).created_by := fnd_global.user_id;

3616: l_debrief_line(l_record_counter).debrief_header_id := l_debrief_header_id;
3617: l_debrief_line(l_record_counter).service_date := l_working_end_date;
3618: l_debrief_line(l_record_counter).labor_start_date := l_working_start_date;
3619: l_debrief_line(l_record_counter).labor_end_date := l_working_end_date;
3620: l_debrief_line(l_record_counter).created_by := fnd_global.user_id;
3621: l_debrief_line(l_record_counter).creation_date := sysdate;
3622: l_debrief_line(l_record_counter).last_updated_by := fnd_global.user_id;
3623: l_debrief_line(l_record_counter).last_update_date := sysdate;
3624: l_debrief_line(l_record_counter).last_update_login := fnd_global.user_id;

Line 3622: l_debrief_line(l_record_counter).last_updated_by := fnd_global.user_id;

3618: l_debrief_line(l_record_counter).labor_start_date := l_working_start_date;
3619: l_debrief_line(l_record_counter).labor_end_date := l_working_end_date;
3620: l_debrief_line(l_record_counter).created_by := fnd_global.user_id;
3621: l_debrief_line(l_record_counter).creation_date := sysdate;
3622: l_debrief_line(l_record_counter).last_updated_by := fnd_global.user_id;
3623: l_debrief_line(l_record_counter).last_update_date := sysdate;
3624: l_debrief_line(l_record_counter).last_update_login := fnd_global.user_id;
3625: l_debrief_line(l_record_counter).business_process_id :=
3626: l_business_process_id;

Line 3624: l_debrief_line(l_record_counter).last_update_login := fnd_global.user_id;

3620: l_debrief_line(l_record_counter).created_by := fnd_global.user_id;
3621: l_debrief_line(l_record_counter).creation_date := sysdate;
3622: l_debrief_line(l_record_counter).last_updated_by := fnd_global.user_id;
3623: l_debrief_line(l_record_counter).last_update_date := sysdate;
3624: l_debrief_line(l_record_counter).last_update_login := fnd_global.user_id;
3625: l_debrief_line(l_record_counter).business_process_id :=
3626: l_business_process_id;
3627: l_debrief_line(l_record_counter).transaction_type_id :=
3628: l_transaction_type_id;