DBA Data[Home] [Help]

APPS.OKL_XSI_PVT dependencies on FND_GLOBAL

Line 1621: l_xsiv_rec.CREATED_BY := Fnd_Global.USER_ID;

1617: ) RETURN xsiv_rec_type IS
1618: l_xsiv_rec xsiv_rec_type := p_xsiv_rec;
1619: BEGIN
1620: l_xsiv_rec.CREATION_DATE := SYSDATE;
1621: l_xsiv_rec.CREATED_BY := Fnd_Global.USER_ID;
1622: l_xsiv_rec.LAST_UPDATE_DATE := l_xsiv_rec.CREATION_DATE;
1623: l_xsiv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
1624: l_xsiv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1625: RETURN(l_xsiv_rec);

Line 1623: l_xsiv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

1619: BEGIN
1620: l_xsiv_rec.CREATION_DATE := SYSDATE;
1621: l_xsiv_rec.CREATED_BY := Fnd_Global.USER_ID;
1622: l_xsiv_rec.LAST_UPDATE_DATE := l_xsiv_rec.CREATION_DATE;
1623: l_xsiv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
1624: l_xsiv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1625: RETURN(l_xsiv_rec);
1626: END fill_who_columns;
1627: --------------------------------------------

Line 1624: l_xsiv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

1620: l_xsiv_rec.CREATION_DATE := SYSDATE;
1621: l_xsiv_rec.CREATED_BY := Fnd_Global.USER_ID;
1622: l_xsiv_rec.LAST_UPDATE_DATE := l_xsiv_rec.CREATION_DATE;
1623: l_xsiv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
1624: l_xsiv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1625: RETURN(l_xsiv_rec);
1626: END fill_who_columns;
1627: --------------------------------------------
1628: -- Set_Attributes for:OKL_EXT_SELL_INVS_V --

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

1639: x_xsiv_rec.SFWT_FLAG := 'N';
1640:
1641: IF (x_xsiv_rec.request_id IS NULL OR x_xsiv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1642: SELECT
1643: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1644: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1645: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1646: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1647: INTO

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

1640:
1641: IF (x_xsiv_rec.request_id IS NULL OR x_xsiv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1642: SELECT
1643: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1644: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1645: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1646: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1647: INTO
1648: x_xsiv_rec.request_id,

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

1641: IF (x_xsiv_rec.request_id IS NULL OR x_xsiv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1642: SELECT
1643: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1644: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1645: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1646: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1647: INTO
1648: x_xsiv_rec.request_id,
1649: x_xsiv_rec.program_application_id,

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

1642: SELECT
1643: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1644: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1645: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1646: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1647: INTO
1648: x_xsiv_rec.request_id,
1649: x_xsiv_rec.program_application_id,
1650: x_xsiv_rec.program_id,

Line 2836: l_xsiv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

2832: ) RETURN xsiv_rec_type IS
2833: l_xsiv_rec xsiv_rec_type := p_xsiv_rec;
2834: BEGIN
2835: l_xsiv_rec.LAST_UPDATE_DATE := l_xsiv_rec.CREATION_DATE;
2836: l_xsiv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
2837: l_xsiv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2838: RETURN(l_xsiv_rec);
2839: END fill_who_columns;
2840: ----------------------------------

Line 2837: l_xsiv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

2833: l_xsiv_rec xsiv_rec_type := p_xsiv_rec;
2834: BEGIN
2835: l_xsiv_rec.LAST_UPDATE_DATE := l_xsiv_rec.CREATION_DATE;
2836: l_xsiv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
2837: l_xsiv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2838: RETURN(l_xsiv_rec);
2839: END fill_who_columns;
2840: ----------------------------------
2841: -- FUNCTION populate_new_record --

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

3116:
3117: IF (x_xsiv_rec.request_id IS NULL OR x_xsiv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
3118: -- Begin Post-Generation Change
3119: SELECT
3120: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
3121: x_xsiv_rec.request_id),
3122: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3123: x_xsiv_rec.program_application_id),
3124: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),

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

3118: -- Begin Post-Generation Change
3119: SELECT
3120: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
3121: x_xsiv_rec.request_id),
3122: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3123: x_xsiv_rec.program_application_id),
3124: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
3125: x_xsiv_rec.program_id),
3126: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),

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

3120: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
3121: x_xsiv_rec.request_id),
3122: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3123: x_xsiv_rec.program_application_id),
3124: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
3125: x_xsiv_rec.program_id),
3126: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
3127: NULL,x_xsiv_rec.program_update_date,SYSDATE)
3128: INTO

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

3122: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3123: x_xsiv_rec.program_application_id),
3124: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
3125: x_xsiv_rec.program_id),
3126: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
3127: NULL,x_xsiv_rec.program_update_date,SYSDATE)
3128: INTO
3129: x_xsiv_rec.request_id,
3130: x_xsiv_rec.program_application_id,