DBA Data[Home] [Help]

APPS.OKL_AJL_PVT dependencies on FND_GLOBAL

Line 2011: l_ajlv_rec.CREATED_BY := FND_GLOBAL.USER_ID;

2007: ) RETURN ajlv_rec_type IS
2008: l_ajlv_rec ajlv_rec_type := p_ajlv_rec;
2009: BEGIN
2010: l_ajlv_rec.CREATION_DATE := SYSDATE;
2011: l_ajlv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
2012: l_ajlv_rec.LAST_UPDATE_DATE := l_ajlv_rec.CREATION_DATE;
2013: l_ajlv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2014: l_ajlv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2015: RETURN(l_ajlv_rec);

Line 2013: l_ajlv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

2009: BEGIN
2010: l_ajlv_rec.CREATION_DATE := SYSDATE;
2011: l_ajlv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
2012: l_ajlv_rec.LAST_UPDATE_DATE := l_ajlv_rec.CREATION_DATE;
2013: l_ajlv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2014: l_ajlv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2015: RETURN(l_ajlv_rec);
2016: END fill_who_columns;
2017: ---------------------------------------------

Line 2014: l_ajlv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

2010: l_ajlv_rec.CREATION_DATE := SYSDATE;
2011: l_ajlv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
2012: l_ajlv_rec.LAST_UPDATE_DATE := l_ajlv_rec.CREATION_DATE;
2013: l_ajlv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2014: l_ajlv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2015: RETURN(l_ajlv_rec);
2016: END fill_who_columns;
2017: ---------------------------------------------
2018: -- Set_Attributes for:OKL_TXL_ADJSTS_LNS_V --

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

2026: x_ajlv_rec := p_ajlv_rec;
2027: x_ajlv_rec.OBJECT_VERSION_NUMBER := 1;
2028: -- Begin Post-Generation Change
2029: SELECT
2030: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
2031: DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2032: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
2033: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
2034: INTO

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

2027: x_ajlv_rec.OBJECT_VERSION_NUMBER := 1;
2028: -- Begin Post-Generation Change
2029: SELECT
2030: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
2031: DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2032: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
2033: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
2034: INTO
2035: x_ajlv_rec.request_id,

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

2028: -- Begin Post-Generation Change
2029: SELECT
2030: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
2031: DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2032: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
2033: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
2034: INTO
2035: x_ajlv_rec.request_id,
2036: x_ajlv_rec.program_application_id,

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

2029: SELECT
2030: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
2031: DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2032: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
2033: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
2034: INTO
2035: x_ajlv_rec.request_id,
2036: x_ajlv_rec.program_application_id,
2037: x_ajlv_rec.program_id,

Line 3109: l_ajlv_rec.CREATED_BY := Fnd_Global.USER_ID;

3105: ) RETURN ajlv_rec_type IS
3106: l_ajlv_rec ajlv_rec_type := p_ajlv_rec;
3107: BEGIN
3108: l_ajlv_rec.CREATION_DATE := SYSDATE;
3109: l_ajlv_rec.CREATED_BY := Fnd_Global.USER_ID;
3110: l_ajlv_rec.LAST_UPDATE_DATE := SYSDATE;
3111: l_ajlv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
3112: l_ajlv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
3113: RETURN(l_ajlv_rec);

Line 3111: l_ajlv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

3107: BEGIN
3108: l_ajlv_rec.CREATION_DATE := SYSDATE;
3109: l_ajlv_rec.CREATED_BY := Fnd_Global.USER_ID;
3110: l_ajlv_rec.LAST_UPDATE_DATE := SYSDATE;
3111: l_ajlv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
3112: l_ajlv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
3113: RETURN(l_ajlv_rec);
3114: END fill_who_columns;
3115: ----------------------------------

Line 3112: l_ajlv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

3108: l_ajlv_rec.CREATION_DATE := SYSDATE;
3109: l_ajlv_rec.CREATED_BY := Fnd_Global.USER_ID;
3110: l_ajlv_rec.LAST_UPDATE_DATE := SYSDATE;
3111: l_ajlv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
3112: l_ajlv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
3113: RETURN(l_ajlv_rec);
3114: END fill_who_columns;
3115: ----------------------------------
3116: -- FUNCTION populate_new_record --

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

3303: x_ajlv_rec := p_ajlv_rec;
3304: x_ajlv_rec.OBJECT_VERSION_NUMBER := NVL(x_ajlv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
3305: -- Begin Post-Generation Change
3306: SELECT
3307: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
3308: x_ajlv_rec.request_id),
3309: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3310: x_ajlv_rec.program_application_id),
3311: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),

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

3305: -- Begin Post-Generation Change
3306: SELECT
3307: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
3308: x_ajlv_rec.request_id),
3309: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3310: x_ajlv_rec.program_application_id),
3311: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
3312: x_ajlv_rec.program_id),
3313: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),

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

3307: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
3308: x_ajlv_rec.request_id),
3309: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3310: x_ajlv_rec.program_application_id),
3311: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
3312: x_ajlv_rec.program_id),
3313: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
3314: NULL,x_ajlv_rec.program_update_date,SYSDATE)
3315: INTO

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

3309: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3310: x_ajlv_rec.program_application_id),
3311: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
3312: x_ajlv_rec.program_id),
3313: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
3314: NULL,x_ajlv_rec.program_update_date,SYSDATE)
3315: INTO
3316: x_ajlv_rec.request_id,
3317: x_ajlv_rec.program_application_id,