DBA Data[Home] [Help]

APPS.OKL_XCA_PVT dependencies on FND_GLOBAL

Line 1464: l_xcav_rec.CREATED_BY := Fnd_Global.USER_ID;

1460: ) RETURN xcav_rec_type IS
1461: l_xcav_rec xcav_rec_type := p_xcav_rec;
1462: BEGIN
1463: l_xcav_rec.CREATION_DATE := SYSDATE;
1464: l_xcav_rec.CREATED_BY := Fnd_Global.USER_ID;
1465: l_xcav_rec.LAST_UPDATE_DATE := l_xcav_rec.CREATION_DATE;
1466: l_xcav_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
1467: l_xcav_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1468: RETURN(l_xcav_rec);

Line 1466: l_xcav_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

1462: BEGIN
1463: l_xcav_rec.CREATION_DATE := SYSDATE;
1464: l_xcav_rec.CREATED_BY := Fnd_Global.USER_ID;
1465: l_xcav_rec.LAST_UPDATE_DATE := l_xcav_rec.CREATION_DATE;
1466: l_xcav_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
1467: l_xcav_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1468: RETURN(l_xcav_rec);
1469: END fill_who_columns;
1470: -------------------------------------------

Line 1467: l_xcav_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

1463: l_xcav_rec.CREATION_DATE := SYSDATE;
1464: l_xcav_rec.CREATED_BY := Fnd_Global.USER_ID;
1465: l_xcav_rec.LAST_UPDATE_DATE := l_xcav_rec.CREATION_DATE;
1466: l_xcav_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
1467: l_xcav_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1468: RETURN(l_xcav_rec);
1469: END fill_who_columns;
1470: -------------------------------------------
1471: -- Set_Attributes for:OKL_XTL_CSH_APPS_V --

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

1483:
1484: -- POST TAPI GENERATED CODE BEGINS 04/25/2001 Bruno.
1485:
1486: IF (x_xcav_rec.request_id IS NULL OR x_xcav_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1487: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1488: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.PROG_APPL_ID),
1489: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1490: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1491: INTO

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

1484: -- POST TAPI GENERATED CODE BEGINS 04/25/2001 Bruno.
1485:
1486: IF (x_xcav_rec.request_id IS NULL OR x_xcav_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1487: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1488: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.PROG_APPL_ID),
1489: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1490: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1491: INTO
1492: x_xcav_rec.request_id,

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

1485:
1486: IF (x_xcav_rec.request_id IS NULL OR x_xcav_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1487: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1488: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.PROG_APPL_ID),
1489: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1490: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1491: INTO
1492: x_xcav_rec.request_id,
1493: x_xcav_rec.program_application_id,

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

1486: IF (x_xcav_rec.request_id IS NULL OR x_xcav_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1487: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1488: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.PROG_APPL_ID),
1489: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1490: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1491: INTO
1492: x_xcav_rec.request_id,
1493: x_xcav_rec.program_application_id,
1494: x_xcav_rec.program_id,

Line 2583: l_xcav_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

2579: ) RETURN xcav_rec_type IS
2580: l_xcav_rec xcav_rec_type := p_xcav_rec;
2581: BEGIN
2582: l_xcav_rec.LAST_UPDATE_DATE := SYSDATE;
2583: l_xcav_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
2584: l_xcav_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2585: RETURN(l_xcav_rec);
2586: END fill_who_columns;
2587: ----------------------------------

Line 2584: l_xcav_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

2580: l_xcav_rec xcav_rec_type := p_xcav_rec;
2581: BEGIN
2582: l_xcav_rec.LAST_UPDATE_DATE := SYSDATE;
2583: l_xcav_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
2584: l_xcav_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2585: RETURN(l_xcav_rec);
2586: END fill_who_columns;
2587: ----------------------------------
2588: -- FUNCTION populate_new_record --

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

2782:
2783: -- POST TAPI GENERATED CODE BEGINS 04/25/2001 Bruno.
2784:
2785: SELECT
2786: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
2787: x_xcav_rec.request_id),
2788: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2789: x_xcav_rec.program_application_id),
2790: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),

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

2784:
2785: SELECT
2786: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
2787: x_xcav_rec.request_id),
2788: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2789: x_xcav_rec.program_application_id),
2790: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
2791: x_xcav_rec.program_id),
2792: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),

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

2786: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
2787: x_xcav_rec.request_id),
2788: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2789: x_xcav_rec.program_application_id),
2790: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
2791: x_xcav_rec.program_id),
2792: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
2793: NULL,x_xcav_rec.program_update_date,SYSDATE)
2794: INTO

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

2788: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2789: x_xcav_rec.program_application_id),
2790: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
2791: x_xcav_rec.program_id),
2792: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
2793: NULL,x_xcav_rec.program_update_date,SYSDATE)
2794: INTO
2795: x_xcav_rec.request_id,
2796: x_xcav_rec.program_application_id,