APPS.PJI_SETUP_PKG dependencies on PJI_MT_BUCKETS

Line 511: UPDATE pji_mt_buckets

507: l_creation_date := SYSDATE;
508: l_last_update_date := SYSDATE;
509: l_last_update_login := Fnd_Profile.value('USER_ID');
510:
511: UPDATE pji_mt_buckets
512: SET name = p_name,
513: last_update_date = l_last_update_date,
514: seq = p_seq,
515: bucket_set_code = p_bucket_set_code,

Line 592: UPDATE pji_mt_buckets

588: l_creation_date := SYSDATE;
589: l_last_update_date := SYSDATE;
590: l_last_update_login := Fnd_Profile.value('USER_ID');
591:
592: UPDATE pji_mt_buckets
593: SET name = p_name,
594: last_update_date = l_last_update_date,
595: seq = p_seq,
596: bucket_set_code = p_bucket_set_code,

Line 674: UPDATE pji_mt_buckets

670: l_creation_date := SYSDATE;
671: l_last_update_date := SYSDATE;
672: l_last_update_login := Fnd_Profile.value('USER_ID');
673:
674: UPDATE pji_mt_buckets
675: SET name = p_name,
676: last_update_date = l_last_update_date,
677: seq = p_seq,
678: bucket_set_code = p_bucket_set_code,

Line 749: UPDATE pji_mt_buckets

745: l_creation_date := SYSDATE;
746: l_last_update_date := SYSDATE;
747: l_last_update_login := Fnd_Profile.value('USER_ID');
748:
749: UPDATE pji_mt_buckets
750: SET name = p_name,
751: last_update_date = l_last_update_date,
752: seq = p_seq,
753: bucket_set_code = p_bucket_set_code,

Line 787: FROM pji_mt_buckets a,

783: CURSOR C1 (c_bucket_set_code IN VARCHAR2) IS
784: SELECT 1 FROM DUAL
785: WHERE EXISTS (
786: SELECT 'X'
787: FROM pji_mt_buckets a,
788: pji_mt_buckets b
789: WHERE a.bucket_set_code = b.bucket_set_code
790: AND a.bucket_set_code = c_bucket_set_code
791: AND a.from_value <= b.to_value

Line 788: pji_mt_buckets b

784: SELECT 1 FROM DUAL
785: WHERE EXISTS (
786: SELECT 'X'
787: FROM pji_mt_buckets a,
788: pji_mt_buckets b
789: WHERE a.bucket_set_code = b.bucket_set_code
790: AND a.bucket_set_code = c_bucket_set_code
791: AND a.from_value <= b.to_value
792: AND b.from_value < b.to_value

Line 799: FROM pji_mt_buckets a,

795: CURSOR C2 (c_bucket_set_code IN VARCHAR2) IS
796: SELECT 2 FROM DUAL
797: WHERE EXISTS (
798: SELECT 'X'
799: FROM pji_mt_buckets a,
800: pji_mt_buckets b
801: WHERE a.bucket_set_code = b.bucket_set_code
802: AND a.bucket_set_code = c_bucket_set_code
803: AND (b.from_value - a.to_value) > 1

Line 800: pji_mt_buckets b

796: SELECT 2 FROM DUAL
797: WHERE EXISTS (
798: SELECT 'X'
799: FROM pji_mt_buckets a,
800: pji_mt_buckets b
801: WHERE a.bucket_set_code = b.bucket_set_code
802: AND a.bucket_set_code = c_bucket_set_code
803: AND (b.from_value - a.to_value) > 1
804: AND NVL(b.to_value, 99999999999999999999999) > b.from_value

Line 807: FROM pji_mt_buckets c

803: AND (b.from_value - a.to_value) > 1
804: AND NVL(b.to_value, 99999999999999999999999) > b.from_value
805: AND a.to_value > a.from_value
806: AND NOT EXISTS ( SELECT 'X'
807: FROM pji_mt_buckets c
808: WHERE c.from_value > a.to_value
809: AND c.to_value < b.from_value ));
810:
811: CURSOR C3 IS

Line 814: FROM pji_mt_buckets a,

810:
811: CURSOR C3 IS
812: SELECT 3 FROM DUAL
813: WHERE EXISTS (SELECT 'X'
814: FROM pji_mt_buckets a,
815: pji_mt_buckets b
816: WHERE a.bucket_set_code = b.bucket_set_code
817: AND a.bucket_set_code = 'PJI_RESOURCE_AVAILABILITY'
818: AND a.seq > b.seq

Line 815: pji_mt_buckets b

811: CURSOR C3 IS
812: SELECT 3 FROM DUAL
813: WHERE EXISTS (SELECT 'X'
814: FROM pji_mt_buckets a,
815: pji_mt_buckets b
816: WHERE a.bucket_set_code = b.bucket_set_code
817: AND a.bucket_set_code = 'PJI_RESOURCE_AVAILABILITY'
818: AND a.seq > b.seq
819: AND b.to_value > a.to_value) ;

Line 862: FROM pji_mt_buckets a

858: x_return_status := 'S' ;
859:
860: SELECT MIN(a.from_value), MAX(a.to_value)
861: INTO l_check_min_probability, l_check_max_probability
862: FROM pji_mt_buckets a
863: WHERE a.bucket_set_code = 'PJI_PIPELINE_PROBABILITY' ;
864:
865: IF l_check_min_probability > 0 OR l_check_max_probability < 100 THEN
866:

Line 943: FROM pji_mt_buckets a

939: x_return_status := 'S' ;
940:
941: SELECT MIN(a.from_value), MIN(NVL(a.to_value,1000))
942: INTO l_check_min_probability, l_check_max_probability
943: FROM pji_mt_buckets a
944: WHERE a.bucket_set_code = 'PJI_RES_AVL_DAYS' ;
945:
946: IF l_check_min_probability <> 1 OR l_check_max_probability < 2 THEN
947: