APPS.INVPUOPI dependencies on FND_ID_FLEX_SEGMENTS

Line 24: G_MIN_SEGMENT FND_ID_FLEX_SEGMENTS.application_column_name%TYPE;

20: TYPE G_SEGMENTS_USED_TYPE IS TABLE OF NUMBER
21: INDEX BY PLS_INTEGER;
22: G_SEGMENTS_USED G_SEGMENTS_USED_TYPE;
23: G_SEGMENT_NUMS_USED G_SEGMENTS_USED_TYPE;
24: G_MIN_SEGMENT FND_ID_FLEX_SEGMENTS.application_column_name%TYPE;
25: G_MIN_SEG_NUM NUMBER;
26: G_CHECK_SEG_NUM NUMBER;
27: --End Bug: 4654433
28:

Line 46: FROM FND_ID_FLEX_SEGMENTS FS

42: FOR i in G_SEGMENT_NUMS_USED.FIRST..G_SEGMENT_NUMS_USED.LAST LOOP
43: BEGIN
44: SELECT FS.application_column_name
45: INTO l_segment_name
46: FROM FND_ID_FLEX_SEGMENTS FS
47: WHERE FS.SEGMENT_NUM = G_SEGMENT_NUMS_USED(i)
48: AND FS.ID_FLEX_CODE = l_id_flex_code
49: AND FS.ID_FLEX_NUM = l_id_flex_num
50: AND FS.ENABLED_FLAG = l_enabled_flag

Line 512: FROM FND_ID_FLEX_SEGMENTS FS

508: statement_num := 4.1;
509:
510: SELECT max(FS.segment_num)
511: INTO max_segment
512: FROM FND_ID_FLEX_SEGMENTS FS
513: WHERE FS.APPLICATION_ID = l_application_id
514: AND FS.id_flex_code = flex_code
515: AND FS.ENABLED_FLAG = 'Y'
516: AND FS.id_flex_num = structure_id;

Line 598: FROM FND_ID_FLEX_SEGMENTS

594: end loop;
595: ELSE
596: SELECT to_number(substr(application_column_name,8)), segment_num BULK COLLECT INTO
597: G_SEGMENTS_USED, G_SEGMENT_NUMS_USED
598: FROM FND_ID_FLEX_SEGMENTS
599: WHERE APPLICATION_ID = l_application_id
600: AND id_flex_code = flex_code
601: AND ENABLED_FLAG = 'Y'
602: AND id_flex_num = structure_id

Line 763: from FND_ID_FLEX_SEGMENTS FS

759: num_of_segments := G_NUM_OF_SEGMENTS;
760:
761: select min(FS.application_column_name),min(FS.segment_num)
762: into min_segment,min_seg_num
763: from FND_ID_FLEX_SEGMENTS FS
764: where FS.APPLICATION_ID = l_application_id
765: and FS.id_flex_code = l_id_flex_code
766: and FS.ENABLED_FLAG = l_enabled_flag
767: and FS.id_flex_num = l_id_flex_num;

Line 772: from FND_ID_FLEX_SEGMENTS FS

768:
769: /* Start of Bugfix 4082723 Anmurali */
770: BEGIN
771: select FS.segment_num into check_seg_num
772: from FND_ID_FLEX_SEGMENTS FS
773: where FS.APPLICATION_ID = l_application_id
774: and FS.id_flex_code = l_id_flex_code
775: and FS.ENABLED_FLAG = l_enabled_flag
776: and FS.id_flex_num = l_id_flex_num

Line 1106: FROM FND_ID_FLEX_SEGMENTS FS

1102: AND FT.ID_FLEX_NUM = l_id_flex_num;
1103:
1104: SELECT max(FS.segment_num)
1105: INTO G_SEGMENTS_INUSE
1106: FROM FND_ID_FLEX_SEGMENTS FS
1107: WHERE FS.APPLICATION_ID = l_application_id
1108: AND FS.id_flex_code = l_id_flex_code
1109: AND FS.ENABLED_FLAG = l_enabled_flag
1110: AND FS.id_flex_num = l_id_flex_num;

Line 1113: FROM FND_ID_FLEX_SEGMENTS

1109: AND FS.ENABLED_FLAG = l_enabled_flag
1110: AND FS.id_flex_num = l_id_flex_num;
1111:
1112: SELECT to_number(substr(application_column_name,8)), segment_num BULK COLLECT INTO G_SEGMENTS_USED, G_SEGMENT_NUMS_USED
1113: FROM FND_ID_FLEX_SEGMENTS
1114: WHERE APPLICATION_ID = l_application_id
1115: AND id_flex_code = l_id_flex_code
1116: AND ENABLED_FLAG = l_enabled_flag
1117: AND id_flex_num = l_id_flex_num

Line 1121: FROM FND_ID_FLEX_SEGMENTS FS

1117: AND id_flex_num = l_id_flex_num
1118: ORDER BY segment_num;
1119:
1120: SELECT COUNT(*) INTO G_NUM_OF_SEGMENTS
1121: FROM FND_ID_FLEX_SEGMENTS FS
1122: WHERE FS.APPLICATION_ID = l_application_id
1123: AND FS.id_flex_code = l_id_flex_code
1124: AND FS.ENABLED_FLAG = l_enabled_flag
1125: AND FS.id_flex_num = l_id_flex_num;

Line 1129: FROM FND_ID_FLEX_SEGMENTS FS

1125: AND FS.id_flex_num = l_id_flex_num;
1126:
1127: SELECT min(FS.application_column_name),min(FS.segment_num)
1128: INTO G_MIN_SEGMENT,G_MIN_SEG_NUM
1129: FROM FND_ID_FLEX_SEGMENTS FS
1130: WHERE FS.APPLICATION_ID = l_application_id
1131: AND FS.id_flex_code = l_id_flex_code
1132: AND FS.ENABLED_FLAG = l_enabled_flag
1133: AND FS.id_flex_num = l_id_flex_num;

Line 1137: from FND_ID_FLEX_SEGMENTS FS

1133: AND FS.id_flex_num = l_id_flex_num;
1134:
1135: BEGIN
1136: select FS.segment_num into G_CHECK_SEG_NUM
1137: from FND_ID_FLEX_SEGMENTS FS
1138: where FS.APPLICATION_ID = l_application_id
1139: and FS.id_flex_code = l_id_flex_code
1140: and FS.ENABLED_FLAG = l_enabled_flag
1141: and FS.id_flex_num = l_id_flex_num