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.GMF_COPY_ITEM_COST dependencies on CM_BRDN_DTL

Line 1174: UPDATE cm_brdn_dtl

1170: ;
1171:
1172: gmf_util.trace( SQL%ROWCOUNT || ' rows deleted from acst_led', 1 );
1173:
1174: UPDATE cm_brdn_dtl
1175: SET
1176: cmpntcost_id = NULL
1177: WHERE
1178: cmpntcost_id = l_updins_cc_id

Line 1500: * cmpntcost_id to null in cm_brdn_dtl for the cost parameters passed

1496: * delete_item_costs
1497: *
1498: * DESCRIPTION
1499: * Deletes the child rows from cm_scst_led, cm_acst_led and sets
1500: * cmpntcost_id to null in cm_brdn_dtl for the cost parameters passed
1501: * NOTE: We do not have to worry about rollover_ind here since this procedure
1502: * is not even called if the item is frozen in the target period.
1503: *
1504: * INPUT PARAMETERS

Line 1571: cm_brdn_dtl

1567: gmf_util.trace( SQL%ROWCOUNT || ' rows deleted from scst_led', 3 );
1568:
1569: -- Update brdn_dtl
1570: UPDATE
1571: cm_brdn_dtl
1572: SET
1573: cmpntcost_id = NULL
1574: WHERE
1575: cmpntcost_id = r_cc_id.cmpntcost_id

Line 1958: inventory_item_id cm_brdn_dtl.inventory_item_id%TYPE,

1954:
1955: IS
1956:
1957: TYPE rectype_brdn_dtl IS RECORD(
1958: inventory_item_id cm_brdn_dtl.inventory_item_id%TYPE,
1959: -- item_no mtl_system_items_b_kfv.concatenated_segments%TYPE,
1960: resources cm_brdn_dtl.resources%TYPE,
1961: cost_cmpntcls_id cm_brdn_dtl.cost_cmpntcls_id%TYPE,
1962: cost_analysis_code cm_brdn_dtl.cost_analysis_code%TYPE,

Line 1960: resources cm_brdn_dtl.resources%TYPE,

1956:
1957: TYPE rectype_brdn_dtl IS RECORD(
1958: inventory_item_id cm_brdn_dtl.inventory_item_id%TYPE,
1959: -- item_no mtl_system_items_b_kfv.concatenated_segments%TYPE,
1960: resources cm_brdn_dtl.resources%TYPE,
1961: cost_cmpntcls_id cm_brdn_dtl.cost_cmpntcls_id%TYPE,
1962: cost_analysis_code cm_brdn_dtl.cost_analysis_code%TYPE,
1963: burden_qty cm_brdn_dtl.burden_qty%TYPE,
1964: burden_usage cm_brdn_dtl.burden_usage%TYPE,

Line 1961: cost_cmpntcls_id cm_brdn_dtl.cost_cmpntcls_id%TYPE,

1957: TYPE rectype_brdn_dtl IS RECORD(
1958: inventory_item_id cm_brdn_dtl.inventory_item_id%TYPE,
1959: -- item_no mtl_system_items_b_kfv.concatenated_segments%TYPE,
1960: resources cm_brdn_dtl.resources%TYPE,
1961: cost_cmpntcls_id cm_brdn_dtl.cost_cmpntcls_id%TYPE,
1962: cost_analysis_code cm_brdn_dtl.cost_analysis_code%TYPE,
1963: burden_qty cm_brdn_dtl.burden_qty%TYPE,
1964: burden_usage cm_brdn_dtl.burden_usage%TYPE,
1965: burden_um cm_brdn_dtl.burden_um%TYPE,

Line 1962: cost_analysis_code cm_brdn_dtl.cost_analysis_code%TYPE,

1958: inventory_item_id cm_brdn_dtl.inventory_item_id%TYPE,
1959: -- item_no mtl_system_items_b_kfv.concatenated_segments%TYPE,
1960: resources cm_brdn_dtl.resources%TYPE,
1961: cost_cmpntcls_id cm_brdn_dtl.cost_cmpntcls_id%TYPE,
1962: cost_analysis_code cm_brdn_dtl.cost_analysis_code%TYPE,
1963: burden_qty cm_brdn_dtl.burden_qty%TYPE,
1964: burden_usage cm_brdn_dtl.burden_usage%TYPE,
1965: burden_um cm_brdn_dtl.burden_um%TYPE,
1966: item_qty cm_brdn_dtl.item_qty%TYPE,

Line 1963: burden_qty cm_brdn_dtl.burden_qty%TYPE,

1959: -- item_no mtl_system_items_b_kfv.concatenated_segments%TYPE,
1960: resources cm_brdn_dtl.resources%TYPE,
1961: cost_cmpntcls_id cm_brdn_dtl.cost_cmpntcls_id%TYPE,
1962: cost_analysis_code cm_brdn_dtl.cost_analysis_code%TYPE,
1963: burden_qty cm_brdn_dtl.burden_qty%TYPE,
1964: burden_usage cm_brdn_dtl.burden_usage%TYPE,
1965: burden_um cm_brdn_dtl.burden_um%TYPE,
1966: item_qty cm_brdn_dtl.item_qty%TYPE,
1967: item_um cm_brdn_dtl.item_um%TYPE,

Line 1964: burden_usage cm_brdn_dtl.burden_usage%TYPE,

1960: resources cm_brdn_dtl.resources%TYPE,
1961: cost_cmpntcls_id cm_brdn_dtl.cost_cmpntcls_id%TYPE,
1962: cost_analysis_code cm_brdn_dtl.cost_analysis_code%TYPE,
1963: burden_qty cm_brdn_dtl.burden_qty%TYPE,
1964: burden_usage cm_brdn_dtl.burden_usage%TYPE,
1965: burden_um cm_brdn_dtl.burden_um%TYPE,
1966: item_qty cm_brdn_dtl.item_qty%TYPE,
1967: item_um cm_brdn_dtl.item_um%TYPE,
1968: burden_factor cm_brdn_dtl.burden_factor%TYPE

Line 1965: burden_um cm_brdn_dtl.burden_um%TYPE,

1961: cost_cmpntcls_id cm_brdn_dtl.cost_cmpntcls_id%TYPE,
1962: cost_analysis_code cm_brdn_dtl.cost_analysis_code%TYPE,
1963: burden_qty cm_brdn_dtl.burden_qty%TYPE,
1964: burden_usage cm_brdn_dtl.burden_usage%TYPE,
1965: burden_um cm_brdn_dtl.burden_um%TYPE,
1966: item_qty cm_brdn_dtl.item_qty%TYPE,
1967: item_um cm_brdn_dtl.item_um%TYPE,
1968: burden_factor cm_brdn_dtl.burden_factor%TYPE
1969: );

Line 1966: item_qty cm_brdn_dtl.item_qty%TYPE,

1962: cost_analysis_code cm_brdn_dtl.cost_analysis_code%TYPE,
1963: burden_qty cm_brdn_dtl.burden_qty%TYPE,
1964: burden_usage cm_brdn_dtl.burden_usage%TYPE,
1965: burden_um cm_brdn_dtl.burden_um%TYPE,
1966: item_qty cm_brdn_dtl.item_qty%TYPE,
1967: item_um cm_brdn_dtl.item_um%TYPE,
1968: burden_factor cm_brdn_dtl.burden_factor%TYPE
1969: );
1970: r_brdn_dtl rectype_brdn_dtl;

Line 1967: item_um cm_brdn_dtl.item_um%TYPE,

1963: burden_qty cm_brdn_dtl.burden_qty%TYPE,
1964: burden_usage cm_brdn_dtl.burden_usage%TYPE,
1965: burden_um cm_brdn_dtl.burden_um%TYPE,
1966: item_qty cm_brdn_dtl.item_qty%TYPE,
1967: item_um cm_brdn_dtl.item_um%TYPE,
1968: burden_factor cm_brdn_dtl.burden_factor%TYPE
1969: );
1970: r_brdn_dtl rectype_brdn_dtl;
1971:

