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 744: from FND_ID_FLEX_SEGMENTS FS

740: num_of_segments := G_NUM_OF_SEGMENTS;
741:
742: select min(FS.application_column_name),min(FS.segment_num)
743: into min_segment,min_seg_num
744: from FND_ID_FLEX_SEGMENTS FS
745: where FS.APPLICATION_ID = l_application_id
746: and FS.id_flex_code = l_id_flex_code
747: and FS.ENABLED_FLAG = l_enabled_flag
748: and FS.id_flex_num = l_id_flex_num;

Line 753: from FND_ID_FLEX_SEGMENTS FS

749:
750: /* Start of Bugfix 4082723 Anmurali */
751: BEGIN
752: select FS.segment_num into check_seg_num
753: from FND_ID_FLEX_SEGMENTS FS
754: where FS.APPLICATION_ID = l_application_id
755: and FS.id_flex_code = l_id_flex_code
756: and FS.ENABLED_FLAG = l_enabled_flag
757: and FS.id_flex_num = l_id_flex_num

Line 1087: FROM FND_ID_FLEX_SEGMENTS FS

1083: AND FT.ID_FLEX_NUM = l_id_flex_num;
1084:
1085: SELECT max(FS.segment_num)
1086: INTO G_SEGMENTS_INUSE
1087: FROM FND_ID_FLEX_SEGMENTS FS
1088: WHERE FS.APPLICATION_ID = l_application_id
1089: AND FS.id_flex_code = l_id_flex_code
1090: AND FS.ENABLED_FLAG = l_enabled_flag
1091: AND FS.id_flex_num = l_id_flex_num;

Line 1094: FROM FND_ID_FLEX_SEGMENTS

1090: AND FS.ENABLED_FLAG = l_enabled_flag
1091: AND FS.id_flex_num = l_id_flex_num;
1092:
1093: SELECT to_number(substr(application_column_name,8)), segment_num BULK COLLECT INTO G_SEGMENTS_USED, G_SEGMENT_NUMS_USED
1094: FROM FND_ID_FLEX_SEGMENTS
1095: WHERE APPLICATION_ID = l_application_id
1096: AND id_flex_code = l_id_flex_code
1097: AND ENABLED_FLAG = l_enabled_flag
1098: AND id_flex_num = l_id_flex_num

Line 1102: FROM FND_ID_FLEX_SEGMENTS FS

1098: AND id_flex_num = l_id_flex_num
1099: ORDER BY segment_num;
1100:
1101: SELECT COUNT(*) INTO G_NUM_OF_SEGMENTS
1102: FROM FND_ID_FLEX_SEGMENTS FS
1103: WHERE FS.APPLICATION_ID = l_application_id
1104: AND FS.id_flex_code = l_id_flex_code
1105: AND FS.ENABLED_FLAG = l_enabled_flag
1106: AND FS.id_flex_num = l_id_flex_num;

Line 1110: FROM FND_ID_FLEX_SEGMENTS FS

1106: AND FS.id_flex_num = l_id_flex_num;
1107:
1108: SELECT min(FS.application_column_name),min(FS.segment_num)
1109: INTO G_MIN_SEGMENT,G_MIN_SEG_NUM
1110: FROM FND_ID_FLEX_SEGMENTS FS
1111: WHERE FS.APPLICATION_ID = l_application_id
1112: AND FS.id_flex_code = l_id_flex_code
1113: AND FS.ENABLED_FLAG = l_enabled_flag
1114: AND FS.id_flex_num = l_id_flex_num;

Line 1118: from FND_ID_FLEX_SEGMENTS FS

1114: AND FS.id_flex_num = l_id_flex_num;
1115:
1116: BEGIN
1117: select FS.segment_num into G_CHECK_SEG_NUM
1118: from FND_ID_FLEX_SEGMENTS FS
1119: where FS.APPLICATION_ID = l_application_id
1120: and FS.id_flex_code = l_id_flex_code
1121: and FS.ENABLED_FLAG = l_enabled_flag
1122: and FS.id_flex_num = l_id_flex_num