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.3 2007/08/07 09:45:14 vkaranam 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 762: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_23d_trxs_pkg.calculate_qty_balances';

758: v_closing_qty IN OUT NOCOPY NUMBER,
759: p_inventory_item_id Number) IS
760:
761: /* Added by Ramananda for bug#4407165 */
762: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_23d_trxs_pkg.calculate_qty_balances';
763:
764: v_previous_serial_no number;
765: v_serial_no number;
766: v_rg_balance number;

Line 893: END JAI_CMN_RG_23D_TRXS_PKG;

889: set qty_to_adjust= nvl(qty_to_adjust,0) - nvl(p_quantity_applied,0)
890: where register_id=p_receipt_id;
891: END upd_receipt_qty_matched;
892:
893: END JAI_CMN_RG_23D_TRXS_PKG;