DBA Data[Home] [Help]

APPS.INVCIINT dependencies on FND_ID_FLEX_SEGMENTS

Line 1334: fnd_id_flex_segments

1330: L_FlexSeg_Counter Number := 0;
1331:
1332: Cursor L_FlexSegOrder_Curr is
1333: SELECT segment_num from
1334: fnd_id_flex_segments
1335: where application_id = 401
1336: and id_flex_code = 'MSTK'
1337: and enabled_flag = 'Y'
1338: order by segment_num;

Line 1464: from fnd_id_flex_segments

1460:
1461: BEGIN
1462: select segment_num
1463: into L_SegNumDummy
1464: from fnd_id_flex_segments
1465: where application_id = 401
1466: and id_flex_code = 'MSTK'
1467: and enabled_flag = 'Y'
1468: and application_column_name = 'SEGMENT1';

Line 1520: from fnd_id_flex_segments

1516:
1517: BEGIN
1518: select segment_num
1519: into L_SegNumDummy
1520: from fnd_id_flex_segments
1521: where application_id = 401
1522: and id_flex_code = 'MSTK'
1523: and enabled_flag = 'Y'
1524: and application_column_name = 'SEGMENT2';

Line 1575: from fnd_id_flex_segments

1571:
1572: BEGIN
1573: select segment_num
1574: into L_SegNumDummy
1575: from fnd_id_flex_segments
1576: where application_id = 401
1577: and id_flex_code = 'MSTK'
1578: and enabled_flag = 'Y'
1579: and application_column_name = 'SEGMENT3';

Line 1630: from fnd_id_flex_segments

1626:
1627: BEGIN
1628: select segment_num
1629: into L_SegNumDummy
1630: from fnd_id_flex_segments
1631: where application_id = 401
1632: and id_flex_code = 'MSTK'
1633: and enabled_flag = 'Y'
1634: and application_column_name = 'SEGMENT4';

Line 1685: from fnd_id_flex_segments

1681:
1682: BEGIN
1683: select segment_num
1684: into L_SegNumDummy
1685: from fnd_id_flex_segments
1686: where application_id = 401
1687: and id_flex_code = 'MSTK'
1688: and enabled_flag = 'Y'
1689: and application_column_name = 'SEGMENT5';

Line 1740: from fnd_id_flex_segments

1736:
1737: BEGIN
1738: select segment_num
1739: into L_SegNumDummy
1740: from fnd_id_flex_segments
1741: where application_id = 401
1742: and id_flex_code = 'MSTK'
1743: and enabled_flag = 'Y'
1744: and application_column_name = 'SEGMENT6';

Line 1795: from fnd_id_flex_segments

1791:
1792: BEGIN
1793: select segment_num
1794: into L_SegNumDummy
1795: from fnd_id_flex_segments
1796: where application_id = 401
1797: and id_flex_code = 'MSTK'
1798: and enabled_flag = 'Y'
1799: and application_column_name = 'SEGMENT7';

Line 1850: from fnd_id_flex_segments

1846:
1847: BEGIN
1848: select segment_num
1849: into L_SegNumDummy
1850: from fnd_id_flex_segments
1851: where application_id = 401
1852: and id_flex_code = 'MSTK'
1853: and enabled_flag = 'Y'
1854: and application_column_name = 'SEGMENT8';

Line 1905: from fnd_id_flex_segments

1901:
1902: BEGIN
1903: select segment_num
1904: into L_SegNumDummy
1905: from fnd_id_flex_segments
1906: where application_id = 401
1907: and id_flex_code = 'MSTK'
1908: and enabled_flag = 'Y'
1909: and application_column_name = 'SEGMENT9';

Line 1960: from fnd_id_flex_segments

1956:
1957: BEGIN
1958: select segment_num
1959: into L_SegNumDummy
1960: from fnd_id_flex_segments
1961: where application_id = 401
1962: and id_flex_code = 'MSTK'
1963: and enabled_flag = 'Y'
1964: and application_column_name = 'SEGMENT10';

Line 2015: from fnd_id_flex_segments

2011:
2012: BEGIN
2013: select segment_num
2014: into L_SegNumDummy
2015: from fnd_id_flex_segments
2016: where application_id = 401
2017: and id_flex_code = 'MSTK'
2018: and enabled_flag = 'Y'
2019: and application_column_name = 'SEGMENT11';

Line 2070: from fnd_id_flex_segments

2066:
2067: BEGIN
2068: select segment_num
2069: into L_SegNumDummy
2070: from fnd_id_flex_segments
2071: where application_id = 401
2072: and id_flex_code = 'MSTK'
2073: and enabled_flag = 'Y'
2074: and application_column_name = 'SEGMENT12';

Line 2125: from fnd_id_flex_segments

2121:
2122: BEGIN
2123: select segment_num
2124: into L_SegNumDummy
2125: from fnd_id_flex_segments
2126: where application_id = 401
2127: and id_flex_code = 'MSTK'
2128: and enabled_flag = 'Y'
2129: and application_column_name = 'SEGMENT13';

