APPS.GMF_ACTUAL_COST_ADJUSTMENT_PUB dependencies on CM_ADJS_DTL

Line 128: l_cost_adjust_id cm_adjs_dtl.cost_adjust_id%TYPE;

124: ******************/
125: l_reason_cnt NUMBER;
126: l_text_cnt NUMBER;
127: l_header_cnt NUMBER;
128: l_cost_adjust_id cm_adjs_dtl.cost_adjust_id%TYPE;
129: l_adjust_cost cm_adjs_dtl.adjust_cost%TYPE;
130: l_adjust_status cm_adjs_dtl.adjust_status%TYPE;
131: l_start_date DATE;
132: l_end_date DATE;

Line 129: l_adjust_cost cm_adjs_dtl.adjust_cost%TYPE;

125: l_reason_cnt NUMBER;
126: l_text_cnt NUMBER;
127: l_header_cnt NUMBER;
128: l_cost_adjust_id cm_adjs_dtl.cost_adjust_id%TYPE;
129: l_adjust_cost cm_adjs_dtl.adjust_cost%TYPE;
130: l_adjust_status cm_adjs_dtl.adjust_status%TYPE;
131: l_start_date DATE;
132: l_end_date DATE;
133: BEGIN

Line 130: l_adjust_status cm_adjs_dtl.adjust_status%TYPE;

126: l_text_cnt NUMBER;
127: l_header_cnt NUMBER;
128: l_cost_adjust_id cm_adjs_dtl.cost_adjust_id%TYPE;
129: l_adjust_cost cm_adjs_dtl.adjust_cost%TYPE;
130: l_adjust_status cm_adjs_dtl.adjust_status%TYPE;
131: l_start_date DATE;
132: l_end_date DATE;
133: BEGIN
134:

Line 165: FROM cm_adjs_dtl

161: p_adjustment_rec.period_id,
162: p_adjustment_rec.cost_Type_id,
163: p_adjustment_rec.organization_id,
164: p_adjustment_rec.inventory_item_id
165: FROM cm_adjs_dtl
166: WHERE cost_adjust_id = p_adjustment_rec.cost_adjust_id
167: AND ROWNUM = 1;
168: EXCEPTION
169: WHEN NO_DATA_FOUND THEN

Line 710: FROM cm_adjs_dtl

706: END IF;
707: BEGIN
708: SELECT cost_adjust_id, adjust_status
709: INTO p_adjustment_rec.cost_adjust_id, l_adjust_status
710: FROM cm_adjs_dtl
711: WHERE organization_id = p_adjustment_rec.organization_id
712: AND cost_type_id = p_adjustment_rec.cost_type_id
713: AND inventory_item_id = p_adjustment_rec.inventory_item_id
714: AND period_id = p_adjustment_rec.period_id

Line 998: l_cost_adjust_id CM_ADJS_DTL.COST_ADJUST_ID%TYPE;

994: * Local Variables *
995: ******************/
996: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ACTUAL_COST_ADJUSTMENT';
997: l_api_version CONSTANT NUMBER := 1.0 ;
998: l_cost_adjust_id CM_ADJS_DTL.COST_ADJUST_ID%TYPE;
999: l_header_exists BOOLEAN;
1000: l_detail_exists BOOLEAN;
1001: user_cnt NUMBER;
1002: l_user_id FND_USER.USER_ID%TYPE ;

Line 1201: l_cost_adjust_id CM_ADJS_DTL.COST_ADJUST_ID%TYPE;

1197: * Local Variables *
1198: ******************/
1199: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_ACTUAL_COST_ADJUSTMENT';
1200: l_api_version CONSTANT NUMBER := 1.0 ;
1201: l_cost_adjust_id CM_ADJS_DTL.COST_ADJUST_ID%TYPE;
1202: l_header_exists BOOLEAN;
1203: l_detail_exists BOOLEAN;
1204: user_cnt NUMBER;
1205: l_user_id FND_USER.USER_ID%TYPE ;

Line 1403: l_cost_adjust_id CM_ADJS_DTL.COST_ADJUST_ID%TYPE;

1399: * Local Variables *
1400: ******************/
1401: l_api_name CONSTANT VARCHAR2(30) := 'GET_ACTUAL_COST_ADJUSTMENT';
1402: l_api_version CONSTANT NUMBER := 1.0 ;
1403: l_cost_adjust_id CM_ADJS_DTL.COST_ADJUST_ID%TYPE;
1404: l_header_exists BOOLEAN;
1405: l_detail_exists BOOLEAN;
1406: user_cnt NUMBER;
1407: l_user_id FND_USER.USER_ID%TYPE ;