eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZPB_AC_OPS dependencies on ZPB_SOLVE_HIER_ORDER

Line 887: INSERT INTO zpb_solve_hier_order

883: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
884: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
885: IS
886: BEGIN
887: INSERT INTO zpb_solve_hier_order
888: (solve_hier_order_id,
889: analysis_cycle_id,
890: dimension,
891: hierarchy,

Line 901: SELECT zpb_solve_hier_order_s.NEXTVAL,

897: last_updated_by,
898: last_update_date,
899: last_update_login
900: )
901: SELECT zpb_solve_hier_order_s.NEXTVAL,
902: target_ac_id_in,
903: dimension,
904: hierarchy,
905: hierarchy_order,

Line 913: FROM zpb_solve_hier_order

909: fnd_global.user_id,
910: fnd_global.user_id,
911: sysdate,
912: fnd_global.login_id
913: FROM zpb_solve_hier_order
914: WHERE analysis_cycle_id = source_ac_id_in;
915:
916: END copy_solve_hier_order_recs;
917:

Line 1210: DELETE FROM zpb_solve_hier_order

1206:
1207: DELETE FROM ZPB_BP_VALIDATION_RESULTS
1208: WHERE BUS_PROC_ID = ac_id_in;
1209:
1210: DELETE FROM zpb_solve_hier_order
1211: WHERE analysis_cycle_id = ac_id_in;
1212:
1213: END delete_ac;
1214:

Line 3351: -- exists in the table: zpb_solve_hier_order

3347: HAVING COUNT(a.hierarchy) > l_hier_count )
3348: ORDER BY b.dimension, b.hierarchy;
3349:
3350: -- This cursor will return 1 if the "ac_id - dim - hier" combination already
3351: -- exists in the table: zpb_solve_hier_order
3352: CURSOR l_hierarchy_exists_csr IS
3353: SELECT 1 hier_exists
3354: FROM zpb_solve_hier_order
3355: WHERE analysis_cycle_id = p_analysis_cycle_id

Line 3354: FROM zpb_solve_hier_order

3350: -- This cursor will return 1 if the "ac_id - dim - hier" combination already
3351: -- exists in the table: zpb_solve_hier_order
3352: CURSOR l_hierarchy_exists_csr IS
3353: SELECT 1 hier_exists
3354: FROM zpb_solve_hier_order
3355: WHERE analysis_cycle_id = p_analysis_cycle_id
3356: AND dimension = l_dimension
3357: AND hierarchy = l_hierarchy;
3358:

Line 3360: -- combination in the table: zpb_solve_hier_order

3356: AND dimension = l_dimension
3357: AND hierarchy = l_hierarchy;
3358:
3359: -- This cursor will return the last used hier order for a "ac_id - Dim"
3360: -- combination in the table: zpb_solve_hier_order
3361: CURSOR l_get_last_order_csr is
3362: SELECT NVL(MAX(hierarchy_order),-1) max_order
3363: FROM zpb_solve_hier_order
3364: WHERE analysis_cycle_id = p_analysis_cycle_id

Line 3363: FROM zpb_solve_hier_order

3359: -- This cursor will return the last used hier order for a "ac_id - Dim"
3360: -- combination in the table: zpb_solve_hier_order
3361: CURSOR l_get_last_order_csr is
3362: SELECT NVL(MAX(hierarchy_order),-1) max_order
3363: FROM zpb_solve_hier_order
3364: WHERE analysis_cycle_id = p_analysis_cycle_id
3365: AND dimension = l_dimension;
3366:
3367: -- This cursor is used to cleanup the table: zpb_solve_hier_order

Line 3367: -- This cursor is used to cleanup the table: zpb_solve_hier_order

3363: FROM zpb_solve_hier_order
3364: WHERE analysis_cycle_id = p_analysis_cycle_id
3365: AND dimension = l_dimension;
3366:
3367: -- This cursor is used to cleanup the table: zpb_solve_hier_order
3368: -- by setting the first_last_flag correctly
3369: CURSOR l_final_csr IS
3370: SELECT dimension,
3371: MAX(hierarchy_order) max,

Line 3374: FROM zpb_solve_hier_order

3370: SELECT dimension,
3371: MAX(hierarchy_order) max,
3372: MIN(hierarchy_order) min,
3373: COUNT(hierarchy) count
3374: FROM zpb_solve_hier_order
3375: WHERE analysis_cycle_id = p_analysis_cycle_id
3376: GROUP BY dimension;
3377:
3378: BEGIN

Line 3407: UPDATE zpb_solve_hier_order

