APPS.GMI_PIR05_XMLP_PKG dependencies on IC_PHYS_CNT

Line 35: IC_PHYS_CNT

31: CURSOR CURSOR_00011(CYCLE_ID_1 number) IS
32: SELECT
33: count(*)
34: FROM
35: IC_PHYS_CNT
36: WHERE IC_PHYS_CNT.WHSE_CODE = WHSE
37: AND IC_PHYS_CNT.CYCLE_ID = CYCLE_ID_1
38: AND IC_PHYS_CNT.COUNT_NO >= FROM_COUNT
39: AND IC_PHYS_CNT.COUNT_NO <= TO_COUNT

Line 36: WHERE IC_PHYS_CNT.WHSE_CODE = WHSE

32: SELECT
33: count(*)
34: FROM
35: IC_PHYS_CNT
36: WHERE IC_PHYS_CNT.WHSE_CODE = WHSE
37: AND IC_PHYS_CNT.CYCLE_ID = CYCLE_ID_1
38: AND IC_PHYS_CNT.COUNT_NO >= FROM_COUNT
39: AND IC_PHYS_CNT.COUNT_NO <= TO_COUNT
40: AND IC_PHYS_CNT.CREATION_DATE <> IC_PHYS_CNT.LAST_UPDATE_DATE;

Line 37: AND IC_PHYS_CNT.CYCLE_ID = CYCLE_ID_1

33: count(*)
34: FROM
35: IC_PHYS_CNT
36: WHERE IC_PHYS_CNT.WHSE_CODE = WHSE
37: AND IC_PHYS_CNT.CYCLE_ID = CYCLE_ID_1
38: AND IC_PHYS_CNT.COUNT_NO >= FROM_COUNT
39: AND IC_PHYS_CNT.COUNT_NO <= TO_COUNT
40: AND IC_PHYS_CNT.CREATION_DATE <> IC_PHYS_CNT.LAST_UPDATE_DATE;
41: X_MIN_COUNT NUMBER := 0;

Line 38: AND IC_PHYS_CNT.COUNT_NO >= FROM_COUNT

34: FROM
35: IC_PHYS_CNT
36: WHERE IC_PHYS_CNT.WHSE_CODE = WHSE
37: AND IC_PHYS_CNT.CYCLE_ID = CYCLE_ID_1
38: AND IC_PHYS_CNT.COUNT_NO >= FROM_COUNT
39: AND IC_PHYS_CNT.COUNT_NO <= TO_COUNT
40: AND IC_PHYS_CNT.CREATION_DATE <> IC_PHYS_CNT.LAST_UPDATE_DATE;
41: X_MIN_COUNT NUMBER := 0;
42: COUNT NUMBER;

Line 39: AND IC_PHYS_CNT.COUNT_NO <= TO_COUNT

35: IC_PHYS_CNT
36: WHERE IC_PHYS_CNT.WHSE_CODE = WHSE
37: AND IC_PHYS_CNT.CYCLE_ID = CYCLE_ID_1
38: AND IC_PHYS_CNT.COUNT_NO >= FROM_COUNT
39: AND IC_PHYS_CNT.COUNT_NO <= TO_COUNT
40: AND IC_PHYS_CNT.CREATION_DATE <> IC_PHYS_CNT.LAST_UPDATE_DATE;
41: X_MIN_COUNT NUMBER := 0;
42: COUNT NUMBER;
43: COUNT1 NUMBER;

Line 40: AND IC_PHYS_CNT.CREATION_DATE <> IC_PHYS_CNT.LAST_UPDATE_DATE;

36: WHERE IC_PHYS_CNT.WHSE_CODE = WHSE
37: AND IC_PHYS_CNT.CYCLE_ID = CYCLE_ID_1
38: AND IC_PHYS_CNT.COUNT_NO >= FROM_COUNT
39: AND IC_PHYS_CNT.COUNT_NO <= TO_COUNT
40: AND IC_PHYS_CNT.CREATION_DATE <> IC_PHYS_CNT.LAST_UPDATE_DATE;
41: X_MIN_COUNT NUMBER := 0;
42: COUNT NUMBER;
43: COUNT1 NUMBER;
44: COUNT2 NUMBER;

