DBA Data[Home] [Help]

APPS.OKL_SEL_PVT dependencies on FND_GLOBAL

Line 1599: l_selv_rec.CREATED_BY := FND_GLOBAL.USER_ID;

1595: ) RETURN selv_rec_type IS
1596: l_selv_rec selv_rec_type := p_selv_rec;
1597: BEGIN
1598: l_selv_rec.CREATION_DATE := SYSDATE;
1599: l_selv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1600: l_selv_rec.LAST_UPDATE_DATE := SYSDATE;
1601: l_selv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1602: l_selv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1603: RETURN(l_selv_rec);

Line 1601: l_selv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1597: BEGIN
1598: l_selv_rec.CREATION_DATE := SYSDATE;
1599: l_selv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1600: l_selv_rec.LAST_UPDATE_DATE := SYSDATE;
1601: l_selv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1602: l_selv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1603: RETURN(l_selv_rec);
1604: END fill_who_columns;
1605: --------------------------------------------

Line 1602: l_selv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

1598: l_selv_rec.CREATION_DATE := SYSDATE;
1599: l_selv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1600: l_selv_rec.LAST_UPDATE_DATE := SYSDATE;
1601: l_selv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1602: l_selv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1603: RETURN(l_selv_rec);
1604: END fill_who_columns;
1605: --------------------------------------------
1606: -- Set_Attributes for:OKL_STRM_ELEMENTS_V --

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

1616:
1617: -- fill Concurrent program columns
1618: /*** Concurrent Manager columns assignement ************/
1619:
1620: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
1621: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
1622: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
1623: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1624: INTO x_selv_rec.REQUEST_ID

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

1617: -- fill Concurrent program columns
1618: /*** Concurrent Manager columns assignement ************/
1619:
1620: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
1621: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
1622: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
1623: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1624: INTO x_selv_rec.REQUEST_ID
1625: ,x_selv_rec.PROGRAM_APPLICATION_ID

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

1618: /*** Concurrent Manager columns assignement ************/
1619:
1620: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
1621: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
1622: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
1623: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1624: INTO x_selv_rec.REQUEST_ID
1625: ,x_selv_rec.PROGRAM_APPLICATION_ID
1626: ,x_selv_rec.PROGRAM_ID

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

1619:
1620: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
1621: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
1622: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
1623: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1624: INTO x_selv_rec.REQUEST_ID
1625: ,x_selv_rec.PROGRAM_APPLICATION_ID
1626: ,x_selv_rec.PROGRAM_ID
1627: ,x_selv_rec.PROGRAM_UPDATE_DATE

Line 1835: in_cREATED_BY(j) := FND_GLOBAL.USER_ID;

1831: -- 4212626: End
1832: -- Added by hkpatel for bug 4350255
1833: in_date_disbursed(j) := p_selv_tbl(i).date_disbursed;
1834: in_CREATION_DATE(j) := SYSDATE;
1835: in_cREATED_BY(j) := FND_GLOBAL.USER_ID;
1836: in_LAST_UPDATE_DATE(j) := SYSDATE;
1837: in_LAST_UPDATED_BY(j) := FND_GLOBAL.USER_ID;
1838: in_LAST_UPDATE_LOGIN(j) := FND_GLOBAL.LOGIN_ID;
1839: in_object_version_number(j) := 1.0;

Line 1837: in_LAST_UPDATED_BY(j) := FND_GLOBAL.USER_ID;

1833: in_date_disbursed(j) := p_selv_tbl(i).date_disbursed;
1834: in_CREATION_DATE(j) := SYSDATE;
1835: in_cREATED_BY(j) := FND_GLOBAL.USER_ID;
1836: in_LAST_UPDATE_DATE(j) := SYSDATE;
1837: in_LAST_UPDATED_BY(j) := FND_GLOBAL.USER_ID;
1838: in_LAST_UPDATE_LOGIN(j) := FND_GLOBAL.LOGIN_ID;
1839: in_object_version_number(j) := 1.0;
1840:
1841:

Line 1838: in_LAST_UPDATE_LOGIN(j) := FND_GLOBAL.LOGIN_ID;

1834: in_CREATION_DATE(j) := SYSDATE;
1835: in_cREATED_BY(j) := FND_GLOBAL.USER_ID;
1836: in_LAST_UPDATE_DATE(j) := SYSDATE;
1837: in_LAST_UPDATED_BY(j) := FND_GLOBAL.USER_ID;
1838: in_LAST_UPDATE_LOGIN(j) := FND_GLOBAL.LOGIN_ID;
1839: in_object_version_number(j) := 1.0;
1840:
1841:
1842: --prasjain:Start for bug 5474827

Line 2514: l_selv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

2510: ) RETURN selv_rec_type IS
2511: l_selv_rec selv_rec_type := p_selv_rec;
2512: BEGIN
2513: l_selv_rec.LAST_UPDATE_DATE := SYSDATE;
2514: l_selv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2515: l_selv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2516: RETURN(l_selv_rec);
2517: END fill_who_columns;
2518: ----------------------------------

Line 2515: l_selv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

2511: l_selv_rec selv_rec_type := p_selv_rec;
2512: BEGIN
2513: l_selv_rec.LAST_UPDATE_DATE := SYSDATE;
2514: l_selv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2515: l_selv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2516: RETURN(l_selv_rec);
2517: END fill_who_columns;
2518: ----------------------------------
2519: -- FUNCTION populate_new_record --

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

2658:
2659:
2660:
2661: /***** Concurrent Manager columns assignement ************/
2662: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID)
2663: ,x_selv_rec.REQUEST_ID)
2664: ,NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID)
2665: ,x_selv_rec.PROGRAM_APPLICATION_ID)
2666: ,NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID)

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

2660:
2661: /***** Concurrent Manager columns assignement ************/
2662: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID)
2663: ,x_selv_rec.REQUEST_ID)
2664: ,NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID)
2665: ,x_selv_rec.PROGRAM_APPLICATION_ID)
2666: ,NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID)
2667: ,x_selv_rec.PROGRAM_ID)
2668: ,DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)

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

2662: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID)
2663: ,x_selv_rec.REQUEST_ID)
2664: ,NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID)
2665: ,x_selv_rec.PROGRAM_APPLICATION_ID)
2666: ,NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID)
2667: ,x_selv_rec.PROGRAM_ID)
2668: ,DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
2669: ,NULL,x_selv_rec.PROGRAM_UPDATE_DATE,SYSDATE)
2670: INTO x_selv_rec.REQUEST_ID

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

2664: ,NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID)
2665: ,x_selv_rec.PROGRAM_APPLICATION_ID)
2666: ,NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID)
2667: ,x_selv_rec.PROGRAM_ID)
2668: ,DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
2669: ,NULL,x_selv_rec.PROGRAM_UPDATE_DATE,SYSDATE)
2670: INTO x_selv_rec.REQUEST_ID
2671: ,x_selv_rec.PROGRAM_APPLICATION_ID
2672: ,x_selv_rec.PROGRAM_ID