1331: L_FlexSeg_Counter Number := 0;
1332:
1333: Cursor L_FlexSegOrder_Curr is
1334: SELECT segment_num from
1335: fnd_id_flex_segments
1336: where application_id = 401
1337: and id_flex_code = 'MSTK'
1338: and enabled_flag = 'Y'
1339: order by segment_num;
1461:
1462: BEGIN
1463: select segment_num
1464: into L_SegNumDummy
1465: from fnd_id_flex_segments
1466: where application_id = 401
1467: and id_flex_code = 'MSTK'
1468: and enabled_flag = 'Y'
1469: and application_column_name = 'SEGMENT1';
1517:
1518: BEGIN
1519: select segment_num
1520: into L_SegNumDummy
1521: from fnd_id_flex_segments
1522: where application_id = 401
1523: and id_flex_code = 'MSTK'
1524: and enabled_flag = 'Y'
1525: and application_column_name = 'SEGMENT2';
1572:
1573: BEGIN
1574: select segment_num
1575: into L_SegNumDummy
1576: from fnd_id_flex_segments
1577: where application_id = 401
1578: and id_flex_code = 'MSTK'
1579: and enabled_flag = 'Y'
1580: and application_column_name = 'SEGMENT3';
1627:
1628: BEGIN
1629: select segment_num
1630: into L_SegNumDummy
1631: from fnd_id_flex_segments
1632: where application_id = 401
1633: and id_flex_code = 'MSTK'
1634: and enabled_flag = 'Y'
1635: and application_column_name = 'SEGMENT4';
1682:
1683: BEGIN
1684: select segment_num
1685: into L_SegNumDummy
1686: from fnd_id_flex_segments
1687: where application_id = 401
1688: and id_flex_code = 'MSTK'
1689: and enabled_flag = 'Y'
1690: and application_column_name = 'SEGMENT5';
1737:
1738: BEGIN
1739: select segment_num
1740: into L_SegNumDummy
1741: from fnd_id_flex_segments
1742: where application_id = 401
1743: and id_flex_code = 'MSTK'
1744: and enabled_flag = 'Y'
1745: and application_column_name = 'SEGMENT6';
1792:
1793: BEGIN
1794: select segment_num
1795: into L_SegNumDummy
1796: from fnd_id_flex_segments
1797: where application_id = 401
1798: and id_flex_code = 'MSTK'
1799: and enabled_flag = 'Y'
1800: and application_column_name = 'SEGMENT7';
1847:
1848: BEGIN
1849: select segment_num
1850: into L_SegNumDummy
1851: from fnd_id_flex_segments
1852: where application_id = 401
1853: and id_flex_code = 'MSTK'
1854: and enabled_flag = 'Y'
1855: and application_column_name = 'SEGMENT8';
1902:
1903: BEGIN
1904: select segment_num
1905: into L_SegNumDummy
1906: from fnd_id_flex_segments
1907: where application_id = 401
1908: and id_flex_code = 'MSTK'
1909: and enabled_flag = 'Y'
1910: and application_column_name = 'SEGMENT9';
1957:
1958: BEGIN
1959: select segment_num
1960: into L_SegNumDummy
1961: from fnd_id_flex_segments
1962: where application_id = 401
1963: and id_flex_code = 'MSTK'
1964: and enabled_flag = 'Y'
1965: and application_column_name = 'SEGMENT10';
2012:
2013: BEGIN
2014: select segment_num
2015: into L_SegNumDummy
2016: from fnd_id_flex_segments
2017: where application_id = 401
2018: and id_flex_code = 'MSTK'
2019: and enabled_flag = 'Y'
2020: and application_column_name = 'SEGMENT11';
2067:
2068: BEGIN
2069: select segment_num
2070: into L_SegNumDummy
2071: from fnd_id_flex_segments
2072: where application_id = 401
2073: and id_flex_code = 'MSTK'
2074: and enabled_flag = 'Y'
2075: and application_column_name = 'SEGMENT12';
2122:
2123: BEGIN
2124: select segment_num
2125: into L_SegNumDummy
2126: from fnd_id_flex_segments
2127: where application_id = 401
2128: and id_flex_code = 'MSTK'
2129: and enabled_flag = 'Y'
2130: and application_column_name = 'SEGMENT13';
2177:
2178: BEGIN
2179: select segment_num
2180: into L_SegNumDummy
2181: from fnd_id_flex_segments
2182: where application_id = 401
2183: and id_flex_code = 'MSTK'
2184: and enabled_flag = 'Y'
2185: and application_column_name = 'SEGMENT14';
2232:
2233: BEGIN
2234: select segment_num
2235: into L_SegNumDummy
2236: from fnd_id_flex_segments
2237: where application_id = 401
2238: and id_flex_code = 'MSTK'
2239: and enabled_flag = 'Y'
2240: and application_column_name = 'SEGMENT15';
2287:
2288: BEGIN
2289: select segment_num
2290: into L_SegNumDummy
2291: from fnd_id_flex_segments
2292: where application_id = 401
2293: and id_flex_code = 'MSTK'
2294: and enabled_flag = 'Y'
2295: and application_column_name = 'SEGMENT16';
2342:
2343: BEGIN
2344: select segment_num
2345: into L_SegNumDummy
2346: from fnd_id_flex_segments
2347: where application_id = 401
2348: and id_flex_code = 'MSTK'
2349: and enabled_flag = 'Y'
2350: and application_column_name = 'SEGMENT17';
2397:
2398: BEGIN
2399: select segment_num
2400: into L_SegNumDummy
2401: from fnd_id_flex_segments
2402: where application_id = 401
2403: and id_flex_code = 'MSTK'
2404: and enabled_flag = 'Y'
2405: and application_column_name = 'SEGMENT18';
2452:
2453: BEGIN
2454: select segment_num
2455: into L_SegNumDummy
2456: from fnd_id_flex_segments
2457: where application_id = 401
2458: and id_flex_code = 'MSTK'
2459: and enabled_flag = 'Y'
2460: and application_column_name = 'SEGMENT19';
2507:
2508: BEGIN
2509: select segment_num
2510: into L_SegNumDummy
2511: from fnd_id_flex_segments
2512: where application_id = 401
2513: and id_flex_code = 'MSTK'
2514: and enabled_flag = 'Y'
2515: and application_column_name = 'SEGMENT20';
3876: L_FlexSeg_Counter Number := 0;
3877:
3878: Cursor L_FlexSegOrder_Curr is
3879: SELECT segment_num from
3880: fnd_id_flex_segments
3881: where application_id = 401
3882: and id_flex_code = 'MSTK'
3883: and enabled_flag = 'Y'
3884: order by segment_num;
4003:
4004: BEGIN
4005: select segment_num
4006: into L_SegNumDummy
4007: from fnd_id_flex_segments
4008: where application_id = 401
4009: and id_flex_code = 'MSTK'
4010: and enabled_flag = 'Y'
4011: and application_column_name = 'SEGMENT1';
4058:
4059: BEGIN
4060: select segment_num
4061: into L_SegNumDummy
4062: from fnd_id_flex_segments
4063: where application_id = 401
4064: and id_flex_code = 'MSTK'
4065: and enabled_flag = 'Y'
4066: and application_column_name = 'SEGMENT2';
4113:
4114: BEGIN
4115: select segment_num
4116: into L_SegNumDummy
4117: from fnd_id_flex_segments
4118: where application_id = 401
4119: and id_flex_code = 'MSTK'
4120: and enabled_flag = 'Y'
4121: and application_column_name = 'SEGMENT3';
4168:
4169: BEGIN
4170: select segment_num
4171: into L_SegNumDummy
4172: from fnd_id_flex_segments
4173: where application_id = 401
4174: and id_flex_code = 'MSTK'
4175: and enabled_flag = 'Y'
4176: and application_column_name = 'SEGMENT4';
4223:
4224: BEGIN
4225: select segment_num
4226: into L_SegNumDummy
4227: from fnd_id_flex_segments
4228: where application_id = 401
4229: and id_flex_code = 'MSTK'
4230: and enabled_flag = 'Y'
4231: and application_column_name = 'SEGMENT5';
4278:
4279: BEGIN
4280: select segment_num
4281: into L_SegNumDummy
4282: from fnd_id_flex_segments
4283: where application_id = 401
4284: and id_flex_code = 'MSTK'
4285: and enabled_flag = 'Y'
4286: and application_column_name = 'SEGMENT6';
4333:
4334: BEGIN
4335: select segment_num
4336: into L_SegNumDummy
4337: from fnd_id_flex_segments
4338: where application_id = 401
4339: and id_flex_code = 'MSTK'
4340: and enabled_flag = 'Y'
4341: and application_column_name = 'SEGMENT7';
4388:
4389: BEGIN
4390: select segment_num
4391: into L_SegNumDummy
4392: from fnd_id_flex_segments
4393: where application_id = 401
4394: and id_flex_code = 'MSTK'
4395: and enabled_flag = 'Y'
4396: and application_column_name = 'SEGMENT8';
4443:
4444: BEGIN
4445: select segment_num
4446: into L_SegNumDummy
4447: from fnd_id_flex_segments
4448: where application_id = 401
4449: and id_flex_code = 'MSTK'
4450: and enabled_flag = 'Y'
4451: and application_column_name = 'SEGMENT9';
4498:
4499: BEGIN
4500: select segment_num
4501: into L_SegNumDummy
4502: from fnd_id_flex_segments
4503: where application_id = 401
4504: and id_flex_code = 'MSTK'
4505: and enabled_flag = 'Y'
4506: and application_column_name = 'SEGMENT10';
4553:
4554: BEGIN
4555: select segment_num
4556: into L_SegNumDummy
4557: from fnd_id_flex_segments
4558: where application_id = 401
4559: and id_flex_code = 'MSTK'
4560: and enabled_flag = 'Y'
4561: and application_column_name = 'SEGMENT11';
4608:
4609: BEGIN
4610: select segment_num
4611: into L_SegNumDummy
4612: from fnd_id_flex_segments
4613: where application_id = 401
4614: and id_flex_code = 'MSTK'
4615: and enabled_flag = 'Y'
4616: and application_column_name = 'SEGMENT12';
4663:
4664: BEGIN
4665: select segment_num
4666: into L_SegNumDummy
4667: from fnd_id_flex_segments
4668: where application_id = 401
4669: and id_flex_code = 'MSTK'
4670: and enabled_flag = 'Y'
4671: and application_column_name = 'SEGMENT13';
4718:
4719: BEGIN
4720: select segment_num
4721: into L_SegNumDummy
4722: from fnd_id_flex_segments
4723: where application_id = 401
4724: and id_flex_code = 'MSTK'
4725: and enabled_flag = 'Y'
4726: and application_column_name = 'SEGMENT14';
4773:
4774: BEGIN
4775: select segment_num
4776: into L_SegNumDummy
4777: from fnd_id_flex_segments
4778: where application_id = 401
4779: and id_flex_code = 'MSTK'
4780: and enabled_flag = 'Y'
4781: and application_column_name = 'SEGMENT15';
4828:
4829: BEGIN
4830: select segment_num
4831: into L_SegNumDummy
4832: from fnd_id_flex_segments
4833: where application_id = 401
4834: and id_flex_code = 'MSTK'
4835: and enabled_flag = 'Y'
4836: and application_column_name = 'SEGMENT16';
4883:
4884: BEGIN
4885: select segment_num
4886: into L_SegNumDummy
4887: from fnd_id_flex_segments
4888: where application_id = 401
4889: and id_flex_code = 'MSTK'
4890: and enabled_flag = 'Y'
4891: and application_column_name = 'SEGMENT17';
4938:
4939: BEGIN
4940: select segment_num
4941: into L_SegNumDummy
4942: from fnd_id_flex_segments
4943: where application_id = 401
4944: and id_flex_code = 'MSTK'
4945: and enabled_flag = 'Y'
4946: and application_column_name = 'SEGMENT18';
4993:
4994: BEGIN
4995: select segment_num
4996: into L_SegNumDummy
4997: from fnd_id_flex_segments
4998: where application_id = 401
4999: and id_flex_code = 'MSTK'
5000: and enabled_flag = 'Y'
5001: and application_column_name = 'SEGMENT19';
5048:
5049: BEGIN
5050: select segment_num
5051: into L_SegNumDummy
5052: from fnd_id_flex_segments
5053: where application_id = 401
5054: and id_flex_code = 'MSTK'
5055: and enabled_flag = 'Y'
5056: and application_column_name = 'SEGMENT20';