DBA Data[Home] [Help]

APPS.INVCIINT dependencies on FND_ID_FLEX_SEGMENTS

Line 1335: fnd_id_flex_segments

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;

Line 1465: from fnd_id_flex_segments

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';

Line 1521: from fnd_id_flex_segments

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';

Line 1576: from fnd_id_flex_segments

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';

Line 1631: from fnd_id_flex_segments

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';

Line 1686: from fnd_id_flex_segments

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';

Line 1741: from fnd_id_flex_segments

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';

Line 1796: from fnd_id_flex_segments

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';

Line 1851: from fnd_id_flex_segments

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';

Line 1906: from fnd_id_flex_segments

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';

Line 1961: from fnd_id_flex_segments

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';

Line 2016: from fnd_id_flex_segments

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';

Line 2071: from fnd_id_flex_segments

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';

Line 2126: from fnd_id_flex_segments

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';

Line 2181: from fnd_id_flex_segments

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';

Line 2236: from fnd_id_flex_segments

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';

Line 2291: from fnd_id_flex_segments

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';

Line 2346: from fnd_id_flex_segments

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';

Line 2401: from fnd_id_flex_segments

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';

Line 2456: from fnd_id_flex_segments

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';

Line 2511: from fnd_id_flex_segments

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';

Line 3880: fnd_id_flex_segments

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;

Line 4007: from fnd_id_flex_segments

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';

Line 4062: from fnd_id_flex_segments

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';

Line 4117: from fnd_id_flex_segments

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';

Line 4172: from fnd_id_flex_segments

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';

Line 4227: from fnd_id_flex_segments

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';

Line 4282: from fnd_id_flex_segments

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';

Line 4337: from fnd_id_flex_segments

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';

Line 4392: from fnd_id_flex_segments

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';

Line 4447: from fnd_id_flex_segments

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';

Line 4502: from fnd_id_flex_segments

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';

Line 4557: from fnd_id_flex_segments

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';

Line 4612: from fnd_id_flex_segments

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';

Line 4667: from fnd_id_flex_segments

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';

Line 4722: from fnd_id_flex_segments

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';

Line 4777: from fnd_id_flex_segments

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';

Line 4832: from fnd_id_flex_segments

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';

Line 4887: from fnd_id_flex_segments

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';

Line 4942: from fnd_id_flex_segments

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';

Line 4997: from fnd_id_flex_segments

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';

Line 5052: from fnd_id_flex_segments

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';