DBA Data[Home] [Help]

APPS.OKL_XLS_PVT dependencies on FND_GLOBAL

Line 1658: l_xlsv_rec.CREATED_BY := Fnd_Global.USER_ID;

1654: ) RETURN xlsv_rec_type IS
1655: l_xlsv_rec xlsv_rec_type := p_xlsv_rec;
1656: BEGIN
1657: l_xlsv_rec.CREATION_DATE := SYSDATE;
1658: l_xlsv_rec.CREATED_BY := Fnd_Global.USER_ID;
1659: l_xlsv_rec.LAST_UPDATE_DATE := l_xlsv_rec.creation_date;
1660: l_xlsv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
1661: l_xlsv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1662: RETURN(l_xlsv_rec);

Line 1660: l_xlsv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

1656: BEGIN
1657: l_xlsv_rec.CREATION_DATE := SYSDATE;
1658: l_xlsv_rec.CREATED_BY := Fnd_Global.USER_ID;
1659: l_xlsv_rec.LAST_UPDATE_DATE := l_xlsv_rec.creation_date;
1660: l_xlsv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
1661: l_xlsv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1662: RETURN(l_xlsv_rec);
1663: END fill_who_columns;
1664: --------------------------------------------

Line 1661: l_xlsv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

1657: l_xlsv_rec.CREATION_DATE := SYSDATE;
1658: l_xlsv_rec.CREATED_BY := Fnd_Global.USER_ID;
1659: l_xlsv_rec.LAST_UPDATE_DATE := l_xlsv_rec.creation_date;
1660: l_xlsv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
1661: l_xlsv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1662: RETURN(l_xlsv_rec);
1663: END fill_who_columns;
1664: --------------------------------------------
1665: -- Set_Attributes for:OKL_XTL_SELL_INVS_V --

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

1675: x_xlsv_rec.OBJECT_VERSION_NUMBER := 1;
1676: x_xlsv_rec.SFWT_FLAG := 'N';
1677: IF (x_xlsv_rec.request_id IS NULL OR x_xlsv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1678: SELECT
1679: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1680: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1681: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1682: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1683: INTO

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

1676: x_xlsv_rec.SFWT_FLAG := 'N';
1677: IF (x_xlsv_rec.request_id IS NULL OR x_xlsv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1678: SELECT
1679: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1680: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1681: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1682: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1683: INTO
1684: x_xlsv_rec.request_id,

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

1677: IF (x_xlsv_rec.request_id IS NULL OR x_xlsv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1678: SELECT
1679: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1680: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1681: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1682: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1683: INTO
1684: x_xlsv_rec.request_id,
1685: x_xlsv_rec.program_application_id,

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

1678: SELECT
1679: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1680: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1681: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1682: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1683: INTO
1684: x_xlsv_rec.request_id,
1685: x_xlsv_rec.program_application_id,
1686: x_xlsv_rec.program_id,

Line 2817: l_xlsv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

2813: ) RETURN xlsv_rec_type IS
2814: l_xlsv_rec xlsv_rec_type := p_xlsv_rec;
2815: BEGIN
2816: l_xlsv_rec.LAST_UPDATE_DATE := l_xlsv_rec.creation_date;
2817: l_xlsv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
2818: l_xlsv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2819: RETURN(l_xlsv_rec);
2820: END fill_who_columns;
2821: ----------------------------------

Line 2818: l_xlsv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

2814: l_xlsv_rec xlsv_rec_type := p_xlsv_rec;
2815: BEGIN
2816: l_xlsv_rec.LAST_UPDATE_DATE := l_xlsv_rec.creation_date;
2817: l_xlsv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
2818: l_xlsv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2819: RETURN(l_xlsv_rec);
2820: END fill_who_columns;
2821: ----------------------------------
2822: -- FUNCTION populate_new_record --

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

3050:
3051: IF (x_xlsv_rec.request_id IS NULL OR x_xlsv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
3052: -- Begin Post-Generation Change
3053: SELECT
3054: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
3055: x_xlsv_rec.request_id),
3056: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3057: x_xlsv_rec.program_application_id),
3058: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),

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

3052: -- Begin Post-Generation Change
3053: SELECT
3054: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
3055: x_xlsv_rec.request_id),
3056: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3057: x_xlsv_rec.program_application_id),
3058: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
3059: x_xlsv_rec.program_id),
3060: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),

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

3054: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
3055: x_xlsv_rec.request_id),
3056: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3057: x_xlsv_rec.program_application_id),
3058: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
3059: x_xlsv_rec.program_id),
3060: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
3061: NULL,x_xlsv_rec.program_update_date,SYSDATE)
3062: INTO

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

3056: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3057: x_xlsv_rec.program_application_id),
3058: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
3059: x_xlsv_rec.program_id),
3060: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
3061: NULL,x_xlsv_rec.program_update_date,SYSDATE)
3062: INTO
3063: x_xlsv_rec.request_id,
3064: x_xlsv_rec.program_application_id,