APPS.GML_PO_SYNCH dependencies on PO_COST_DTL

Line 981: FROM po_cost_dtl

977: RETURN BOOLEAN
978: IS
979: CURSOR cost_line_cur IS
980: SELECT cost_amount
981: FROM po_cost_dtl
982: WHERE doc_type = v_type
983: AND pos_id = v_pos_id
984: AND line_id = v_line_id
985: AND aqui_cost_id = v_cost_id

Line 1049: FROM po_cost_dtl a

1045: AND line_location_id = v_line_location_id;
1046:
1047: CURSOR gemms_acq_cur IS
1048: SELECT aqui_cost_id, cost_amount
1049: FROM po_cost_dtl a
1050: WHERE pos_id = v_po_id
1051: AND line_id = v_line_id
1052: AND NOT EXISTS (SELECT 'Y'
1053: FROM cpg_cost_dtl b

Line 1079: INSERT INTO po_cost_dtl

1075: (v_doc_type,v_po_id, v_line_id, aqcst_rec.aqui_cost_id);
1076: /* T. Ricci 5/12/98 GEMMS 5.0 changes for who columns*/
1077:
1078: IF v_new_aqcst_line THEN
1079: INSERT INTO po_cost_dtl
1080: (
1081: doc_type,
1082: pos_id,
1083: line_id,

Line 1115: UPDATE po_cost_dtl

1111: );
1112:
1113: ELSE
1114:
1115: UPDATE po_cost_dtl
1116: SET cost_amount = aqcst_rec.cost_amount,
1117: incl_ind = aqcst_rec.incl_ind,
1118: last_update_date = aqcst_rec.last_update_date
1119: WHERE doc_type = v_doc_type

Line 1134: UPDATE po_cost_dtl

1130: OPEN gemms_acq_cur;
1131: LOOP
1132: FETCH gemms_acq_cur INTO p_aqui_cost_id, p_cost_amount;
1133: EXIT WHEN gemms_acq_cur%NOTFOUND;
1134: UPDATE po_cost_dtl
1135: SET delete_mark = 1
1136: WHERE pos_id = v_po_id
1137: AND line_id = v_line_id
1138: AND aqui_cost_id = p_aqui_cost_id