DBA Data[Home] [Help]

APPS.OKL_BKT_PVT dependencies on FND_GLOBAL

Line 1297: l_bktv_rec.CREATED_BY := Fnd_Global.User_Id;

1293: ) RETURN bktv_rec_type IS
1294: l_bktv_rec bktv_rec_type := p_bktv_rec;
1295: BEGIN
1296: l_bktv_rec.CREATION_DATE := SYSDATE;
1297: l_bktv_rec.CREATED_BY := Fnd_Global.User_Id;
1298: l_bktv_rec.LAST_UPDATE_DATE := l_bktv_rec.CREATION_DATE;
1299: l_bktv_rec.LAST_UPDATED_BY := Fnd_Global.User_Id;
1300: l_bktv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1301: RETURN(l_bktv_rec);

Line 1299: l_bktv_rec.LAST_UPDATED_BY := Fnd_Global.User_Id;

1295: BEGIN
1296: l_bktv_rec.CREATION_DATE := SYSDATE;
1297: l_bktv_rec.CREATED_BY := Fnd_Global.User_Id;
1298: l_bktv_rec.LAST_UPDATE_DATE := l_bktv_rec.CREATION_DATE;
1299: l_bktv_rec.LAST_UPDATED_BY := Fnd_Global.User_Id;
1300: l_bktv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1301: RETURN(l_bktv_rec);
1302: END fill_who_columns;
1303: --------------------------------------

Line 1300: l_bktv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

1296: l_bktv_rec.CREATION_DATE := SYSDATE;
1297: l_bktv_rec.CREATED_BY := Fnd_Global.User_Id;
1298: l_bktv_rec.LAST_UPDATE_DATE := l_bktv_rec.CREATION_DATE;
1299: l_bktv_rec.LAST_UPDATED_BY := Fnd_Global.User_Id;
1300: l_bktv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1301: RETURN(l_bktv_rec);
1302: END fill_who_columns;
1303: --------------------------------------
1304: -- Set_Attributes for:OKL_BUCKETS_V --

Line 1315: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),

1311: BEGIN
1312: x_bktv_rec := p_bktv_rec;
1313: x_bktv_rec.OBJECT_VERSION_NUMBER := 1;
1314:
1315: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
1316: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
1317: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
1318: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1319: INTO x_bktv_rec.REQUEST_ID

Line 1316: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),

1312: x_bktv_rec := p_bktv_rec;
1313: x_bktv_rec.OBJECT_VERSION_NUMBER := 1;
1314:
1315: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
1316: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
1317: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
1318: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1319: INTO x_bktv_rec.REQUEST_ID
1320: ,x_bktv_rec.PROGRAM_APPLICATION_ID

Line 1317: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),

1313: x_bktv_rec.OBJECT_VERSION_NUMBER := 1;
1314:
1315: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
1316: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
1317: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
1318: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1319: INTO x_bktv_rec.REQUEST_ID
1320: ,x_bktv_rec.PROGRAM_APPLICATION_ID
1321: ,x_bktv_rec.PROGRAM_ID

Line 1318: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)

1314:
1315: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
1316: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
1317: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
1318: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1319: INTO x_bktv_rec.REQUEST_ID
1320: ,x_bktv_rec.PROGRAM_APPLICATION_ID
1321: ,x_bktv_rec.PROGRAM_ID
1322: ,x_bktv_rec.PROGRAM_UPDATE_DATE

Line 1991: l_bktv_rec.LAST_UPDATED_BY := Fnd_Global.User_Id;

1987: ) RETURN bktv_rec_type IS
1988: l_bktv_rec bktv_rec_type := p_bktv_rec;
1989: BEGIN
1990: l_bktv_rec.LAST_UPDATE_DATE := SYSDATE;
1991: l_bktv_rec.LAST_UPDATED_BY := Fnd_Global.User_Id;
1992: l_bktv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1993: RETURN(l_bktv_rec);
1994: END fill_who_columns;
1995: ----------------------------------

Line 1992: l_bktv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

1988: l_bktv_rec bktv_rec_type := p_bktv_rec;
1989: BEGIN
1990: l_bktv_rec.LAST_UPDATE_DATE := SYSDATE;
1991: l_bktv_rec.LAST_UPDATED_BY := Fnd_Global.User_Id;
1992: l_bktv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1993: RETURN(l_bktv_rec);
1994: END fill_who_columns;
1995: ----------------------------------
1996: -- FUNCTION populate_new_record --

Line 2095: SELECT NVL(DECODE(FND_GLOBAL.conc_request_id, -1, NULL, fnd_global.conc_request_id) ,p_bktv_rec.REQUEST_ID)

