DBA Data[Home] [Help]

APPS.OKC_PAC_PVT dependencies on FND_GLOBAL

Line 931: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),

927: l_pac_rec.creation_date,
928: l_pac_rec.last_updated_by,
929: l_pac_rec.last_update_date,
930: l_pac_rec.last_update_login,
931: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
932: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
933: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
934: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
935: l_pac_rec.object_version_number);

Line 932: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),

928: l_pac_rec.last_updated_by,
929: l_pac_rec.last_update_date,
930: l_pac_rec.last_update_login,
931: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
932: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
933: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
934: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
935: l_pac_rec.object_version_number);
936: -- Set OUT values

Line 933: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),

929: l_pac_rec.last_update_date,
930: l_pac_rec.last_update_login,
931: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
932: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
933: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
934: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
935: l_pac_rec.object_version_number);
936: -- Set OUT values
937: x_pac_rec := l_pac_rec;

Line 934: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),

930: l_pac_rec.last_update_login,
931: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
932: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
933: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
934: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
935: l_pac_rec.object_version_number);
936: -- Set OUT values
937: x_pac_rec := l_pac_rec;
938: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1025: l_pacv_rec.CREATED_BY := FND_GLOBAL.USER_ID;

1021: l_pacv_rec pacv_rec_type := p_pacv_rec;
1022: BEGIN
1023:
1024: l_pacv_rec.CREATION_DATE := SYSDATE;
1025: l_pacv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1026: l_pacv_rec.LAST_UPDATE_DATE := l_pacv_rec.CREATION_DATE;
1027: l_pacv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1028: l_pacv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1029: RETURN(l_pacv_rec);

Line 1027: l_pacv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1023:
1024: l_pacv_rec.CREATION_DATE := SYSDATE;
1025: l_pacv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1026: l_pacv_rec.LAST_UPDATE_DATE := l_pacv_rec.CREATION_DATE;
1027: l_pacv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1028: l_pacv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1029: RETURN(l_pacv_rec);
1030:
1031: END fill_who_columns;

Line 1028: l_pacv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

1024: l_pacv_rec.CREATION_DATE := SYSDATE;
1025: l_pacv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1026: l_pacv_rec.LAST_UPDATE_DATE := l_pacv_rec.CREATION_DATE;
1027: l_pacv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1028: l_pacv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1029: RETURN(l_pacv_rec);
1030:
1031: END fill_who_columns;
1032: -----------------------------------------------

Line 1845: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_pac_rec.request_id),

1841: CREATION_DATE = l_def_pac_rec.creation_date,
1842: LAST_UPDATED_BY = l_def_pac_rec.last_updated_by,
1843: LAST_UPDATE_DATE = l_def_pac_rec.last_update_date,
1844: LAST_UPDATE_LOGIN = l_def_pac_rec.last_update_login,
1845: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_pac_rec.request_id),
1846: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_pac_rec.program_application_id),
1847: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_pac_rec.program_id),
1848: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_pac_rec.program_update_date,SYSDATE),
1849:

Line 1846: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_pac_rec.program_application_id),

1842: LAST_UPDATED_BY = l_def_pac_rec.last_updated_by,
1843: LAST_UPDATE_DATE = l_def_pac_rec.last_update_date,
1844: LAST_UPDATE_LOGIN = l_def_pac_rec.last_update_login,
1845: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_pac_rec.request_id),
1846: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_pac_rec.program_application_id),
1847: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_pac_rec.program_id),
1848: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_pac_rec.program_update_date,SYSDATE),
1849:
1850: OBJECT_VERSION_NUMBER = l_def_pac_rec.object_version_number

Line 1847: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_pac_rec.program_id),

1843: LAST_UPDATE_DATE = l_def_pac_rec.last_update_date,
1844: LAST_UPDATE_LOGIN = l_def_pac_rec.last_update_login,
1845: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_pac_rec.request_id),
1846: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_pac_rec.program_application_id),
1847: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_pac_rec.program_id),
1848: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_pac_rec.program_update_date,SYSDATE),
1849:
1850: OBJECT_VERSION_NUMBER = l_def_pac_rec.object_version_number
1851: WHERE ID = l_def_pac_rec.id;

Line 1848: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_pac_rec.program_update_date,SYSDATE),

1844: LAST_UPDATE_LOGIN = l_def_pac_rec.last_update_login,
1845: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_pac_rec.request_id),
1846: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_pac_rec.program_application_id),
1847: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_pac_rec.program_id),
1848: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_pac_rec.program_update_date,SYSDATE),
1849:
1850: OBJECT_VERSION_NUMBER = l_def_pac_rec.object_version_number
1851: WHERE ID = l_def_pac_rec.id;
1852:

Line 1941: l_pacv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1937: l_pacv_rec pacv_rec_type := p_pacv_rec;
1938: BEGIN
1939:
1940: l_pacv_rec.LAST_UPDATE_DATE := SYSDATE;
1941: l_pacv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1942: l_pacv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1943:
1944: RETURN(l_pacv_rec);
1945:

Line 1942: l_pacv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

1938: BEGIN
1939:
1940: l_pacv_rec.LAST_UPDATE_DATE := SYSDATE;
1941: l_pacv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1942: l_pacv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1943:
1944: RETURN(l_pacv_rec);
1945:
1946: END fill_who_columns;