Line 115: FROM IC_PHYS_CNT

111: END;
112: BEGIN
113: SELECT count(*)
114: INTO COUNT2
115: FROM IC_PHYS_CNT
116: WHERE IC_PHYS_CNT.WHSE_CODE = WHSE
117: AND IC_PHYS_CNT.CYCLE_ID = CYCLE_ID_1
118: AND IC_PHYS_CNT.COUNT_NO >= FROM_COUNT
119: AND IC_PHYS_CNT.COUNT_NO <= TO_COUNT

Line 116: WHERE IC_PHYS_CNT.WHSE_CODE = WHSE

112: BEGIN
113: SELECT count(*)
114: INTO COUNT2
115: FROM IC_PHYS_CNT
116: WHERE IC_PHYS_CNT.WHSE_CODE = WHSE
117: AND IC_PHYS_CNT.CYCLE_ID = CYCLE_ID_1
118: AND IC_PHYS_CNT.COUNT_NO >= FROM_COUNT
119: AND IC_PHYS_CNT.COUNT_NO <= TO_COUNT
120: AND IC_PHYS_CNT.CREATION_DATE <> IC_PHYS_CNT.LAST_UPDATE_DATE

Line 117: AND IC_PHYS_CNT.CYCLE_ID = CYCLE_ID_1

113: SELECT count(*)
114: INTO COUNT2
115: FROM IC_PHYS_CNT
116: WHERE IC_PHYS_CNT.WHSE_CODE = WHSE
117: AND IC_PHYS_CNT.CYCLE_ID = CYCLE_ID_1
118: AND IC_PHYS_CNT.COUNT_NO >= FROM_COUNT
119: AND IC_PHYS_CNT.COUNT_NO <= TO_COUNT
120: AND IC_PHYS_CNT.CREATION_DATE <> IC_PHYS_CNT.LAST_UPDATE_DATE
121: AND rownum=1;

Line 118: AND IC_PHYS_CNT.COUNT_NO >= FROM_COUNT

114: INTO COUNT2
115: FROM IC_PHYS_CNT
116: WHERE IC_PHYS_CNT.WHSE_CODE = WHSE
117: AND IC_PHYS_CNT.CYCLE_ID = CYCLE_ID_1
118: AND IC_PHYS_CNT.COUNT_NO >= FROM_COUNT
119: AND IC_PHYS_CNT.COUNT_NO <= TO_COUNT
120: AND IC_PHYS_CNT.CREATION_DATE <> IC_PHYS_CNT.LAST_UPDATE_DATE
121: AND rownum=1;
122: /* OPEN CURSOR_00011(CYCLE_ID_1);

Line 119: AND IC_PHYS_CNT.COUNT_NO <= TO_COUNT

115: FROM IC_PHYS_CNT
116: WHERE IC_PHYS_CNT.WHSE_CODE = WHSE
117: AND IC_PHYS_CNT.CYCLE_ID = CYCLE_ID_1
118: AND IC_PHYS_CNT.COUNT_NO >= FROM_COUNT
119: AND IC_PHYS_CNT.COUNT_NO <= TO_COUNT
120: AND IC_PHYS_CNT.CREATION_DATE <> IC_PHYS_CNT.LAST_UPDATE_DATE
121: AND rownum=1;
122: /* OPEN CURSOR_00011(CYCLE_ID_1);
123: FETCH CURSOR_00011

Line 120: AND IC_PHYS_CNT.CREATION_DATE <> IC_PHYS_CNT.LAST_UPDATE_DATE

116: WHERE IC_PHYS_CNT.WHSE_CODE = WHSE
117: AND IC_PHYS_CNT.CYCLE_ID = CYCLE_ID_1
118: AND IC_PHYS_CNT.COUNT_NO >= FROM_COUNT
119: AND IC_PHYS_CNT.COUNT_NO <= TO_COUNT
120: AND IC_PHYS_CNT.CREATION_DATE <> IC_PHYS_CNT.LAST_UPDATE_DATE
121: AND rownum=1;
122: /* OPEN CURSOR_00011(CYCLE_ID_1);
123: FETCH CURSOR_00011
124: INTO COUNT2;