DBA Data[Home] [Help]

APPS.AS_GAR_QOT_PUB dependencies on FND_GLOBAL

Line 1672: last_updated_by = FND_GLOBAL.USER_ID,

1668: BEGIN
1669: FORALL i in l_first .. l_last
1670: UPDATE ASO_QUOTE_HEADERS_ALL AQH
1671: SET last_update_date = SYSDATE,
1672: last_updated_by = FND_GLOBAL.USER_ID,
1673: last_update_login = FND_GLOBAL.CONC_LOGIN_ID,
1674: (resource_id,resource_grp_id) =
1675: ( SELECT resource_id,resource_grp_id
1676: FROM ASO_QUOTE_ACCESSES AQA

Line 1673: last_update_login = FND_GLOBAL.CONC_LOGIN_ID,

1669: FORALL i in l_first .. l_last
1670: UPDATE ASO_QUOTE_HEADERS_ALL AQH
1671: SET last_update_date = SYSDATE,
1672: last_updated_by = FND_GLOBAL.USER_ID,
1673: last_update_login = FND_GLOBAL.CONC_LOGIN_ID,
1674: (resource_id,resource_grp_id) =
1675: ( SELECT resource_id,resource_grp_id
1676: FROM ASO_QUOTE_ACCESSES AQA
1677: WHERE AQA.access_id = l_access_id(i)

Line 1694: last_updated_by = FND_GLOBAL.USER_ID,

1690: FOR i IN l_first .. l_last LOOP
1691: BEGIN
1692: UPDATE ASO_QUOTE_HEADERS_ALL AQH
1693: SET last_update_date = SYSDATE,
1694: last_updated_by = FND_GLOBAL.USER_ID,
1695: last_update_login = FND_GLOBAL.CONC_LOGIN_ID,
1696: (resource_id,resource_grp_id) =
1697: ( SELECT resource_id,resource_grp_id
1698: FROM ASO_QUOTE_ACCESSES AQA

Line 1695: last_update_login = FND_GLOBAL.CONC_LOGIN_ID,

1691: BEGIN
1692: UPDATE ASO_QUOTE_HEADERS_ALL AQH
1693: SET last_update_date = SYSDATE,
1694: last_updated_by = FND_GLOBAL.USER_ID,
1695: last_update_login = FND_GLOBAL.CONC_LOGIN_ID,
1696: (resource_id,resource_grp_id) =
1697: ( SELECT resource_id,resource_grp_id
1698: FROM ASO_QUOTE_ACCESSES AQA
1699: WHERE AQA.access_id = l_access_id(i)

Line 1786: last_updated_by = FND_GLOBAL.USER_ID,

1782: BEGIN
1783: FORALL i in l_first .. l_last
1784: UPDATE ASO_QUOTE_HEADERS_ALL AQH
1785: SET last_update_date = SYSDATE,
1786: last_updated_by = FND_GLOBAL.USER_ID,
1787: last_update_login = FND_GLOBAL.CONC_LOGIN_ID,
1788: (resource_id,resource_grp_id) =
1789: ( SELECT resource_id,org_information3
1790: FROM jtf_rs_Salesreps a , hr_organization_information b

Line 1787: last_update_login = FND_GLOBAL.CONC_LOGIN_ID,

1783: FORALL i in l_first .. l_last
1784: UPDATE ASO_QUOTE_HEADERS_ALL AQH
1785: SET last_update_date = SYSDATE,
1786: last_updated_by = FND_GLOBAL.USER_ID,
1787: last_update_login = FND_GLOBAL.CONC_LOGIN_ID,
1788: (resource_id,resource_grp_id) =
1789: ( SELECT resource_id,org_information3
1790: FROM jtf_rs_Salesreps a , hr_organization_information b
1791: WHERE a.salesrep_number = b.org_information2

Line 1911: last_updated_by = FND_GLOBAL.USER_ID,

1907: FOR i IN l_first .. l_last LOOP
1908: BEGIN
1909: UPDATE ASO_QUOTE_HEADERS_ALL AQH
1910: SET last_update_date = SYSDATE,
1911: last_updated_by = FND_GLOBAL.USER_ID,
1912: last_update_login = FND_GLOBAL.CONC_LOGIN_ID,
1913: (resource_id,resource_grp_id) =
1914: ( SELECT resource_id,org_information3
1915: FROM jtf_rs_Salesreps a , hr_organization_information b

Line 1912: last_update_login = FND_GLOBAL.CONC_LOGIN_ID,

1908: BEGIN
1909: UPDATE ASO_QUOTE_HEADERS_ALL AQH
1910: SET last_update_date = SYSDATE,
1911: last_updated_by = FND_GLOBAL.USER_ID,
1912: last_update_login = FND_GLOBAL.CONC_LOGIN_ID,
1913: (resource_id,resource_grp_id) =
1914: ( SELECT resource_id,org_information3
1915: FROM jtf_rs_Salesreps a , hr_organization_information b
1916: WHERE a.salesrep_number = b.org_information2