APPS.MSC_PQ_UTILS dependencies on MSC_FORM_QUERY

Line 746: INSERT INTO MSC_FORM_QUERY

742: v_insert_stmt VARCHAR2(2000);
743: BEGIN
744:
745: FORALL i IN 1..l_list.count()
746: INSERT INTO MSC_FORM_QUERY
747: (QUERY_ID, NUMBER1, NUMBER2, NUMBER3,
748: LAST_UPDATE_DATE, LAST_UPDATED_BY ,
749: CREATION_DATE, CREATED_BY,
750: LAST_UPDATE_LOGIN )

Line 759: INSERT INTO MSC_FORM_QUERY

755:
756: IF l_item_list.count() > 0 THEN
757: g_items_list_exists := l_item_list.count();
758: FORALL i IN 1..l_item_list.count()
759: INSERT INTO MSC_FORM_QUERY
760: (QUERY_ID, NUMBER1, NUMBER2, NUMBER4,
761: LAST_UPDATE_DATE, LAST_UPDATED_BY ,
762: CREATION_DATE, CREATED_BY,
763: LAST_UPDATE_LOGIN )

Line 1640: /*v_insert_stmt := ' INSERT INTO MSC_FORM_QUERY (QUERY_ID,'||

1636: /*v_excp_where := ' WHERE med.plan_id = '||p_plan_id ||
1637: ' AND NVL(med.category_set_id,2) = 2' ||
1638: ' AND ( med.TRANSACTION_ID IS NOT NULL '||
1639: ' OR med.INVENTORY_ITEM_ID IS NOT NULL)';*/
1640: /*v_insert_stmt := ' INSERT INTO MSC_FORM_QUERY (QUERY_ID,'||
1641: ' NUMBER1,NUMBER2,CHAR1,NUMBER3,' ||
1642: ' NUMBER4,NUMBER5,' ||
1643: ' LAST_UPDATE_DATE, LAST_UPDATED_BY , ' ||
1644: ' CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN )';*/

Line 1645: /*v_insert_stmt := ' INSERT INTO MSC_FORM_QUERY (QUERY_ID,'||

1641: ' NUMBER1,NUMBER2,CHAR1,NUMBER3,' ||
1642: ' NUMBER4,NUMBER5,' ||
1643: ' LAST_UPDATE_DATE, LAST_UPDATED_BY , ' ||
1644: ' CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN )';*/
1645: /*v_insert_stmt := ' INSERT INTO MSC_FORM_QUERY (QUERY_ID,'||
1646: ' NUMBER1,NUMBER2,NUMBER3,NUMBER4,' ||
1647: ' LAST_UPDATE_DATE, LAST_UPDATED_BY , ' ||
1648: ' CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN )';*/
1649: --KSA_DEBUG(SYSDATE,'STMT IS '||v_insert_stmt||' '||v_excp_str||' '||v_excp_where||' '||p_where_clause,'build_Excp_where');

Line 1650: v_delete_stmt := 'DELETE MSC_FORM_QUERY WHERE QUERY_ID = :p_query_id'

1646: ' NUMBER1,NUMBER2,NUMBER3,NUMBER4,' ||
1647: ' LAST_UPDATE_DATE, LAST_UPDATED_BY , ' ||
1648: ' CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN )';*/
1649: --KSA_DEBUG(SYSDATE,'STMT IS '||v_insert_stmt||' '||v_excp_str||' '||v_excp_where||' '||p_where_clause,'build_Excp_where');
1650: v_delete_stmt := 'DELETE MSC_FORM_QUERY WHERE QUERY_ID = :p_query_id'
1651: ||' AND NUMBER1 = :p_obj_sequence_id AND NUMBER2 = :p_sequence_id';
1652: --KSA_DEBUG(SYSDATE,'del STMT IS '||v_delete_stmt,'build_Excp_where');
1653: execute immediate v_delete_stmt using p_query_id, p_obj_sequence_id, p_sequence_id;
1654: --msc_get_name.execute_dsql(v_delete_stmt);

Line 1661: ' TRANSACTION_ID IN (SELECT NUMBER3 FROM MSC_FORM_QUERY '||

1657: --KSA_DEBUG(SYSDATE,'where is '||l_where_clause,'build_Excp_where');
1658: Parse_exceptions(p_plan_id, l_where_clause);
1659: IF g_items_list_exists > 0 THEN
1660: p_excp_where_clause := '('||
1661: ' TRANSACTION_ID IN (SELECT NUMBER3 FROM MSC_FORM_QUERY '||
1662: ' WHERE QUERY_ID = '||p_query_id ||
1663: ' AND NUMBER1 = '||p_obj_sequence_id||
1664: ' AND NUMBER2 = '|| p_sequence_id ||
1665: ' AND NUMBER3 IS NOT NULL' ||')' ||

Line 1668: ' IN (SELECT NUMBER4 FROM MSC_FORM_QUERY '||

1664: ' AND NUMBER2 = '|| p_sequence_id ||
1665: ' AND NUMBER3 IS NOT NULL' ||')' ||
1666: ' OR '||
1667: ' INVENTORY_ITEM_ID '||
1668: ' IN (SELECT NUMBER4 FROM MSC_FORM_QUERY '||
1669: ' WHERE QUERY_ID = '||p_query_id||
1670: ' AND NUMBER1 = '||p_obj_sequence_id||
1671: ' AND NUMBER2 = '|| p_sequence_id||
1672: ' AND NUMBER4 IS NOT NULL)'||

Line 1676: ' TRANSACTION_ID IN (SELECT NUMBER3 FROM MSC_FORM_QUERY '||

1672: ' AND NUMBER4 IS NOT NULL)'||
1673: ')';
1674: ELSE
1675: p_excp_where_clause := '('||
1676: ' TRANSACTION_ID IN (SELECT NUMBER3 FROM MSC_FORM_QUERY '||
1677: ' WHERE QUERY_ID = '||p_query_id ||
1678: ' AND NUMBER1 = '||p_obj_sequence_id||
1679: ' AND NUMBER2 = '|| p_sequence_id ||
1680: ' AND NUMBER3 IS NOT NULL' ||')' ||