DBA Data[Home] [Help]

APPS.GML_RECV_TRANS_PKG dependencies on GML_RECV_TRANS_PKG

Line 1: PACKAGE BODY GML_RECV_TRANS_PKG AS

1: PACKAGE BODY GML_RECV_TRANS_PKG AS
2: /* $Header: GMLRTRNB.pls 120.1 2005/08/15 09:23:47 rakulkar noship $ */
3:
4:
5: /*========================================================================+

Line 168: gml_recv_trans_pkg.gml_new_rcv_trans_insert(p_recv_id,

164: from rcv_headers_interface
165: where group_id = x_group_id;
166:
167: /* B2007945 v_dtl_recv_date added to call */
168: gml_recv_trans_pkg.gml_new_rcv_trans_insert(p_recv_id,
169: p_line_id,
170: p_po_id, p_poline_id,
171: p_opm_item_id, p_recv_qty1,0,
172: p_recv_um1,NULL,0,NULL,

Line 219: gml_recv_trans_pkg.gml_new_rcv_trans_insert(p_recv_id,

215: FETCH RCV_INT_GROUPS_CUR INTO new_group_id;
216: CLOSE RCV_INT_GROUPS_CUR;
217:
218: /* Header Insert */
219: gml_recv_trans_pkg.gml_new_rcv_trans_insert(p_recv_id,
220: p_line_id,
221: p_po_id, p_poline_id,
222: p_opm_item_id, p_recv_qty1,0,
223: p_recv_um1,NULL,0,NULL,

Line 230: gml_recv_trans_pkg.gml_new_rcv_trans_insert(p_recv_id,

226: v_rcv_receipt_num,1);
227: /* Transaction Insert */
228: /* B2007945 v_dtl_recv_date added to call */
229:
230: gml_recv_trans_pkg.gml_new_rcv_trans_insert(p_recv_id,
231: p_line_id,
232: p_po_id, p_poline_id,
233: p_opm_item_id, p_recv_qty1,0,
234: p_recv_um1,NULL,0,NULL,

Line 240: gml_recv_trans_pkg.gml_process_adjust_errors(retcode);

236: new_group_id,
237: v_rcv_receipt_num,0,v_dtl_recv_date);
238:
239: /* IF G_rows_inserted = 1 THEN
240: gml_recv_trans_pkg.gml_process_adjust_errors(retcode);
241: END IF; */
242:
243: EXCEPTION
244:

Line 350: gml_recv_trans_pkg.gml_insert_adjust_error(p_recv_id, p_line_id,

346:
347: IF adjust_err_ind = 1 THEN
348: IF G_adjust_mode = 'NORMAL' THEN
349:
350: gml_recv_trans_pkg.gml_insert_adjust_error(p_recv_id, p_line_id,
351: p_recv_qty1, p_old_recv_qty1,
352: p_recv_um1,p_return_ind,
353: p_recv_status,
354: p_rtrn_void_ind);

Line 389: gml_recv_trans_pkg.gml_new_rcv_trans_insert(p_recv_id,p_line_id,

385: /* We will in this case, post Two transactions,
386: 1) One As a -ve correction to return back to Receiving.
387: 2) Second to deliver that correction back to Inventory. */
388:
389: gml_recv_trans_pkg.gml_new_rcv_trans_insert(p_recv_id,p_line_id,
390: p_po_id,p_poline_id,
391: p_opm_item_id,-(v_return_quantity),0,
392: p_recv_um1,'CORRECT',v_void_ret_parent_id,
393: 'RECEIVING',0,0,NULL,0);

Line 394: gml_recv_trans_pkg.gml_new_rcv_trans_insert(p_recv_id,p_line_id,

390: p_po_id,p_poline_id,
391: p_opm_item_id,-(v_return_quantity),0,
392: p_recv_um1,'CORRECT',v_void_ret_parent_id,
393: 'RECEIVING',0,0,NULL,0);
394: gml_recv_trans_pkg.gml_new_rcv_trans_insert(p_recv_id,p_line_id,
395: p_po_id,p_poline_id,
396: p_opm_item_id,v_return_quantity,0,
397: p_recv_um1,'DELIVER',v_transaction_id,
398: 'INVENTORY',0,0,NULL,0);

Line 406: gml_recv_trans_pkg.gml_new_rcv_trans_insert(p_recv_id,p_line_id,

402: 2) Second, a -ve 'Correction' for Receiving.
403: */
404: ELSIF (p_recv_status = -1 ) THEN
405: v_recv_qty1 := - (p_recv_qty1);
406: gml_recv_trans_pkg.gml_new_rcv_trans_insert(p_recv_id,p_line_id,
407: p_po_id,p_poline_id,
408: p_opm_item_id,v_recv_qty1,0,
409: p_recv_um1,'CORRECT',v_deliver_transaction_id,
410: 'INVENTORY',0,0,NULL,0);

Line 411: gml_recv_trans_pkg.gml_new_rcv_trans_insert(p_recv_id,p_line_id,

407: p_po_id,p_poline_id,
408: p_opm_item_id,v_recv_qty1,0,
409: p_recv_um1,'CORRECT',v_deliver_transaction_id,
410: 'INVENTORY',0,0,NULL,0);
411: gml_recv_trans_pkg.gml_new_rcv_trans_insert(p_recv_id,p_line_id,
412: p_po_id,p_poline_id,
413: p_opm_item_id,v_recv_qty1,0,
414: p_recv_um1,'CORRECT',v_transaction_id,
415: 'RECEIVING',0,0,NULL,0);

Line 425: gml_recv_trans_pkg.gml_new_rcv_trans_insert(p_recv_id,p_line_id,

421: */
422:
423: ELSIF (p_return_ind = 1) THEN
424:
425: gml_recv_trans_pkg.gml_new_rcv_trans_insert(p_recv_id,p_line_id,
426: p_po_id,p_poline_id,
427: p_opm_item_id,p_recv_qty1,0,
428: p_recv_um1,'RETURN TO VENDOR',v_deliver_transaction_id,
429: 'INVENTORY',0,0,NULL,0);

Line 456: gml_recv_trans_pkg.gml_new_rcv_trans_insert(p_recv_id,p_line_id,

452: v_recv_qty1 := p_recv_qty1;
453: v_old_recv_qty1 := p_old_recv_qty1;
454: END IF;
455:
456: gml_recv_trans_pkg.gml_new_rcv_trans_insert(p_recv_id,p_line_id,
457: p_po_id,p_poline_id,
458: p_opm_item_id,v_recv_qty1,v_old_recv_qty1,
459: p_recv_um1,'CORRECT',v_trans_id1,
460: v_destination_type1,0,0,NULL,0);

Line 462: gml_recv_trans_pkg.gml_new_rcv_trans_insert(p_recv_id,p_line_id,

458: p_opm_item_id,v_recv_qty1,v_old_recv_qty1,
459: p_recv_um1,'CORRECT',v_trans_id1,
460: v_destination_type1,0,0,NULL,0);
461:
462: gml_recv_trans_pkg.gml_new_rcv_trans_insert(p_recv_id,p_line_id,
463: p_po_id,p_poline_id,
464: p_opm_item_id,v_recv_qty1,v_old_recv_qty1,
465: p_recv_um1,'CORRECT',v_trans_id2,
466: v_destination_type2,0,0,NULL,0 );

Line 688: gml_recv_trans_pkg.gml_adjust_recv_trans(error_rec.recv_id,

684: X_return_ind, X_recv_status, X_net_price;
685: CLOSE get_recv_dtl_cur;
686:
687: G_adjust_mode := 'ERRORS';
688: gml_recv_trans_pkg.gml_adjust_recv_trans(error_rec.recv_id,
689: error_rec.line_id,
690: X_po_id, X_poline_id,
691: X_opm_item_id, error_rec.recv_qty1,
692: error_rec.old_recv_qty1,

Line 1415: END GML_RECV_TRANS_PKG;

1411: RAISE_APPLICATION_ERROR(-20000, err_msg);
1412:
1413: END gml_new_rcv_trans_insert;
1414:
1415: END GML_RECV_TRANS_PKG;