APPS.GML_PO_GLDIST dependencies on PO_COST_DTL

Line 19: # calculate amount_trans using indicators in gl_event_plc and po_cost_dtl

15: # 1 = success
16: # -1 = failure
17: #
18: # DESCRIPTION
19: # calculate amount_trans using indicators in gl_event_plc and po_cost_dtl
20: # before inserting into po_dist_dtl table
21: # HISTORY
22: # 2/17/99 T.Ricci increment var GML_PO_GLDIST.P_tot_amount_aap_aqui
23: # when calculating an AAP account (was only doing it for AAC)

Line 54: CURSOR Cur_po_cost_dtl IS

50: FROM po_cost_mst
51: WHERE aqui_cost_id = GML_PO_GLDIST.P_aqui_cost_id;
52:
53: /* Cursor for getting the cost_amount and incl_ind for a particular po_id, line_id and doc_type.*/
54: CURSOR Cur_po_cost_dtl IS
55: SELECT incl_ind,cost_amount
56: FROM po_cost_dtl
57: WHERE doc_type = GML_PO_GLDIST.P_doc_type and
58: pos_id = GML_PO_GLDIST.P_pos_id and

Line 56: FROM po_cost_dtl

52:
53: /* Cursor for getting the cost_amount and incl_ind for a particular po_id, line_id and doc_type.*/
54: CURSOR Cur_po_cost_dtl IS
55: SELECT incl_ind,cost_amount
56: FROM po_cost_dtl
57: WHERE doc_type = GML_PO_GLDIST.P_doc_type and
58: pos_id = GML_PO_GLDIST.P_pos_id and
59: line_id = GML_PO_GLDIST.P_line_id and
60: aqui_cost_id = GML_PO_GLDIST.P_aqui_cost_id;

Line 92: OPEN Cur_po_cost_dtl;

88: OPEN Cur_po_cost_mst ;
89: FETCH Cur_po_cost_mst INTO GML_PO_GLDIST.P_cost_cmpntcls_id, GML_PO_GLDIST.P_cost_analysis_code ;
90: CLOSE Cur_po_cost_mst;
91:
92: OPEN Cur_po_cost_dtl;
93: FETCH Cur_po_cost_dtl INTO X_incl_ind, X_cost_amount;
94: CLOSE Cur_po_cost_dtl;
95:
96: IF X_incl_ind = 1 THEN

Line 93: FETCH Cur_po_cost_dtl INTO X_incl_ind, X_cost_amount;

89: FETCH Cur_po_cost_mst INTO GML_PO_GLDIST.P_cost_cmpntcls_id, GML_PO_GLDIST.P_cost_analysis_code ;
90: CLOSE Cur_po_cost_mst;
91:
92: OPEN Cur_po_cost_dtl;
93: FETCH Cur_po_cost_dtl INTO X_incl_ind, X_cost_amount;
94: CLOSE Cur_po_cost_dtl;
95:
96: IF X_incl_ind = 1 THEN
97: X_retvar := gmf_cmcommon.cmcommon_get_cost ( GML_PO_GLDIST.P_gl_item_id, GML_PO_GLDIST.P_to_whse,

Line 94: CLOSE Cur_po_cost_dtl;

90: CLOSE Cur_po_cost_mst;
91:
92: OPEN Cur_po_cost_dtl;
93: FETCH Cur_po_cost_dtl INTO X_incl_ind, X_cost_amount;
94: CLOSE Cur_po_cost_dtl;
95:
96: IF X_incl_ind = 1 THEN
97: X_retvar := gmf_cmcommon.cmcommon_get_cost ( GML_PO_GLDIST.P_gl_item_id, GML_PO_GLDIST.P_to_whse,
98: X_orgn_code , GML_PO_GLDIST.P_po_date,

Line 229: # calculate amount_trans using indicators in gl_event_plc and po_cost_dtl

225: # 1 = success
226: # -1 = failure
227: #
228: # DESCRIPTION
229: # calculate amount_trans using indicators in gl_event_plc and po_cost_dtl
230: # before inserting into po_dist_dtl table
231: #
232: ##########################################################################*/
233:

Line 465: FROM po_cost_dtl

461: /*Sandeep. Modified the Cursor for doc_type 'PORD' and 'RECV". */
462: /*Initially, it was hard-coded to 'PORD'.*/
463: CURSOR Cur_get_aqui_costs IS
464: SELECT aqui_cost_id , cost_amount , incl_ind
465: FROM po_cost_dtl
466: WHERE doc_type = P_doc_type and pos_id = P_pos_id and
467: line_id = P_line_id;
468: CURSOR Cur_fiscal_year IS
469: SELECT fiscal_year,period

Line 1456: FROM po_cost_dtl

1452: WHERE aqui_cost_id = GML_PO_GLDIST.P_aqui_cost_id;
1453:
1454: CURSOR Cur_get_aqui_costs IS
1455: SELECT aqui_cost_id , cost_amount , incl_ind, delete_mark
1456: FROM po_cost_dtl
1457: WHERE doc_type = GML_PO_GLDIST.P_doc_type and
1458: pos_id = GML_PO_GLDIST.P_pos_id and
1459: line_id = GML_PO_GLDIST.P_line_id;
1460: