DBA Data[Home] [Help]

APPS.OKL_LSM_PVT dependencies on FND_GLOBAL

Line 1459: l_lsmv_rec.CREATED_BY := Fnd_Global.USER_ID;

1455: ) RETURN lsmv_rec_type IS
1456: l_lsmv_rec lsmv_rec_type := p_lsmv_rec;
1457: BEGIN
1458: l_lsmv_rec.CREATION_DATE := SYSDATE;
1459: l_lsmv_rec.CREATED_BY := Fnd_Global.USER_ID;
1460: l_lsmv_rec.LAST_UPDATE_DATE := SYSDATE;
1461: l_lsmv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
1462: l_lsmv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1463: RETURN(l_lsmv_rec);

Line 1461: l_lsmv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

1457: BEGIN
1458: l_lsmv_rec.CREATION_DATE := SYSDATE;
1459: l_lsmv_rec.CREATED_BY := Fnd_Global.USER_ID;
1460: l_lsmv_rec.LAST_UPDATE_DATE := SYSDATE;
1461: l_lsmv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
1462: l_lsmv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1463: RETURN(l_lsmv_rec);
1464: END fill_who_columns;
1465: ---------------------------------------------

Line 1462: l_lsmv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

1458: l_lsmv_rec.CREATION_DATE := SYSDATE;
1459: l_lsmv_rec.CREATED_BY := Fnd_Global.USER_ID;
1460: l_lsmv_rec.LAST_UPDATE_DATE := SYSDATE;
1461: l_lsmv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
1462: l_lsmv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1463: RETURN(l_lsmv_rec);
1464: END fill_who_columns;
1465: ---------------------------------------------
1466: -- Set_Attributes for:OKL_CNSLD_AR_STRMS_V --

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

1476: x_lsmv_rec.SFWT_FLAG := 'N';
1477:
1478: IF (x_lsmv_rec.request_id IS NULL OR x_lsmv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1479: SELECT
1480: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1481: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1482: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1483: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1484: INTO

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

1477:
1478: IF (x_lsmv_rec.request_id IS NULL OR x_lsmv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1479: SELECT
1480: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1481: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1482: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1483: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1484: INTO
1485: x_lsmv_rec.request_id,

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

1478: IF (x_lsmv_rec.request_id IS NULL OR x_lsmv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1479: SELECT
1480: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1481: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1482: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1483: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1484: INTO
1485: x_lsmv_rec.request_id,
1486: x_lsmv_rec.program_application_id,

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

1479: SELECT
1480: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1481: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1482: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1483: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1484: INTO
1485: x_lsmv_rec.request_id,
1486: x_lsmv_rec.program_application_id,
1487: x_lsmv_rec.program_id,

Line 2589: l_lsmv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

2585: ) RETURN lsmv_rec_type IS
2586: l_lsmv_rec lsmv_rec_type := p_lsmv_rec;
2587: BEGIN
2588: l_lsmv_rec.LAST_UPDATE_DATE := SYSDATE;
2589: l_lsmv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
2590: l_lsmv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2591: RETURN(l_lsmv_rec);
2592: END fill_who_columns;
2593: ----------------------------------

Line 2590: l_lsmv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

2586: l_lsmv_rec lsmv_rec_type := p_lsmv_rec;
2587: BEGIN
2588: l_lsmv_rec.LAST_UPDATE_DATE := SYSDATE;
2589: l_lsmv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
2590: l_lsmv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2591: RETURN(l_lsmv_rec);
2592: END fill_who_columns;
2593: ----------------------------------
2594: -- FUNCTION populate_new_record --

Line 2809: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),

2805:
2806: IF (x_lsmv_rec.request_id IS NULL OR x_lsmv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
2807: -- Begin Post-Generation Change
2808: SELECT
2809: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
2810: x_lsmv_rec.request_id),
2811: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2812: x_lsmv_rec.program_application_id),
2813: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),

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

2807: -- Begin Post-Generation Change
2808: SELECT
2809: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
2810: x_lsmv_rec.request_id),
2811: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2812: x_lsmv_rec.program_application_id),
2813: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
2814: x_lsmv_rec.program_id),
2815: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),

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

2809: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
2810: x_lsmv_rec.request_id),
2811: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2812: x_lsmv_rec.program_application_id),
2813: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
2814: x_lsmv_rec.program_id),
2815: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
2816: NULL,x_lsmv_rec.program_update_date,SYSDATE)
2817: INTO

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

2811: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2812: x_lsmv_rec.program_application_id),
2813: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
2814: x_lsmv_rec.program_id),
2815: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
2816: NULL,x_lsmv_rec.program_update_date,SYSDATE)
2817: INTO
2818: x_lsmv_rec.request_id,
2819: x_lsmv_rec.program_application_id,