DBA Data[Home] [Help]

APPS.OKL_AEH_PVT dependencies on FND_GLOBAL

Line 1867: l_aehv_rec.CREATED_BY := Fnd_Global.USER_ID;

1863: ) RETURN aehv_rec_type IS
1864: l_aehv_rec aehv_rec_type := p_aehv_rec;
1865: BEGIN
1866: l_aehv_rec.CREATION_DATE := SYSDATE;
1867: l_aehv_rec.CREATED_BY := Fnd_Global.USER_ID;
1868: l_aehv_rec.LAST_UPDATE_DATE := SYSDATE;
1869: l_aehv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
1870: l_aehv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1871: RETURN(l_aehv_rec);

Line 1869: l_aehv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

1865: BEGIN
1866: l_aehv_rec.CREATION_DATE := SYSDATE;
1867: l_aehv_rec.CREATED_BY := Fnd_Global.USER_ID;
1868: l_aehv_rec.LAST_UPDATE_DATE := SYSDATE;
1869: l_aehv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
1870: l_aehv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1871: RETURN(l_aehv_rec);
1872: END fill_who_columns;
1873: -----------------------------------------

Line 1870: l_aehv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

1866: l_aehv_rec.CREATION_DATE := SYSDATE;
1867: l_aehv_rec.CREATED_BY := Fnd_Global.USER_ID;
1868: l_aehv_rec.LAST_UPDATE_DATE := SYSDATE;
1869: l_aehv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
1870: l_aehv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1871: RETURN(l_aehv_rec);
1872: END fill_who_columns;
1873: -----------------------------------------
1874: -- Set_Attributes for:OKL_AE_HEADERS_V --

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

1882: x_aehv_rec := p_aehv_rec;
1883: x_aehv_rec.OBJECT_VERSION_NUMBER := 1;
1884: x_aehv_rec.ORG_ID := MO_GLOBAL.GET_CURRENT_ORG_ID();
1885: x_aehv_rec.set_of_books_id := okl_accounting_util.get_set_of_books_id;
1886: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
1887: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
1888: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
1889: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1890: INTO x_aehv_rec.REQUEST_ID

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

1883: x_aehv_rec.OBJECT_VERSION_NUMBER := 1;
1884: x_aehv_rec.ORG_ID := MO_GLOBAL.GET_CURRENT_ORG_ID();
1885: x_aehv_rec.set_of_books_id := okl_accounting_util.get_set_of_books_id;
1886: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
1887: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
1888: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
1889: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1890: INTO x_aehv_rec.REQUEST_ID
1891: ,x_aehv_rec.PROGRAM_APPLICATION_ID

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

1884: x_aehv_rec.ORG_ID := MO_GLOBAL.GET_CURRENT_ORG_ID();
1885: x_aehv_rec.set_of_books_id := okl_accounting_util.get_set_of_books_id;
1886: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
1887: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
1888: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
1889: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1890: INTO x_aehv_rec.REQUEST_ID
1891: ,x_aehv_rec.PROGRAM_APPLICATION_ID
1892: ,x_aehv_rec.PROGRAM_ID

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

1885: x_aehv_rec.set_of_books_id := okl_accounting_util.get_set_of_books_id;
1886: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
1887: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
1888: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
1889: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1890: INTO x_aehv_rec.REQUEST_ID
1891: ,x_aehv_rec.PROGRAM_APPLICATION_ID
1892: ,x_aehv_rec.PROGRAM_ID
1893: ,x_aehv_rec.PROGRAM_UPDATE_DATE

Line 2768: l_aehv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

2764: ) RETURN aehv_rec_type IS
2765: l_aehv_rec aehv_rec_type := p_aehv_rec;
2766: BEGIN
2767: l_aehv_rec.LAST_UPDATE_DATE := SYSDATE;
2768: l_aehv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
2769: l_aehv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2770: RETURN(l_aehv_rec);
2771: END fill_who_columns;
2772: ----------------------------------

Line 2769: l_aehv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

2765: l_aehv_rec aehv_rec_type := p_aehv_rec;
2766: BEGIN
2767: l_aehv_rec.LAST_UPDATE_DATE := SYSDATE;
2768: l_aehv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
2769: l_aehv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2770: RETURN(l_aehv_rec);
2771: END fill_who_columns;
2772: ----------------------------------
2773: -- FUNCTION populate_new_record --

Line 2909: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),x_aehv_rec.REQUEST_ID),

2905: ) RETURN VARCHAR2 IS
2906: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2907: BEGIN
2908: x_aehv_rec := p_aehv_rec;
2909: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),x_aehv_rec.REQUEST_ID),
2910: NVL(DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.PROG_APPL_ID),x_aehv_rec.PROGRAM_APPLICATION_ID),
2911: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),x_aehv_rec.PROGRAM_ID),
2912: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,x_aehv_rec.PROGRAM_UPDATE_DATE,SYSDATE)
2913: INTO x_aehv_rec.REQUEST_ID

Line 2910: NVL(DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.PROG_APPL_ID),x_aehv_rec.PROGRAM_APPLICATION_ID),

2906: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2907: BEGIN
2908: x_aehv_rec := p_aehv_rec;
2909: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),x_aehv_rec.REQUEST_ID),
2910: NVL(DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.PROG_APPL_ID),x_aehv_rec.PROGRAM_APPLICATION_ID),
2911: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),x_aehv_rec.PROGRAM_ID),
2912: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,x_aehv_rec.PROGRAM_UPDATE_DATE,SYSDATE)
2913: INTO x_aehv_rec.REQUEST_ID
2914: ,x_aehv_rec.PROGRAM_APPLICATION_ID

Line 2911: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),x_aehv_rec.PROGRAM_ID),

2907: BEGIN
2908: x_aehv_rec := p_aehv_rec;
2909: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),x_aehv_rec.REQUEST_ID),
2910: NVL(DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.PROG_APPL_ID),x_aehv_rec.PROGRAM_APPLICATION_ID),
2911: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),x_aehv_rec.PROGRAM_ID),
2912: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,x_aehv_rec.PROGRAM_UPDATE_DATE,SYSDATE)
2913: INTO x_aehv_rec.REQUEST_ID
2914: ,x_aehv_rec.PROGRAM_APPLICATION_ID
2915: ,x_aehv_rec.PROGRAM_ID

Line 2912: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,x_aehv_rec.PROGRAM_UPDATE_DATE,SYSDATE)

2908: x_aehv_rec := p_aehv_rec;
2909: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),x_aehv_rec.REQUEST_ID),
2910: NVL(DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.PROG_APPL_ID),x_aehv_rec.PROGRAM_APPLICATION_ID),
2911: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),x_aehv_rec.PROGRAM_ID),
2912: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,x_aehv_rec.PROGRAM_UPDATE_DATE,SYSDATE)
2913: INTO x_aehv_rec.REQUEST_ID
2914: ,x_aehv_rec.PROGRAM_APPLICATION_ID
2915: ,x_aehv_rec.PROGRAM_ID
2916: ,x_aehv_rec.PROGRAM_UPDATE_DATE