DBA Data[Home] [Help]

APPS.AS_GAR_QOT_PUB dependencies on ASO_QUOTE_ACCESSES_S

Line 1155: ASO_QUOTE_ACCESSES_S.nextval,

1151: TERRITORY_ID,
1152: TERRITORY_SOURCE_FLAG,
1153: ROLE_ID
1154: ) VALUES (
1155: ASO_QUOTE_ACCESSES_S.nextval,
1156: l_quote_number_id(i),
1157: l_resource_id(i),
1158: l_sales_group_id(i),
1159: p_terr_globals.user_id,

Line 1203: aso_quote_accesses_s.NEXTVAL,

1199: territory_id,
1200: territory_source_flag,
1201: role_id
1202: ) VALUES (
1203: aso_quote_accesses_s.NEXTVAL,
1204: l_quote_number_id(i),
1205: l_resource_id(i),
1206: l_sales_group_id(i),
1207: p_terr_globals.user_id,

Line 1820: SELECT ASO_QUOTE_ACCESSES_S.nextval,

1816: TERRITORY_ID,
1817: TERRITORY_SOURCE_FLAG,
1818: ROLE_ID
1819: )
1820: SELECT ASO_QUOTE_ACCESSES_S.nextval,
1821: l_quote_number_id(i),
1822: l_sales_rep_id(i),
1823: l_sales_grp_id(i),
1824: p_terr_globals.user_id,

Line 1871: SELECT ASO_QUOTE_ACCESSES_S.nextval,

1867: TERRITORY_ID,
1868: TERRITORY_SOURCE_FLAG,
1869: ROLE_ID
1870: )
1871: SELECT ASO_QUOTE_ACCESSES_S.nextval,
1872: l_quote_number_id(i),
1873: l_sales_rep_id(i),
1874: l_sales_grp_id(i),
1875: p_terr_globals.user_id,

Line 1944: SELECT ASO_QUOTE_ACCESSES_S.nextval,

1940: TERRITORY_ID,
1941: TERRITORY_SOURCE_FLAG,
1942: ROLE_ID
1943: )
1944: SELECT ASO_QUOTE_ACCESSES_S.nextval,
1945: l_quote_number_id(i),
1946: l_sales_rep_id(i),
1947: l_sales_grp_id(i),
1948: p_terr_globals.user_id,

Line 2003: SELECT ASO_QUOTE_ACCESSES_S.nextval,

1999: TERRITORY_ID,
2000: TERRITORY_SOURCE_FLAG,
2001: ROLE_ID
2002: )
2003: SELECT ASO_QUOTE_ACCESSES_S.nextval,
2004: l_quote_number_id(i),
2005: l_sales_rep_id(i),
2006: l_sales_grp_id(i),
2007: p_terr_globals.user_id,