3403: l_first_last_flag := null;
3404:
3405: -- set the first_last_flag to null initially, this cloumn will be updated
3406: -- again at the end of this function.
3407: UPDATE zpb_solve_hier_order
3408: SET first_last_flag = l_first_last_flag
3409: WHERE analysis_cycle_id = p_analysis_cycle_id;
3410:
3411: -- set the previous dimension variable to -1 initially

Line 3432: -- insert the hierarchy in table: ZPB_SOLVE_HIER_ORDER only if it does not

3428: LOOP
3429: l_hierarchy_exists := l_hierarchy_exists_rec.hier_exists;
3430: END LOOP;
3431:
3432: -- insert the hierarchy in table: ZPB_SOLVE_HIER_ORDER only if it does not
3433: -- exist already in the table
3434: IF l_hierarchy_exists = 0
3435: THEN
3436: SELECT zpb_solve_hier_order_s.nextval INTO l_solve_hier_order_id

Line 3436: SELECT zpb_solve_hier_order_s.nextval INTO l_solve_hier_order_id

3432: -- insert the hierarchy in table: ZPB_SOLVE_HIER_ORDER only if it does not
3433: -- exist already in the table
3434: IF l_hierarchy_exists = 0
3435: THEN
3436: SELECT zpb_solve_hier_order_s.nextval INTO l_solve_hier_order_id
3437: FROM dual;
3438:
3439: IF l_new_dim <> l_prev_dim
3440: THEN

Line 3461: INSERT INTO ZPB_SOLVE_HIER_ORDER

3457: ELSE
3458: l_order_num := l_order_num + 1;
3459: END IF; -- if l_new_dim <> l_prev_dim then
3460:
3461: INSERT INTO ZPB_SOLVE_HIER_ORDER
3462: (SOLVE_HIER_ORDER_ID
3463: ,ANALYSIS_CYCLE_ID
3464: ,DIMENSION
3465: ,HIERARCHY

Line 3491: -- Sync the o/p selections table with zpb_solve_hier_order table by deleting

3487:
3488: END IF; -- if l_hierarchy_exists = 0 then
3489: END LOOP; -- for l_get_hierarchies_rec in l_get_hierarchies_csr loop
3490:
3491: -- Sync the o/p selections table with zpb_solve_hier_order table by deleting
3492: -- those hierarchies in zpb_solve_hier_order for which Hierarchy Order is
3493: -- not applicable
3494: DELETE FROM zpb_solve_hier_order
3495: WHERE analysis_cycle_id = p_analysis_cycle_id

Line 3492: -- those hierarchies in zpb_solve_hier_order for which Hierarchy Order is

3488: END IF; -- if l_hierarchy_exists = 0 then
3489: END LOOP; -- for l_get_hierarchies_rec in l_get_hierarchies_csr loop
3490:
3491: -- Sync the o/p selections table with zpb_solve_hier_order table by deleting
3492: -- those hierarchies in zpb_solve_hier_order for which Hierarchy Order is
3493: -- not applicable
3494: DELETE FROM zpb_solve_hier_order
3495: WHERE analysis_cycle_id = p_analysis_cycle_id
3496: AND hierarchy NOT IN

Line 3494: DELETE FROM zpb_solve_hier_order

3490:
3491: -- Sync the o/p selections table with zpb_solve_hier_order table by deleting
3492: -- those hierarchies in zpb_solve_hier_order for which Hierarchy Order is
3493: -- not applicable
3494: DELETE FROM zpb_solve_hier_order
3495: WHERE analysis_cycle_id = p_analysis_cycle_id
3496: AND hierarchy NOT IN
3497: (SELECT b.hierarchy
3498: FROM zpb_solve_output_selections b,

Line 3524: UPDATE zpb_solve_hier_order

3520: l_last_flag := 'L';
3521:
3522: FOR l_final_rec in l_final_csr
3523: LOOP
3524: UPDATE zpb_solve_hier_order
3525: SET first_last_flag = l_first_flag
3526: WHERE analysis_cycle_id = p_analysis_cycle_id
3527: AND dimension = l_final_rec.dimension
3528: AND hierarchy_order = l_final_rec.min;

Line 3530: UPDATE zpb_solve_hier_order

3526: WHERE analysis_cycle_id = p_analysis_cycle_id
3527: AND dimension = l_final_rec.dimension
3528: AND hierarchy_order = l_final_rec.min;
3529:
3530: UPDATE zpb_solve_hier_order
3531: SET first_last_flag = l_last_flag
3532: WHERE analysis_cycle_id = p_analysis_cycle_id
3533: AND dimension = l_final_rec.dimension
3534: AND hierarchy_order = l_final_rec.max;