APPS.JAI_CMN_RG_OPM_PKG dependencies on JAI_CMN_RG_OPM_PKG

Line 1: PACKAGE BODY jai_cmn_rg_opm_pkg AS

1: PACKAGE BODY jai_cmn_rg_opm_pkg AS
2: /* $Header: jai_cmn_rg_opm.plb 120.1 2005/07/20 12:57:19 avallabh ship $ */
3:
4: PROCEDURE create_rg23_entry
5: (

Line 20: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_opm_pkg.create_rg23_entry';

16: )
17: IS
18:
19: /* Added by Ramananda for bug#4407165 */
20: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_opm_pkg.create_rg23_entry';
21:
22: Cursor C_osp_lines(p_mode varchar2) IS
23: Select
24: a.act_quantity,

Line 296: ,P_CALLED_FROM => 'jai_cmn_rg_opm_pkg.create_rg23_entry'

292: ,P_ADDITIONAL_ED => null
293: ,P_OTHER_ED => null
294: ,P_CHARGE_ACCOUNT_ID => NULL
295: ,P_TRANSACTION_SOURCE => 'OPM_OSP'
296: ,P_CALLED_FROM => 'jai_cmn_rg_opm_pkg.create_rg23_entry'
297: ,P_SIMULATE_FLAG => jai_constants.no
298: ,P_PROCESS_STATUS => lv_proc_status
299: ,P_PROCESS_MESSAGE => lv_proc_msg
300: );

Line 354: ,P_CALLED_FROM => 'jai_cmn_rg_opm_pkg.create_rg23_entry'

350: ,P_OTHER_TAX_CREDIT => null
351: ,P_OTHER_TAX_DEBIT => null
352: ,P_TRANSACTION_TYPE => p_iss_recpt_mode
353: ,P_TRANSACTION_SOURCE => 'OPM_OSP'
354: ,P_CALLED_FROM => 'jai_cmn_rg_opm_pkg.create_rg23_entry'
355: ,P_SIMULATE_FLAG => jai_constants.no
356: ,P_PROCESS_STATUS => lv_proc_status
357: ,P_PROCESS_MESSAGE => lv_proc_msg
358: );

Line 408: ,P_CALLED_FROM => 'jai_cmn_rg_opm_pkg.create_rg23_entry'

404: ,P_OTHER_TAX_CREDIT => null
405: ,P_OTHER_TAX_DEBIT => null
406: ,P_TRANSACTION_TYPE => p_iss_recpt_mode
407: ,P_TRANSACTION_SOURCE => 'OPM OSP'
408: ,P_CALLED_FROM => 'jai_cmn_rg_opm_pkg.create_rg23_entry'
409: ,P_SIMULATE_FLAG => jai_constants.no
410: ,P_PROCESS_STATUS => lv_proc_status
411: ,P_PROCESS_MESSAGE => lv_proc_msg
412: ,P_ROUNDING_ID => NULL

Line 478: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_opm_pkg.calculate_pla_balances';

474: p_mode VARCHAR2,excise_amt NUMBER,v_opening_balance IN OUT NOCOPY NUMBER,
475: v_closing_balance IN OUT NOCOPY NUMBER) IS
476:
477: /* Added by Ramananda for bug#4407165
478: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_opm_pkg.calculate_pla_balances';
479:
480: CURSOR balance_cur IS
481: SELECT NVL(pla_balance,0)
482: FROM JAI_CMN_RG_BALANCES a, JAI_CMN_INVENTORY_ORGS b

Line 584: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_opm_pkg.create_rg_i_entry';

580: )
581: IS
582:
583: /* Added by Ramananda for bug#4407165 */
584: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_opm_pkg.create_rg_i_entry';
585:
586: itemclass varchar2(5);
587: exciseitem varchar2(1); -- := 'N' File.Sql.35 by Brathod
588: l_po_id number(10);

Line 815: ,P_CALLED_FROM => 'jai_cmn_rg_opm_pkg.create_rg_i_entry'

811: ,P_ADDITIONAL_ED => null
812: ,P_OTHER_ED => null
813: ,P_CHARGE_ACCOUNT_ID => NULL
814: ,P_TRANSACTION_SOURCE => 'OPM OSP'
815: ,P_CALLED_FROM => 'jai_cmn_rg_opm_pkg.create_rg_i_entry'
816: ,P_SIMULATE_FLAG => jai_constants.no
817: ,P_PROCESS_STATUS => lv_proc_status
818: ,P_PROCESS_MESSAGE => lv_proc_msg
819: );

Line 928: ,P_CALLED_FROM => 'jai_cmn_rg_opm_pkg.create_rg_i_entry'

924: ,P_CREATED_BY => p_created_by
925: ,P_LAST_UPDATE_DATE => sysdate
926: ,P_LAST_UPDATED_BY => p_created_by
927: ,P_LAST_UPDATE_LOGIN => ln_login_id
928: ,P_CALLED_FROM => 'jai_cmn_rg_opm_pkg.create_rg_i_entry'
929: );
930:
931: end if;
932:

Line 942: END jai_cmn_rg_opm_pkg;

938: app_exception.raise_exception;
939:
940: END create_rg_i_entry;
941:
942: END jai_cmn_rg_opm_pkg;