Line 1968: burden_factor cm_brdn_dtl.burden_factor%TYPE

1964: burden_usage cm_brdn_dtl.burden_usage%TYPE,
1965: burden_um cm_brdn_dtl.burden_um%TYPE,
1966: item_qty cm_brdn_dtl.item_qty%TYPE,
1967: item_um cm_brdn_dtl.item_um%TYPE,
1968: burden_factor cm_brdn_dtl.burden_factor%TYPE
1969: );
1970: r_brdn_dtl rectype_brdn_dtl;
1971:
1972: TYPE curtyp_brdn_dtl IS REF CURSOR;

Line 2062: ' cm_brdn_dtl bur ' ||

2058: ' bur.item_qty, ' ||
2059: ' bur.item_uom, ' ||
2060: ' bur.burden_factor ' ||
2061: ' FROM ' ||
2062: ' cm_brdn_dtl bur ' ||
2063: ' WHERE ' ||
2064: ' bur.organization_id = :b_organization_id AND ' ||
2065: ' bur.period_id = :b_period_id AND ' ||
2066: ' bur.cost_type_id = :b_cost_type_id AND ' ||

Line 2357: cm_brdn_dtl

2353: RAISE e_insert_row_b;
2354: END IF;
2355:
2356: UPDATE
2357: cm_brdn_dtl
2358: SET
2359: -- burdenline_id = GEM5_BURDENLINE_ID_S.NEXTVAL,
2360: burden_qty = r_brdn_dtl.burden_qty,
2361: burden_usage = r_brdn_dtl.burden_usage,

Line 2397: cm_brdn_dtl(

2393:
2394: EXCEPTION
2395: WHEN e_insert_row_b THEN
2396: INSERT INTO
2397: cm_brdn_dtl(
2398: burdenline_id,
2399: organization_id,
2400: inventory_item_id,
2401: resources,

Line 2515: ' cm_brdn_dtl bur ' ||

2511: l_sub_qry_b := '';
2512:
2513: l_del_stmt_b :=
2514: ' DELETE FROM ' ||
2515: ' cm_brdn_dtl bur ' ||
2516: ' WHERE ' ||
2517: ' bur.organization_id = :b_organization_id AND ' ||
2518: ' bur.period_id = :b_period_id AND ' ||
2519: ' bur.cost_type_id = :b_cost_type_id AND ' ||