APPS.JAI_OM_WDD_PROCESSING_PKG dependencies on WSH_DELIVERY_DETAILS

Line 2004: PROCEDURE RG23D_REV_ACCOUNTING(pr_trig_row IN wsh_delivery_details%ROWTYPE,

2000: REM NOTES Come from JAI_OM_WDD_TRIGGER_PKG.RG23D_REV_ACCOUNTING
2001: REM Passing the accounting entries in the sub-ledger table jai_cmn_journal_entries.
2002: REM +========================================================================================+
2003: */
2004: PROCEDURE RG23D_REV_ACCOUNTING(pr_trig_row IN wsh_delivery_details%ROWTYPE,
2005: pv_return_code out nocopy VARCHAR2,
2006: pv_return_message out nocopy VARCHAR2) IS
2007:
2008: v_api_name CONSTANT VARCHAR2(30) := 'RG23D_REV_ACCOUNTING';

Line 2106: lv_source_table VARCHAR2(100) := 'wsh_delivery_details';

2102: lv_reference_24 varchar2(100) := 'wsh_new_deliveries';
2103: lv_reference_26 varchar2(100) := To_Char(pr_trig_row.delivery_detail_id);
2104: lv_reference_25 varchar2(100) := 'delivery_id';
2105: lv_regime_code VARCHAR2(100) := 'EXCISE';
2106: lv_source_table VARCHAR2(100) := 'wsh_delivery_details';
2107:
2108: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
2109:
2110: BEGIN

Line 3450: FROM wsh_delivery_details

3446:
3447: cursor c_get_delivery_details(p_delivery_id wsh_delivery_assignments.delivery_id%type)
3448: is
3449: SELECT *
3450: FROM wsh_delivery_details
3451: WHERE delivery_detail_id IN
3452: ( SELECT
3453: delivery_detail_id
3454: FROM

Line 3594: FROM wsh_delivery_details

3590:
3591: cursor c_get_delivery_details(p_delivery_id wsh_delivery_assignments.delivery_id%type)
3592: is
3593: SELECT *
3594: FROM wsh_delivery_details
3595: WHERE delivery_detail_id IN
3596: ( SELECT
3597: delivery_detail_id
3598: FROM

Line 3809: FROM wsh_delivery_details

3805:
3806: cursor c_get_delivery_details(p_delivery_id wsh_delivery_assignments.delivery_id%type)
3807: is
3808: SELECT *
3809: FROM wsh_delivery_details
3810: WHERE delivery_detail_id IN
3811: ( SELECT
3812: delivery_detail_id
3813: FROM

Line 3831: CURSOR c_get_loc_id (cp_subinventory wsh_delivery_details.SUBINVENTORY%TYPE, cp_organization_id wsh_delivery_details.ORGANIZATION_ID%TYPE)IS

3827: select delivery_date
3828: from JAI_RGM_INVOICE_GEN_T
3829: where delivery_id = p_delivery_id;
3830:
3831: CURSOR c_get_loc_id (cp_subinventory wsh_delivery_details.SUBINVENTORY%TYPE, cp_organization_id wsh_delivery_details.ORGANIZATION_ID%TYPE)IS
3832: SELECT Location_id
3833: FROM JAI_INV_SUBINV_DTLS
3834: WHERE Sub_Inventory_Name = cp_subinventory
3835: AND organization_id = cp_organization_id;

Line 3837: CURSOR c_reg_num(cp_regime_id number,cp_organization_id wsh_delivery_details.ORGANIZATION_ID%TYPE , cp_location_id wsh_delivery_details.ship_to_location_id%TYPE ) IS

3833: FROM JAI_INV_SUBINV_DTLS
3834: WHERE Sub_Inventory_Name = cp_subinventory
3835: AND organization_id = cp_organization_id;
3836:
3837: CURSOR c_reg_num(cp_regime_id number,cp_organization_id wsh_delivery_details.ORGANIZATION_ID%TYPE , cp_location_id wsh_delivery_details.ship_to_location_id%TYPE ) IS
3838: SELECT attribute_Value
3839: FROM JAI_RGM_ORG_REGNS_V
3840: WHERE regime_id = cp_regime_id
3841: AND attribute_type_code = jai_constants.rgm_attr_type_code_primary