Line 2180: from fnd_id_flex_segments

2176:
2177: BEGIN
2178: select segment_num
2179: into L_SegNumDummy
2180: from fnd_id_flex_segments
2181: where application_id = 401
2182: and id_flex_code = 'MSTK'
2183: and enabled_flag = 'Y'
2184: and application_column_name = 'SEGMENT14';

Line 2235: from fnd_id_flex_segments

2231:
2232: BEGIN
2233: select segment_num
2234: into L_SegNumDummy
2235: from fnd_id_flex_segments
2236: where application_id = 401
2237: and id_flex_code = 'MSTK'
2238: and enabled_flag = 'Y'
2239: and application_column_name = 'SEGMENT15';

Line 2290: from fnd_id_flex_segments

2286:
2287: BEGIN
2288: select segment_num
2289: into L_SegNumDummy
2290: from fnd_id_flex_segments
2291: where application_id = 401
2292: and id_flex_code = 'MSTK'
2293: and enabled_flag = 'Y'
2294: and application_column_name = 'SEGMENT16';

Line 2345: from fnd_id_flex_segments

2341:
2342: BEGIN
2343: select segment_num
2344: into L_SegNumDummy
2345: from fnd_id_flex_segments
2346: where application_id = 401
2347: and id_flex_code = 'MSTK'
2348: and enabled_flag = 'Y'
2349: and application_column_name = 'SEGMENT17';

Line 2400: from fnd_id_flex_segments

2396:
2397: BEGIN
2398: select segment_num
2399: into L_SegNumDummy
2400: from fnd_id_flex_segments
2401: where application_id = 401
2402: and id_flex_code = 'MSTK'
2403: and enabled_flag = 'Y'
2404: and application_column_name = 'SEGMENT18';

Line 2455: from fnd_id_flex_segments

2451:
2452: BEGIN
2453: select segment_num
2454: into L_SegNumDummy
2455: from fnd_id_flex_segments
2456: where application_id = 401
2457: and id_flex_code = 'MSTK'
2458: and enabled_flag = 'Y'
2459: and application_column_name = 'SEGMENT19';

Line 2510: from fnd_id_flex_segments

2506:
2507: BEGIN
2508: select segment_num
2509: into L_SegNumDummy
2510: from fnd_id_flex_segments
2511: where application_id = 401
2512: and id_flex_code = 'MSTK'
2513: and enabled_flag = 'Y'
2514: and application_column_name = 'SEGMENT20';

Line 3879: fnd_id_flex_segments

3875: L_FlexSeg_Counter Number := 0;
3876:
3877: Cursor L_FlexSegOrder_Curr is
3878: SELECT segment_num from
3879: fnd_id_flex_segments
3880: where application_id = 401
3881: and id_flex_code = 'MSTK'
3882: and enabled_flag = 'Y'
3883: order by segment_num;

Line 4006: from fnd_id_flex_segments

4002:
4003: BEGIN
4004: select segment_num
4005: into L_SegNumDummy
4006: from fnd_id_flex_segments
4007: where application_id = 401
4008: and id_flex_code = 'MSTK'
4009: and enabled_flag = 'Y'
4010: and application_column_name = 'SEGMENT1';

Line 4061: from fnd_id_flex_segments

4057:
4058: BEGIN
4059: select segment_num
4060: into L_SegNumDummy
4061: from fnd_id_flex_segments
4062: where application_id = 401
4063: and id_flex_code = 'MSTK'
4064: and enabled_flag = 'Y'
4065: and application_column_name = 'SEGMENT2';

Line 4116: from fnd_id_flex_segments

4112:
4113: BEGIN
4114: select segment_num
4115: into L_SegNumDummy
4116: from fnd_id_flex_segments
4117: where application_id = 401
4118: and id_flex_code = 'MSTK'
4119: and enabled_flag = 'Y'
4120: and application_column_name = 'SEGMENT3';

Line 4171: from fnd_id_flex_segments

4167:
4168: BEGIN
4169: select segment_num
4170: into L_SegNumDummy
4171: from fnd_id_flex_segments
4172: where application_id = 401
4173: and id_flex_code = 'MSTK'
4174: and enabled_flag = 'Y'
4175: and application_column_name = 'SEGMENT4';

Line 4226: from fnd_id_flex_segments

4222:
4223: BEGIN
4224: select segment_num
4225: into L_SegNumDummy
4226: from fnd_id_flex_segments
4227: where application_id = 401
4228: and id_flex_code = 'MSTK'
4229: and enabled_flag = 'Y'
4230: and application_column_name = 'SEGMENT5';

Line 4281: from fnd_id_flex_segments

4277:
4278: BEGIN
4279: select segment_num
4280: into L_SegNumDummy
4281: from fnd_id_flex_segments
4282: where application_id = 401
4283: and id_flex_code = 'MSTK'
4284: and enabled_flag = 'Y'
4285: and application_column_name = 'SEGMENT6';

