DBA Data[Home] [Help]

APPS.CST_MGD_INFL_ADJUSTMENT_PVT dependencies on CST_COST_GROUPS

Line 326: , p_cost_group_id IN CST_COST_GROUPS.cost_group_id%TYPE

322: , p_organization_id IN NUMBER
323: , p_inventory_item_id IN NUMBER
324: , p_acct_period_id IN NUMBER
325: , p_prev_acct_period_id IN NUMBER
326: , p_cost_group_id IN CST_COST_GROUPS.cost_group_id%TYPE
327: , x_previous_qty OUT NOCOPY NUMBER
328: , x_previous_cost OUT NOCOPY NUMBER
329: , x_previous_inflation_adj OUT NOCOPY NUMBER
330: )

Line 502: , p_cost_group_id IN CST_COST_GROUPS.cost_group_id%TYPE

498: PROCEDURE Get_Purchase_Qty
499: ( p_org_id IN NUMBER
500: , p_inventory_item_id IN NUMBER
501: , p_acct_period_id IN NUMBER
502: , p_cost_group_id IN CST_COST_GROUPS.cost_group_id%TYPE
503: , x_purchase_qty OUT NOCOPY NUMBER
504: )
505: IS
506: l_routine CONSTANT VARCHAR2(30) := 'get_purchase_qty';

Line 581: , p_cost_group_id IN CST_COST_GROUPS.cost_group_id%TYPE

577: PROCEDURE Get_Issue_Qty
578: ( p_org_id IN NUMBER
579: , p_inventory_item_id IN NUMBER
580: , p_acct_period_id IN NUMBER
581: , p_cost_group_id IN CST_COST_GROUPS.cost_group_id%TYPE
582: , x_issue_qty OUT NOCOPY NUMBER
583: )
584: IS
585: BEGIN

Line 873: , p_cost_group_id IN CST_COST_GROUPS.cost_group_id%TYPE

869: ( p_inflation_adjustment_rec IN
870: CST_MGD_INFL_ADJUSTMENT_PUB.Inflation_Adjustment_Rec_Type
871: , p_inflation_index_value IN NUMBER
872: , p_prev_acct_period_id IN NUMBER
873: , p_cost_group_id IN CST_COST_GROUPS.cost_group_id%TYPE
874: , x_inflation_adjustment_rec OUT NOCOPY
875: CST_MGD_INFL_ADJUSTMENT_PUB.Inflation_Adjustment_Rec_Type
876: , x_tnsf_out_entry_tbl_rec OUT NOCOPY Transfer_Tbl_Rec_Type
877: , x_tnsf_in_entry_tbl_rec OUT NOCOPY Transfer_Tbl_Rec_Type

Line 908: l_transfer_in_cg_id CST_COST_GROUPS.cost_group_id%TYPE;

904: l_tnsf_curr_per_start_date DATE;
905: l_tnsf_curr_per_end_date DATE;
906: l_transfer_org_code VARCHAR2(3);
907: l_err_transfer_org_id NUMBER;
908: l_transfer_in_cg_id CST_COST_GROUPS.cost_group_id%TYPE;
909:
910: l_tnsf_period_gap_exc EXCEPTION;
911:
912: -- ===============================================================

Line 1690: , p_cost_group_id IN CST_COST_GROUPS.cost_group_id%TYPE

1686: , p_inflation_index_value IN NUMBER
1687: , p_prev_acct_period_id IN NUMBER
1688: , p_inflation_adjustment_rec IN
1689: CST_MGD_INFL_ADJUSTMENT_PUB.Inflation_Adjustment_Rec_Type
1690: , p_cost_group_id IN CST_COST_GROUPS.cost_group_id%TYPE
1691: )
1692: IS
1693: l_routine CONSTANT VARCHAR2(30) := 'create_inflation_adjusted_cost';
1694:

Line 2846: , p_cost_group_id IN CST_COST_GROUPS.cost_group_id%TYPE

2842: PROCEDURE Get_Period_End_Avg_Cost
2843: ( p_acct_period_id IN NUMBER
2844: , p_org_id IN NUMBER
2845: , p_inv_item_id IN NUMBER
2846: , p_cost_group_id IN CST_COST_GROUPS.cost_group_id%TYPE
2847: , x_period_end_item_avg_cost OUT NOCOPY NUMBER
2848: )
2849: IS
2850: l_routine CONSTANT VARCHAR2(30) := 'get_period_end_avg_cost';

Line 2856: ,c_cost_group_id CST_COST_GROUPS.cost_group_id%TYPE

2852: -- cursor to retrieve period end unit cost from view
2853: CURSOR period_end_unit_cost_cursor(c_org_id NUMBER
2854: ,c_acct_period_id NUMBER
2855: ,c_inv_item_id NUMBER
2856: ,c_cost_group_id CST_COST_GROUPS.cost_group_id%TYPE
2857: )
2858: IS
2859: SELECT
2860: SUM(Period_End_Unit_Cost)