APPS.MSC_PQ_UTILS dependencies on MSC_FORM_QUERY

Line 742: INSERT INTO MSC_FORM_QUERY

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

Line 755: INSERT INTO MSC_FORM_QUERY

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

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

1608: /*v_excp_where := ' WHERE med.plan_id = '||p_plan_id ||
1609: ' AND NVL(med.category_set_id,2) = 2' ||
1610: ' AND ( med.TRANSACTION_ID IS NOT NULL '||
1611: ' OR med.INVENTORY_ITEM_ID IS NOT NULL)';*/
1612: /*v_insert_stmt := ' INSERT INTO MSC_FORM_QUERY (QUERY_ID,'||
1613: ' NUMBER1,NUMBER2,CHAR1,NUMBER3,' ||
1614: ' NUMBER4,NUMBER5,' ||
1615: ' LAST_UPDATE_DATE, LAST_UPDATED_BY , ' ||
1616: ' CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN )';*/

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

1613: ' NUMBER1,NUMBER2,CHAR1,NUMBER3,' ||
1614: ' NUMBER4,NUMBER5,' ||
1615: ' LAST_UPDATE_DATE, LAST_UPDATED_BY , ' ||
1616: ' CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN )';*/
1617: /*v_insert_stmt := ' INSERT INTO MSC_FORM_QUERY (QUERY_ID,'||
1618: ' NUMBER1,NUMBER2,NUMBER3,NUMBER4,' ||
1619: ' LAST_UPDATE_DATE, LAST_UPDATED_BY , ' ||
1620: ' CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN )';*/
1621: --KSA_DEBUG(SYSDATE,'STMT IS '||v_insert_stmt||' '||v_excp_str||' '||v_excp_where||' '||p_where_clause,'build_Excp_where');

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

1618: ' NUMBER1,NUMBER2,NUMBER3,NUMBER4,' ||
1619: ' LAST_UPDATE_DATE, LAST_UPDATED_BY , ' ||
1620: ' CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN )';*/
1621: --KSA_DEBUG(SYSDATE,'STMT IS '||v_insert_stmt||' '||v_excp_str||' '||v_excp_where||' '||p_where_clause,'build_Excp_where');
1622: v_delete_stmt := 'DELETE MSC_FORM_QUERY WHERE QUERY_ID = :p_query_id'
1623: ||' AND NUMBER1 = :p_obj_sequence_id AND NUMBER2 = :p_sequence_id';
1624: --KSA_DEBUG(SYSDATE,'del STMT IS '||v_delete_stmt,'build_Excp_where');
1625: execute immediate v_delete_stmt using p_query_id, p_obj_sequence_id, p_sequence_id;
1626: --msc_get_name.execute_dsql(v_delete_stmt);

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

1629: --KSA_DEBUG(SYSDATE,'where is '||l_where_clause,'build_Excp_where');
1630: Parse_exceptions(p_plan_id, l_where_clause);
1631: IF g_items_list_exists > 0 THEN
1632: p_excp_where_clause := '('||
1633: ' TRANSACTION_ID IN (SELECT NUMBER3 FROM MSC_FORM_QUERY '||
1634: ' WHERE QUERY_ID = '||p_query_id ||
1635: ' AND NUMBER1 = '||p_obj_sequence_id||
1636: ' AND NUMBER2 = '|| p_sequence_id ||
1637: ' AND NUMBER3 IS NOT NULL' ||')' ||

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

1636: ' AND NUMBER2 = '|| p_sequence_id ||
1637: ' AND NUMBER3 IS NOT NULL' ||')' ||
1638: ' OR '||
1639: ' INVENTORY_ITEM_ID '||
1640: ' IN (SELECT NUMBER4 FROM MSC_FORM_QUERY '||
1641: ' WHERE QUERY_ID = '||p_query_id||
1642: ' AND NUMBER1 = '||p_obj_sequence_id||
1643: ' AND NUMBER2 = '|| p_sequence_id||
1644: ' AND NUMBER4 IS NOT NULL)'||

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

1644: ' AND NUMBER4 IS NOT NULL)'||
1645: ')';
1646: ELSE
1647: p_excp_where_clause := '('||
1648: ' TRANSACTION_ID IN (SELECT NUMBER3 FROM MSC_FORM_QUERY '||
1649: ' WHERE QUERY_ID = '||p_query_id ||
1650: ' AND NUMBER1 = '||p_obj_sequence_id||
1651: ' AND NUMBER2 = '|| p_sequence_id ||
1652: ' AND NUMBER3 IS NOT NULL' ||')' ||