APPS.JAI_CMN_RG_23D_TRXS_PKG dependencies on JAI_CMN_RG_23D_TRXS_PKG

Line 1: PACKAGE BODY jai_cmn_rg_23d_trxs_pkg AS

1: PACKAGE BODY jai_cmn_rg_23d_trxs_pkg AS
2: /* $Header: jai_cmn_rg_23d.plb 120.5.12020000.2 2013/04/09 09:29:44 mmurtuza ship $ */
3:
4: /* --------------------------------------------------------------------------------------
5: Filename:

Line 114: CHANGE HISTORY for FILENAME: jai_cmn_rg_23d_trxs_pkg.sql

110:
111: BEGIN
112:
113: /*----------------------------------------------------------------------------------------------------------------------------
114: CHANGE HISTORY for FILENAME: jai_cmn_rg_23d_trxs_pkg.sql
115: S.No dd/mm/yyyy Author and Details
116: ------------------------------------------------------------------------------------------------------------------------------
117: 1 16/07/2004 Vijay Shankar for Bug# 3496408, Version:115.0
118: Table handler Package for JAI_CMN_RG_23D_TRXS table

Line 397: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_23d_trxs_pkg.update_row'; /* Added by Ramananda for bug#4407165 */

393: P_SIMULATE_FLAG IN VARCHAR2,
394: P_PROCESS_STATUS OUT NOCOPY VARCHAR2,
395: P_PROCESS_MESSAGE OUT NOCOPY VARCHAR2
396: ) IS
397: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_23d_trxs_pkg.update_row'; /* Added by Ramananda for bug#4407165 */
398: BEGIN
399:
400: UPDATE JAI_CMN_RG_23D_TRXS SET
401: REGISTER_ID = nvl(P_REGISTER_ID, REGISTER_ID),

Line 602: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_23d_trxs_pkg.make_entry';

598: p_last_updated_by IN NUMBER)
599: IS
600:
601: /* Added by Ramananda for bug#4407165 */
602: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_23d_trxs_pkg.make_entry';
603:
604: v_reg_id Number;
605: v_fin_year Number;
606: v_slno Number;

Line 770: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_23d_trxs_pkg.calculate_qty_balances';

766: v_closing_qty IN OUT NOCOPY NUMBER,
767: p_inventory_item_id Number) IS
768:
769: /* Added by Ramananda for bug#4407165 */
770: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_23d_trxs_pkg.calculate_qty_balances';
771:
772: v_previous_serial_no number;
773: v_serial_no number;
774: v_rg_balance number;

Line 901: END JAI_CMN_RG_23D_TRXS_PKG;

897: set qty_to_adjust= nvl(qty_to_adjust,0) - nvl(p_quantity_applied,0)
898: where register_id=p_receipt_id;
899: END upd_receipt_qty_matched;
900:
901: END JAI_CMN_RG_23D_TRXS_PKG;