DBA Data[Home] [Help]

APPS.OKL_XLP_PVT dependencies on FND_GLOBAL

Line 1923: l_xlpv_rec.CREATED_BY := FND_GLOBAL.USER_ID;

1919: ) RETURN xlpv_rec_type IS
1920: l_xlpv_rec xlpv_rec_type := p_xlpv_rec;
1921: BEGIN
1922: l_xlpv_rec.CREATION_DATE := SYSDATE;
1923: l_xlpv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1924: l_xlpv_rec.LAST_UPDATE_DATE := l_xlpv_rec.CREATION_DATE; -- PostGen-10
1925: l_xlpv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1926: l_xlpv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1927: RETURN(l_xlpv_rec);

Line 1925: l_xlpv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1921: BEGIN
1922: l_xlpv_rec.CREATION_DATE := SYSDATE;
1923: l_xlpv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1924: l_xlpv_rec.LAST_UPDATE_DATE := l_xlpv_rec.CREATION_DATE; -- PostGen-10
1925: l_xlpv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1926: l_xlpv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1927: RETURN(l_xlpv_rec);
1928: END fill_who_columns;
1929: -------------------------------------------

Line 1926: l_xlpv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

1922: l_xlpv_rec.CREATION_DATE := SYSDATE;
1923: l_xlpv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1924: l_xlpv_rec.LAST_UPDATE_DATE := l_xlpv_rec.CREATION_DATE; -- PostGen-10
1925: l_xlpv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1926: l_xlpv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1927: RETURN(l_xlpv_rec);
1928: END fill_who_columns;
1929: -------------------------------------------
1930: -- Set_Attributes for:OKL_XTL_PAY_INVS_V --

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

1939: x_xlpv_rec.OBJECT_VERSION_NUMBER := 1;
1940: x_xlpv_rec.SFWT_FLAG := 'N';
1941:
1942: SELECT
1943: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1944: DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
1945: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1946: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1947: INTO

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

1940: x_xlpv_rec.SFWT_FLAG := 'N';
1941:
1942: SELECT
1943: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1944: DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
1945: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1946: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1947: INTO
1948: x_xlpv_rec.request_id,

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

1941:
1942: SELECT
1943: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1944: DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
1945: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1946: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1947: INTO
1948: x_xlpv_rec.request_id,
1949: x_xlpv_rec.program_application_id,

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

1942: SELECT
1943: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1944: DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
1945: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1946: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1947: INTO
1948: x_xlpv_rec.request_id,
1949: x_xlpv_rec.program_application_id,
1950: x_xlpv_rec.program_id,

Line 3027: l_xlpv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

3023: ) RETURN xlpv_rec_type IS
3024: l_xlpv_rec xlpv_rec_type := p_xlpv_rec;
3025: BEGIN
3026: l_xlpv_rec.LAST_UPDATE_DATE := SYSDATE;
3027: l_xlpv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
3028: l_xlpv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
3029: RETURN(l_xlpv_rec);
3030: END fill_who_columns;
3031: ----------------------------------

Line 3028: l_xlpv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

3024: l_xlpv_rec xlpv_rec_type := p_xlpv_rec;
3025: BEGIN
3026: l_xlpv_rec.LAST_UPDATE_DATE := SYSDATE;
3027: l_xlpv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
3028: l_xlpv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
3029: RETURN(l_xlpv_rec);
3030: END fill_who_columns;
3031: ----------------------------------
3032: -- FUNCTION populate_new_record --

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

3232: x_xlpv_rec.OBJECT_VERSION_NUMBER := NVL(x_xlpv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
3233:
3234: -- Begin PostGen-7
3235: SELECT
3236: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
3237: x_xlpv_rec.request_id),
3238: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3239: x_xlpv_rec.program_application_id),
3240: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),

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

3234: -- Begin PostGen-7
3235: SELECT
3236: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
3237: x_xlpv_rec.request_id),
3238: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3239: x_xlpv_rec.program_application_id),
3240: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
3241: x_xlpv_rec.program_id),
3242: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),

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

3236: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
3237: x_xlpv_rec.request_id),
3238: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3239: x_xlpv_rec.program_application_id),
3240: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
3241: x_xlpv_rec.program_id),
3242: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
3243: NULL,x_xlpv_rec.program_update_date,SYSDATE)
3244: INTO

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

3238: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3239: x_xlpv_rec.program_application_id),
3240: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
3241: x_xlpv_rec.program_id),
3242: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
3243: NULL,x_xlpv_rec.program_update_date,SYSDATE)
3244: INTO
3245: x_xlpv_rec.request_id,
3246: x_xlpv_rec.program_application_id,