[Home] [Help]
1625: -- By mistake i had removed the following piece of code when
1626: -- arcsing in the file in version 115.49. Included it when
1627: -- fixing bug 2649257.suramasw.
1628:
1629: V := FND_FLEX_KEYVAL.VALIDATE_SEGS('CHECK_COMBINATION',
1630: 'INV', 'MTLL', 101, SEGS_TABLE(I), 'V', NULL, 'ALL',
1631: ORG_ID_TABLE(I), NULL, X_WHERE_CLAUSE);
1632:
1633: -- End of inclusions for bug 2649257.
1633: -- End of inclusions for bug 2649257.
1634:
1635: ELSIF (GEN_LOC_CTRL_TABLE(I) = 3) THEN
1636:
1637: V := FND_FLEX_KEYVAL.VALIDATE_SEGS('CREATE_COMBINATION',
1638: 'INV', 'MTLL', 101, SEGS_TABLE(I), 'V', NULL, 'ALL',
1639: ORG_ID_TABLE(I));
1640:
1641: END IF;
1644:
1645: -- get the flex combination id and update the interface table.
1646: -- set cid and x_org_id, which are used by the cursor.
1647:
1648: CID := FND_FLEX_KEYVAL.COMBINATION_ID;
1649:
1650: -- Added the following IF condition. Before the fix when the locator
1651: -- control is 'Predefined' and the user passes a wrong value for locator
1652: -- then the collection import will complete normal but the combination_id
1944: 'DISABLE_DATE IS NULL) AND (NVL(SUBINVENTORY_CODE, ''Z'')) ' ||
1945: '= ' || '''' || TO_SUBINV_TABLE(I) || '''';
1946: END IF;
1947:
1948: V := FND_FLEX_KEYVAL.VALIDATE_SEGS('CHECK_COMBINATION',
1949: 'INV', 'MTLL', 101, SEGS_TABLE(I), 'V', NULL, 'ALL',
1950: ORG_ID_TABLE(I), NULL, X_WHERE_CLAUSE);
1951:
1952: ELSIF (GEN_LOC_CTRL_TABLE(I) = 3) THEN
1950: ORG_ID_TABLE(I), NULL, X_WHERE_CLAUSE);
1951:
1952: ELSIF (GEN_LOC_CTRL_TABLE(I) = 3) THEN
1953:
1954: V := FND_FLEX_KEYVAL.VALIDATE_SEGS('CREATE_COMBINATION',
1955: 'INV', 'MTLL', 101, SEGS_TABLE(I), 'V', NULL, 'ALL',
1956: ORG_ID_TABLE(I));
1957: END IF;
1958: IF (V) THEN
1959:
1960: -- get the flex combination id and update the interface table.
1961: -- set cid and x_org_id, which are used by the cursor.
1962:
1963: CID := FND_FLEX_KEYVAL.COMBINATION_ID;
1964:
1965: -- Added the following IF condition. Before the fix when the locator
1966: -- control is 'Predefined' and the user passes a wrong value for to_locator
1967: -- then the collection import will complete normal but the combination_id
2237: ELSE
2238: X_WHERE_CLAUSE := NULL;
2239: END IF;
2240:
2241: V := FND_FLEX_KEYVAL.VALIDATE_SEGS(
2242: 'CHECK_COMBINATION',
2243: 'INV', 'MSTK', 101, SEGS_TABLE(I), 'V',
2244: NULL, 'ALL', ORG_ID_TABLE(I), NULL, X_WHERE_CLAUSE);
2245:
2247:
2248: -- get the flex combination id and update the interface table.
2249: -- set cid and x_org_id, which are used by the cursor.
2250:
2251: CID := FND_FLEX_KEYVAL.COMBINATION_ID;
2252: X_ORG_ID := ORG_ID_TABLE(I);
2253:
2254: -- Bug 3765678. COMP_ITEM is not getting validated along
2255: -- with ITEM if it is dependent on ITEM. Storing the value
2526: ELSE
2527: X_WHERE_CLAUSE := NULL;
2528: END IF;
2529:
2530: V := FND_FLEX_KEYVAL.VALIDATE_SEGS('CHECK_COMBINATION',
2531: 'INV',
2532: 'MSTK',
2533: 101,
2534: SEGS_TABLE(I),
2542: IF (V) THEN
2543: -- get the flex combination id and update the interface table.
2544: -- set cid and x_org_id, which are used by the cursor.
2545:
2546: CID := FND_FLEX_KEYVAL.COMBINATION_ID;
2547: X_ORG_ID := ORG_ID_TABLE(I);
2548:
2549: SQL_STATEMENT :=
2550: 'UPDATE QA_RESULTS_INTERFACE QRI ' ||
2705: ELSE
2706: X_WHERE_CLAUSE := NULL;
2707: END IF;
2708:
2709: V := FND_FLEX_KEYVAL.VALIDATE_SEGS('CHECK_COMBINATION',
2710: 'INV',
2711: 'MSTK',
2712: 101,
2713: SEGS_TABLE(I),
2721: IF (V) THEN
2722: -- get the flex combination id and update the interface table.
2723: -- set cid and x_org_id, which are used by the cursor.
2724:
2725: CID := FND_FLEX_KEYVAL.COMBINATION_ID;
2726: X_ORG_ID := ORG_ID_TABLE(I);
2727:
2728: -- Bug 3136107.
2729: -- SQL Bind project. Code modified to use bind variables instead of literals