DBA Data[Home] [Help]

APPS.CSF_DEBRIEF_PVT dependencies on FND_GLOBAL

Line 15: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

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

Line 16: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

12: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSF_DEBRIEF_PVT';
13: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csfvdbfb.pls';
14:
15: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
16: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
17: G_UPDATE NUMBER := 1;
18: G_CREATE NUMBER := 2;
19:
20: Procedure validate_start_end(p_labor_start_time date,

Line 144: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

140: X_Msg_Count OUT NOCOPY NUMBER,
141: X_Msg_Data OUT NOCOPY VARCHAR2
142: )
143: IS
144: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
145: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
146: l_row_id varchar2(100) := null;
147: l_api_name CONSTANT VARCHAR2(30) := 'Create_Debrief';
148: l_api_version_number CONSTANT NUMBER := 1.0;

Line 145: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

141: X_Msg_Data OUT NOCOPY VARCHAR2
142: )
143: IS
144: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
145: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
146: l_row_id varchar2(100) := null;
147: l_api_name CONSTANT VARCHAR2(30) := 'Create_Debrief';
148: l_api_version_number CONSTANT NUMBER := 1.0;
149: l_return_status VARCHAR2(1);

Line 507: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

503: )
504: IS
505:
506:
507: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
508: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
509: l_api_name CONSTANT VARCHAR2(30) := 'Update_debrief';
510: l_api_version_number CONSTANT NUMBER := 1.0;
511:

Line 508: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

504: IS
505:
506:
507: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
508: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
509: l_api_name CONSTANT VARCHAR2(30) := 'Update_debrief';
510: l_api_version_number CONSTANT NUMBER := 1.0;
511:
512: -- Local Variables

Line 950: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

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

Line 951: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

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

Line 1802: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

1798: X_Msg_Data OUT NOCOPY VARCHAR2
1799: )
1800: IS
1801:
1802: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
1803: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1804: l_hr_uom varchar2(100) := fnd_profile.value('CSF_UOM_HOURS');
1805: l_quantity number;
1806: l_cp_status_id number;

Line 1803: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

1799: )
1800: IS
1801:
1802: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
1803: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1804: l_hr_uom varchar2(100) := fnd_profile.value('CSF_UOM_HOURS');
1805: l_quantity number;
1806: l_cp_status_id number;
1807: l_cp_status varchar2(30);