DBA Data[Home] [Help]

APPS.OKL_XCR_PVT dependencies on FND_GLOBAL

Line 1685: l_xcrv_rec.CREATED_BY := Fnd_Global.USER_ID;

1681: ) RETURN xcrv_rec_type IS
1682: l_xcrv_rec xcrv_rec_type := p_xcrv_rec;
1683: BEGIN
1684: l_xcrv_rec.CREATION_DATE := SYSDATE;
1685: l_xcrv_rec.CREATED_BY := Fnd_Global.USER_ID;
1686: l_xcrv_rec.LAST_UPDATE_DATE := l_xcrv_rec.CREATION_DATE;
1687: l_xcrv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
1688: l_xcrv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1689: RETURN(l_xcrv_rec);

Line 1687: l_xcrv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

1683: BEGIN
1684: l_xcrv_rec.CREATION_DATE := SYSDATE;
1685: l_xcrv_rec.CREATED_BY := Fnd_Global.USER_ID;
1686: l_xcrv_rec.LAST_UPDATE_DATE := l_xcrv_rec.CREATION_DATE;
1687: l_xcrv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
1688: l_xcrv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1689: RETURN(l_xcrv_rec);
1690: END fill_who_columns;
1691: --------------------------------------------

Line 1688: l_xcrv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

1684: l_xcrv_rec.CREATION_DATE := SYSDATE;
1685: l_xcrv_rec.CREATED_BY := Fnd_Global.USER_ID;
1686: l_xcrv_rec.LAST_UPDATE_DATE := l_xcrv_rec.CREATION_DATE;
1687: l_xcrv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
1688: l_xcrv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1689: RETURN(l_xcrv_rec);
1690: END fill_who_columns;
1691: --------------------------------------------
1692: -- Set_Attributes for:OKL_EXT_CSH_RCPTS_V --

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

1704:
1705: -- POST TAPI GENERATED CODE BEGINS 04/25/2001 Bruno.
1706:
1707: IF (x_xcrv_rec.request_id IS NULL OR x_xcrv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1708: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1709: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.PROG_APPL_ID),
1710: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1711: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1712: INTO

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

1705: -- POST TAPI GENERATED CODE BEGINS 04/25/2001 Bruno.
1706:
1707: IF (x_xcrv_rec.request_id IS NULL OR x_xcrv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1708: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1709: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.PROG_APPL_ID),
1710: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1711: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1712: INTO
1713: x_xcrv_rec.request_id,

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

1706:
1707: IF (x_xcrv_rec.request_id IS NULL OR x_xcrv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1708: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1709: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.PROG_APPL_ID),
1710: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1711: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1712: INTO
1713: x_xcrv_rec.request_id,
1714: x_xcrv_rec.program_application_id,

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

1707: IF (x_xcrv_rec.request_id IS NULL OR x_xcrv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1708: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1709: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.PROG_APPL_ID),
1710: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1711: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1712: INTO
1713: x_xcrv_rec.request_id,
1714: x_xcrv_rec.program_application_id,
1715: x_xcrv_rec.program_id,

Line 2903: l_xcrv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

2899: ) RETURN xcrv_rec_type IS
2900: l_xcrv_rec xcrv_rec_type := p_xcrv_rec;
2901: BEGIN
2902: l_xcrv_rec.LAST_UPDATE_DATE := SYSDATE;
2903: l_xcrv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
2904: l_xcrv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2905: RETURN(l_xcrv_rec);
2906: END fill_who_columns;
2907: ----------------------------------

Line 2904: l_xcrv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

2900: l_xcrv_rec xcrv_rec_type := p_xcrv_rec;
2901: BEGIN
2902: l_xcrv_rec.LAST_UPDATE_DATE := SYSDATE;
2903: l_xcrv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
2904: l_xcrv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2905: RETURN(l_xcrv_rec);
2906: END fill_who_columns;
2907: ----------------------------------
2908: -- FUNCTION populate_new_record --

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

3157:
3158: -- POST TAPI GENERATED CODE BEGINS 04/25/2001 Bruno.
3159:
3160: SELECT
3161: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
3162: x_xcrv_rec.request_id),
3163: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3164: x_xcrv_rec.program_application_id),
3165: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),

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

3159:
3160: SELECT
3161: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
3162: x_xcrv_rec.request_id),
3163: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3164: x_xcrv_rec.program_application_id),
3165: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
3166: x_xcrv_rec.program_id),
3167: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),

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

3161: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
3162: x_xcrv_rec.request_id),
3163: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3164: x_xcrv_rec.program_application_id),
3165: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
3166: x_xcrv_rec.program_id),
3167: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
3168: NULL,x_xcrv_rec.program_update_date,SYSDATE)
3169: INTO

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

3163: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3164: x_xcrv_rec.program_application_id),
3165: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
3166: x_xcrv_rec.program_id),
3167: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
3168: NULL,x_xcrv_rec.program_update_date,SYSDATE)
3169: INTO
3170: x_xcrv_rec.request_id,
3171: x_xcrv_rec.program_application_id,