2091: x_bktv_rec := p_bktv_rec;
2092:
2093: /***** Concurrent Manager columns assignement ************/
2094:
2095: SELECT NVL(DECODE(FND_GLOBAL.conc_request_id, -1, NULL, fnd_global.conc_request_id) ,p_bktv_rec.REQUEST_ID)
2096: ,NVL(DECODE(fnd_global.prog_appl_id, -1, NULL, fnd_global.prog_appl_id) ,p_bktv_rec.PROGRAM_APPLICATION_ID)
2097: ,NVL(DECODE(fnd_global.conc_program_id, -1, NULL, fnd_global.conc_program_id) ,p_bktv_rec.PROGRAM_ID)
2098: ,DECODE(DECODE(fnd_global.conc_request_id, -1, NULL, SYSDATE) ,NULL, p_bktv_rec.PROGRAM_UPDATE_DATE,SYSDATE)
2099: INTO x_bktv_rec.REQUEST_ID

Line 2096: ,NVL(DECODE(fnd_global.prog_appl_id, -1, NULL, fnd_global.prog_appl_id) ,p_bktv_rec.PROGRAM_APPLICATION_ID)

2092:
2093: /***** Concurrent Manager columns assignement ************/
2094:
2095: SELECT NVL(DECODE(FND_GLOBAL.conc_request_id, -1, NULL, fnd_global.conc_request_id) ,p_bktv_rec.REQUEST_ID)
2096: ,NVL(DECODE(fnd_global.prog_appl_id, -1, NULL, fnd_global.prog_appl_id) ,p_bktv_rec.PROGRAM_APPLICATION_ID)
2097: ,NVL(DECODE(fnd_global.conc_program_id, -1, NULL, fnd_global.conc_program_id) ,p_bktv_rec.PROGRAM_ID)
2098: ,DECODE(DECODE(fnd_global.conc_request_id, -1, NULL, SYSDATE) ,NULL, p_bktv_rec.PROGRAM_UPDATE_DATE,SYSDATE)
2099: INTO x_bktv_rec.REQUEST_ID
2100: ,x_bktv_rec.PROGRAM_APPLICATION_ID

Line 2097: ,NVL(DECODE(fnd_global.conc_program_id, -1, NULL, fnd_global.conc_program_id) ,p_bktv_rec.PROGRAM_ID)

2093: /***** Concurrent Manager columns assignement ************/
2094:
2095: SELECT NVL(DECODE(FND_GLOBAL.conc_request_id, -1, NULL, fnd_global.conc_request_id) ,p_bktv_rec.REQUEST_ID)
2096: ,NVL(DECODE(fnd_global.prog_appl_id, -1, NULL, fnd_global.prog_appl_id) ,p_bktv_rec.PROGRAM_APPLICATION_ID)
2097: ,NVL(DECODE(fnd_global.conc_program_id, -1, NULL, fnd_global.conc_program_id) ,p_bktv_rec.PROGRAM_ID)
2098: ,DECODE(DECODE(fnd_global.conc_request_id, -1, NULL, SYSDATE) ,NULL, p_bktv_rec.PROGRAM_UPDATE_DATE,SYSDATE)
2099: INTO x_bktv_rec.REQUEST_ID
2100: ,x_bktv_rec.PROGRAM_APPLICATION_ID
2101: ,x_bktv_rec.PROGRAM_ID

Line 2098: ,DECODE(DECODE(fnd_global.conc_request_id, -1, NULL, SYSDATE) ,NULL, p_bktv_rec.PROGRAM_UPDATE_DATE,SYSDATE)

2094:
2095: SELECT NVL(DECODE(FND_GLOBAL.conc_request_id, -1, NULL, fnd_global.conc_request_id) ,p_bktv_rec.REQUEST_ID)
2096: ,NVL(DECODE(fnd_global.prog_appl_id, -1, NULL, fnd_global.prog_appl_id) ,p_bktv_rec.PROGRAM_APPLICATION_ID)
2097: ,NVL(DECODE(fnd_global.conc_program_id, -1, NULL, fnd_global.conc_program_id) ,p_bktv_rec.PROGRAM_ID)
2098: ,DECODE(DECODE(fnd_global.conc_request_id, -1, NULL, SYSDATE) ,NULL, p_bktv_rec.PROGRAM_UPDATE_DATE,SYSDATE)
2099: INTO x_bktv_rec.REQUEST_ID
2100: ,x_bktv_rec.PROGRAM_APPLICATION_ID
2101: ,x_bktv_rec.PROGRAM_ID
2102: ,x_bktv_rec.PROGRAM_UPDATE_DATE