APPS.AS_GAR_QOT_PUB dependencies on ASO_QUOTE_HEADERS_ALL

Line 1504: FROM JTF_TAE_1001_QUOTE_TRANS TRANS ,ASO_QUOTE_HEADERS_ALL AQH

1500: CURSOR set_primary_srep_sc1_total(c_worker_id number) IS
1501: SELECT W.trans_object_id, MAX(access_id)
1502: FROM ASO_QUOTE_ACCESSES AQA1,
1503: ( SELECT DISTINCT trans_object_id -- Q8
1504: FROM JTF_TAE_1001_QUOTE_TRANS TRANS ,ASO_QUOTE_HEADERS_ALL AQH
1505: WHERE worker_id=c_worker_id
1506: AND TRANS.trans_object_id = AQH.quote_number
1507: AND NOT EXISTS
1508: (

Line 1532: FROM JTF_TAE_1001_QUOTE_NM_TRANS TRANS ,ASO_QUOTE_HEADERS_ALL AQH

1528: CURSOR set_primary_srep_sc1_nm(c_worker_id number) IS
1529: SELECT W.trans_object_id, MAX(access_id)
1530: FROM ASO_QUOTE_ACCESSES AQA1,
1531: ( SELECT DISTINCT trans_object_id -- Q8
1532: FROM JTF_TAE_1001_QUOTE_NM_TRANS TRANS ,ASO_QUOTE_HEADERS_ALL AQH
1533: WHERE worker_id=c_worker_id
1534: AND TRANS.trans_object_id = AQH.quote_number
1535: AND NOT EXISTS
1536: (

Line 1564: FROM JTF_TAE_1001_QUOTE_TRANS TRANS ,ASO_QUOTE_HEADERS_ALL AQH

1560: | These quote headers and accesses should be updated with the profile defaults
1561: |-------------------------------------------------------------------------------*/
1562: CURSOR set_primary_srep_sc2_total(c_worker_id NUMBER) IS
1563: SELECT DISTINCT trans_object_id -- Q9, Q10
1564: FROM JTF_TAE_1001_QUOTE_TRANS TRANS ,ASO_QUOTE_HEADERS_ALL AQH
1565: WHERE worker_id=c_worker_id
1566: AND TRANS.trans_object_id = AQH.quote_number
1567: AND NOT EXISTS
1568: (SELECT 'X'

Line 1581: FROM JTF_TAE_1001_QUOTE_NM_TRANS TRANS ,ASO_QUOTE_HEADERS_ALL AQH

1577: GROUP BY trans_object_id;
1578:
1579: CURSOR set_primary_srep_sc2_nm(c_worker_id NUMBER) IS
1580: SELECT DISTINCT trans_object_id -- Q9, Q10
1581: FROM JTF_TAE_1001_QUOTE_NM_TRANS TRANS ,ASO_QUOTE_HEADERS_ALL AQH
1582: WHERE worker_id=c_worker_id
1583: AND TRANS.trans_object_id = AQH.quote_number
1584: AND NOT EXISTS
1585: (SELECT 'X'

Line 1667: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE ASO_QUOTE_HEADERS_ALL');

1663: IF l_last > l_quote_number_id.LAST THEN
1664: l_last := l_quote_number_id.LAST;
1665: END IF;
1666: WHILE l_attempts < 3 LOOP
1667: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE ASO_QUOTE_HEADERS_ALL');
1668: BEGIN
1669: FORALL i in l_first .. l_last
1670: UPDATE ASO_QUOTE_HEADERS_ALL AQH
1671: SET last_update_date = SYSDATE,

Line 1670: UPDATE ASO_QUOTE_HEADERS_ALL AQH

1666: WHILE l_attempts < 3 LOOP
1667: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE ASO_QUOTE_HEADERS_ALL');
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) =

Line 1692: UPDATE ASO_QUOTE_HEADERS_ALL AQH

1688: l_attempts := l_attempts +1;
1689: IF l_attempts = 3 THEN
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) =

Line 1781: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE ASO_QUOTE_HEADERS_ALL');

1777: IF l_last > l_quote_number_id.LAST THEN
1778: l_last := l_quote_number_id.LAST;
1779: END IF;
1780: WHILE l_attempts < 3 LOOP
1781: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE ASO_QUOTE_HEADERS_ALL');
1782: BEGIN
1783: FORALL i in l_first .. l_last
1784: UPDATE ASO_QUOTE_HEADERS_ALL AQH
1785: SET last_update_date = SYSDATE,

Line 1784: UPDATE ASO_QUOTE_HEADERS_ALL AQH

1780: WHILE l_attempts < 3 LOOP
1781: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE ASO_QUOTE_HEADERS_ALL');
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) =

Line 1909: UPDATE ASO_QUOTE_HEADERS_ALL AQH

1905: l_attempts := l_attempts +1;
1906: IF l_attempts = 3 THEN
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) =