DBA Data[Home] [Help]

APPS.OKL_LLN_PVT dependencies on FND_GLOBAL

Line 1577: l_llnv_rec.CREATED_BY := Fnd_Global.USER_ID;

1573: ) RETURN llnv_rec_type IS
1574: l_llnv_rec llnv_rec_type := p_llnv_rec;
1575: BEGIN
1576: l_llnv_rec.CREATION_DATE := SYSDATE;
1577: l_llnv_rec.CREATED_BY := Fnd_Global.USER_ID;
1578: l_llnv_rec.LAST_UPDATE_DATE := SYSDATE;
1579: l_llnv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
1580: l_llnv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1581: RETURN(l_llnv_rec);

Line 1579: l_llnv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

1575: BEGIN
1576: l_llnv_rec.CREATION_DATE := SYSDATE;
1577: l_llnv_rec.CREATED_BY := Fnd_Global.USER_ID;
1578: l_llnv_rec.LAST_UPDATE_DATE := SYSDATE;
1579: l_llnv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
1580: l_llnv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1581: RETURN(l_llnv_rec);
1582: END fill_who_columns;
1583: ---------------------------------------------

Line 1580: l_llnv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

1576: l_llnv_rec.CREATION_DATE := SYSDATE;
1577: l_llnv_rec.CREATED_BY := Fnd_Global.USER_ID;
1578: l_llnv_rec.LAST_UPDATE_DATE := SYSDATE;
1579: l_llnv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
1580: l_llnv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1581: RETURN(l_llnv_rec);
1582: END fill_who_columns;
1583: ---------------------------------------------
1584: -- Set_Attributes for:OKL_CNSLD_AR_LINES_V --

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

1594: x_llnv_rec.SFWT_FLAG := 'N';
1595:
1596: IF (x_llnv_rec.request_id IS NULL OR x_llnv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1597: SELECT
1598: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1599: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1600: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1601: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1602: INTO

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

1595:
1596: IF (x_llnv_rec.request_id IS NULL OR x_llnv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1597: SELECT
1598: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1599: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1600: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1601: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1602: INTO
1603: x_llnv_rec.request_id,

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

1596: IF (x_llnv_rec.request_id IS NULL OR x_llnv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1597: SELECT
1598: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1599: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1600: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1601: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1602: INTO
1603: x_llnv_rec.request_id,
1604: x_llnv_rec.program_application_id,

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

1597: SELECT
1598: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1599: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1600: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1601: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1602: INTO
1603: x_llnv_rec.request_id,
1604: x_llnv_rec.program_application_id,
1605: x_llnv_rec.program_id,

Line 2651: l_llnv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

2647: ) RETURN llnv_rec_type IS
2648: l_llnv_rec llnv_rec_type := p_llnv_rec;
2649: BEGIN
2650: l_llnv_rec.LAST_UPDATE_DATE := SYSDATE;
2651: l_llnv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
2652: l_llnv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2653: RETURN(l_llnv_rec);
2654: END fill_who_columns;
2655: ----------------------------------

Line 2652: l_llnv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

2648: l_llnv_rec llnv_rec_type := p_llnv_rec;
2649: BEGIN
2650: l_llnv_rec.LAST_UPDATE_DATE := SYSDATE;
2651: l_llnv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
2652: l_llnv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2653: RETURN(l_llnv_rec);
2654: END fill_who_columns;
2655: ----------------------------------
2656: -- FUNCTION populate_new_record --

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

2837:
2838: IF (x_llnv_rec.request_id IS NULL OR x_llnv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
2839: -- Begin Post-Generation Change
2840: SELECT
2841: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
2842: x_llnv_rec.request_id),
2843: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2844: x_llnv_rec.program_application_id),
2845: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),

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

2839: -- Begin Post-Generation Change
2840: SELECT
2841: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
2842: x_llnv_rec.request_id),
2843: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2844: x_llnv_rec.program_application_id),
2845: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
2846: x_llnv_rec.program_id),
2847: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),

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

2841: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
2842: x_llnv_rec.request_id),
2843: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2844: x_llnv_rec.program_application_id),
2845: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
2846: x_llnv_rec.program_id),
2847: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
2848: NULL,x_llnv_rec.program_update_date,SYSDATE)
2849: INTO

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

2843: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2844: x_llnv_rec.program_application_id),
2845: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
2846: x_llnv_rec.program_id),
2847: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
2848: NULL,x_llnv_rec.program_update_date,SYSDATE)
2849: INTO
2850: x_llnv_rec.request_id,
2851: x_llnv_rec.program_application_id,