DBA Data[Home] [Help]

APPS.JTY_TAE_GEN_PVT dependencies on JTY_TAE_ATTR_PRODUCTS_SQL

Line 1550: FROM jty_tae_attr_products_sql

1546: AND attr_relation_product = p_qual_prd_tbl(j);
1547: ELSE
1548: SELECT count(*)
1549: INTO l_no_of_records
1550: FROM jty_tae_attr_products_sql
1551: WHERE source_id = p_source_id
1552: AND trans_type_id = p_trans_id
1553: AND program_name = l_pgm_name_tbl(i)
1554: AND attr_relation_product = p_qual_prd_tbl(j);

Line 1628: INSERT INTO JTY_TAE_ATTR_PRODUCTS_SQL(

1624:
1625: RAISE FND_API.G_EXC_ERROR;
1626: END IF;
1627:
1628: INSERT INTO JTY_TAE_ATTR_PRODUCTS_SQL(
1629: ATTR_PRODUCTS_SQL_ID
1630: ,SOURCE_ID
1631: ,TRANS_TYPE_ID
1632: ,PROGRAM_NAME

Line 1649: JTY_TAE_ATTR_PRODUCTS_SQL_S.NEXTVAL

1645: ,PROGRAM_APPLICATION_ID
1646: ,REQUEST_ID
1647: ,PROGRAM_UPDATE_DATE)
1648: VALUES(
1649: JTY_TAE_ATTR_PRODUCTS_SQL_S.NEXTVAL
1650: ,p_source_id
1651: ,p_trans_id
1652: ,l_pgm_name_tbl(i)
1653: ,p_qual_prd_tbl(j)