Line 4336: from fnd_id_flex_segments

4332:
4333: BEGIN
4334: select segment_num
4335: into L_SegNumDummy
4336: from fnd_id_flex_segments
4337: where application_id = 401
4338: and id_flex_code = 'MSTK'
4339: and enabled_flag = 'Y'
4340: and application_column_name = 'SEGMENT7';

Line 4391: from fnd_id_flex_segments

4387:
4388: BEGIN
4389: select segment_num
4390: into L_SegNumDummy
4391: from fnd_id_flex_segments
4392: where application_id = 401
4393: and id_flex_code = 'MSTK'
4394: and enabled_flag = 'Y'
4395: and application_column_name = 'SEGMENT8';

Line 4446: from fnd_id_flex_segments

4442:
4443: BEGIN
4444: select segment_num
4445: into L_SegNumDummy
4446: from fnd_id_flex_segments
4447: where application_id = 401
4448: and id_flex_code = 'MSTK'
4449: and enabled_flag = 'Y'
4450: and application_column_name = 'SEGMENT9';

Line 4501: from fnd_id_flex_segments

4497:
4498: BEGIN
4499: select segment_num
4500: into L_SegNumDummy
4501: from fnd_id_flex_segments
4502: where application_id = 401
4503: and id_flex_code = 'MSTK'
4504: and enabled_flag = 'Y'
4505: and application_column_name = 'SEGMENT10';

Line 4556: from fnd_id_flex_segments

4552:
4553: BEGIN
4554: select segment_num
4555: into L_SegNumDummy
4556: from fnd_id_flex_segments
4557: where application_id = 401
4558: and id_flex_code = 'MSTK'
4559: and enabled_flag = 'Y'
4560: and application_column_name = 'SEGMENT11';

Line 4611: from fnd_id_flex_segments

4607:
4608: BEGIN
4609: select segment_num
4610: into L_SegNumDummy
4611: from fnd_id_flex_segments
4612: where application_id = 401
4613: and id_flex_code = 'MSTK'
4614: and enabled_flag = 'Y'
4615: and application_column_name = 'SEGMENT12';

Line 4666: from fnd_id_flex_segments

4662:
4663: BEGIN
4664: select segment_num
4665: into L_SegNumDummy
4666: from fnd_id_flex_segments
4667: where application_id = 401
4668: and id_flex_code = 'MSTK'
4669: and enabled_flag = 'Y'
4670: and application_column_name = 'SEGMENT13';

Line 4721: from fnd_id_flex_segments

4717:
4718: BEGIN
4719: select segment_num
4720: into L_SegNumDummy
4721: from fnd_id_flex_segments
4722: where application_id = 401
4723: and id_flex_code = 'MSTK'
4724: and enabled_flag = 'Y'
4725: and application_column_name = 'SEGMENT14';

Line 4776: from fnd_id_flex_segments

4772:
4773: BEGIN
4774: select segment_num
4775: into L_SegNumDummy
4776: from fnd_id_flex_segments
4777: where application_id = 401
4778: and id_flex_code = 'MSTK'
4779: and enabled_flag = 'Y'
4780: and application_column_name = 'SEGMENT15';

Line 4831: from fnd_id_flex_segments

4827:
4828: BEGIN
4829: select segment_num
4830: into L_SegNumDummy
4831: from fnd_id_flex_segments
4832: where application_id = 401
4833: and id_flex_code = 'MSTK'
4834: and enabled_flag = 'Y'
4835: and application_column_name = 'SEGMENT16';

Line 4886: from fnd_id_flex_segments

4882:
4883: BEGIN
4884: select segment_num
4885: into L_SegNumDummy
4886: from fnd_id_flex_segments
4887: where application_id = 401
4888: and id_flex_code = 'MSTK'
4889: and enabled_flag = 'Y'
4890: and application_column_name = 'SEGMENT17';

Line 4941: from fnd_id_flex_segments

4937:
4938: BEGIN
4939: select segment_num
4940: into L_SegNumDummy
4941: from fnd_id_flex_segments
4942: where application_id = 401
4943: and id_flex_code = 'MSTK'
4944: and enabled_flag = 'Y'
4945: and application_column_name = 'SEGMENT18';

Line 4996: from fnd_id_flex_segments

4992:
4993: BEGIN
4994: select segment_num
4995: into L_SegNumDummy
4996: from fnd_id_flex_segments
4997: where application_id = 401
4998: and id_flex_code = 'MSTK'
4999: and enabled_flag = 'Y'
5000: and application_column_name = 'SEGMENT19';

Line 5051: from fnd_id_flex_segments

5047:
5048: BEGIN
5049: select segment_num
5050: into L_SegNumDummy
5051: from fnd_id_flex_segments
5052: where application_id = 401
5053: and id_flex_code = 'MSTK'
5054: and enabled_flag = 'Y'
5055: and application_column_name = 'SEGMENT20';