DBA Data[Home] [Help]

APPS.JTY_TAE_GEN_PVT dependencies on JTY_TAE_ATTR_PRODUCTS_SQL

Line 1617: FROM jty_tae_attr_products_sql

1613: AND attr_relation_product = p_qual_prd_tbl(j);
1614: ELSE
1615: SELECT count(*)
1616: INTO l_no_of_records
1617: FROM jty_tae_attr_products_sql
1618: WHERE source_id = p_source_id
1619: AND trans_type_id = p_trans_id
1620: AND program_name = l_pgm_name_tbl(i)
1621: AND attr_relation_product = p_qual_prd_tbl(j);

Line 1701: INSERT INTO JTY_TAE_ATTR_PRODUCTS_SQL(

1697:
1698: RAISE FND_API.G_EXC_ERROR;
1699: END IF;
1700:
1701: INSERT INTO JTY_TAE_ATTR_PRODUCTS_SQL(
1702: ATTR_PRODUCTS_SQL_ID
1703: ,SOURCE_ID
1704: ,TRANS_TYPE_ID
1705: ,PROGRAM_NAME

Line 1722: JTY_TAE_ATTR_PRODUCTS_SQL_S.NEXTVAL

1718: ,PROGRAM_APPLICATION_ID
1719: ,REQUEST_ID
1720: ,PROGRAM_UPDATE_DATE)
1721: VALUES(
1722: JTY_TAE_ATTR_PRODUCTS_SQL_S.NEXTVAL
1723: ,p_source_id
1724: ,p_trans_id
1725: ,l_pgm_name_tbl(i)
1726: ,p_qual_prd_tbl(j)