DBA Data[Home] [Help]

APPS.GMD_OUTBOUND_APIS_PUB dependencies on MTL_ORGANIZATIONS

Line 86: g_owner_orgn_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*NSRIVAST, INVCONV*/

82: g_to_spec_last_update DATE;
83: g_spec_type VARCHAR2(2);
84:
85: g_owner_organization_code VARCHAR2(3); /*--NSRIVAST, INVCONV*/
86: g_owner_orgn_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*NSRIVAST, INVCONV*/
87:
88: g_spec_status NUMBER;
89: g_test_qty_uom VARCHAR2(3);
90: g_from_test_last_update DATE;

Line 115: g_wip_vr_orgn_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*NSRIVAST, INVCONV*/

111:
112: g_wip_vr_status NUMBER;
113: g_wip_vr_organization_code VARCHAR2(3); /*--NSRIVAST, INVCONV*/
114: g_wip_vr_batch_orgn_code VARCHAR2(3); /*--NSRIVAST, INVCONV*/
115: g_wip_vr_orgn_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*NSRIVAST, INVCONV*/
116: g_wip_vr_batch_orgn_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*NSRIVAST, INVCONV*/
117:
118: g_wip_vr_batch_no VARCHAR2(32);
119: g_wip_vr_batch_id NUMBER;

Line 116: g_wip_vr_batch_orgn_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*NSRIVAST, INVCONV*/

112: g_wip_vr_status NUMBER;
113: g_wip_vr_organization_code VARCHAR2(3); /*--NSRIVAST, INVCONV*/
114: g_wip_vr_batch_orgn_code VARCHAR2(3); /*--NSRIVAST, INVCONV*/
115: g_wip_vr_orgn_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*NSRIVAST, INVCONV*/
116: g_wip_vr_batch_orgn_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*NSRIVAST, INVCONV*/
117:
118: g_wip_vr_batch_no VARCHAR2(32);
119: g_wip_vr_batch_id NUMBER;
120: g_wip_vr_recipe_no VARCHAR2(80);

Line 150: g_cust_vr_orgn_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*NSRIVAST, INVCONV*/

146: g_cust_vr_start_date DATE;
147: g_cust_vr_end_date DATE;
148: g_cust_vr_status NUMBER;
149: g_cust_vr_organization_code VARCHAR2(3); /*--NSRIVAST, INVCONV*/
150: g_cust_vr_orgn_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*NSRIVAST, INVCONV*/
151:
152: g_cust_vr_org_id NUMBER;
153: g_cust_vr_coa_type VARCHAR2(1);
154: g_cust_vr_customer VARCHAR2(240);

Line 172: g_supl_vr_orgn_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*NSRIVAST, INVCONV*/

168: g_supl_vr_start_date DATE;
169: g_supl_vr_end_date DATE;
170: g_supl_vr_status NUMBER;
171: g_supl_vr_organization_code VARCHAR2(3); /*--NSRIVAST, INVCONV*/
172: g_supl_vr_orgn_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*NSRIVAST, INVCONV*/
173:
174: g_supl_vr_org_id NUMBER;
175: g_supl_vr_coa_type VARCHAR2(1);
176: g_supl_vr_supplier VARCHAR2(240);

Line 193: g_inv_vr_orgn_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*NSRIVAST, INVCONV*/

189: g_inv_vr_start_date DATE;
190: g_inv_vr_end_date DATE;
191: g_inv_vr_status NUMBER;
192: g_inv_vr_organization_code VARCHAR2(3); /*--NSRIVAST, INVCONV*/
193: g_inv_vr_orgn_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*NSRIVAST, INVCONV*/
194:
195: g_inv_vr_org_id NUMBER;
196: g_inv_vr_coa_type VARCHAR2(1);
197: g_inv_vr_item_number VARCHAR2(40);

Line 213: g_mon_vr_loct_orgn_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*NSRIVAST, INVCONV*/

209: -- START B3124291 Incorporated Mini-Pack K Features to Outboud APIs
210: g_mon_vr_status NUMBER(5);
211: g_mon_vr_rule_type VARCHAR2(2);
212: g_mon_vr_lct_organization_code VARCHAR2(3); /*--NSRIVAST, INVCONV*/
213: g_mon_vr_loct_orgn_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*NSRIVAST, INVCONV*/
214:
215: g_mon_vr_subinventory MTL_SECONDARY_INVENTORIES.SECONDARY_INVENTORY_NAME%TYPE ;/*NSRIVAST, INVCONV*/
216: g_mon_vr_locator_id NUMBER;
217: g_mon_vr_locator VARCHAR2(204);

Line 219: g_mon_vr_resource_orgn_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*NSRIVAST, INVCONV*/

215: g_mon_vr_subinventory MTL_SECONDARY_INVENTORIES.SECONDARY_INVENTORY_NAME%TYPE ;/*NSRIVAST, INVCONV*/
216: g_mon_vr_locator_id NUMBER;
217: g_mon_vr_locator VARCHAR2(204);
218: g_mon_vr_rsr_organization_code VARCHAR2(3); /*--NSRIVAST, INVCONV*/
219: g_mon_vr_resource_orgn_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*NSRIVAST, INVCONV*/
220:
221: g_mon_vr_resources VARCHAR2(16);
222: g_mon_vr_resource_instance_id NUMBER;
223: g_mon_vr_sampling_plan VARCHAR2(80);

Line 237: g_orgn_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*NSRIVAST, INVCONV*/

233:
234:
235: g_orgn_code VARCHAR2(4); /*--NSRIVAST, INVCONV*/
236: g_qc_lab_orgn_code VARCHAR2(4); /*--NSRIVAST, INVCONV*/
237: g_orgn_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*NSRIVAST, INVCONV*/
238: g_lab_organization_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*NSRIVAST, INVCONV*/
239: g_ss_organization_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*sxfeinst, INVCONV*/
240:
241: g_from_sample_no VARCHAR2(80);

Line 238: g_lab_organization_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*NSRIVAST, INVCONV*/

234:
235: g_orgn_code VARCHAR2(4); /*--NSRIVAST, INVCONV*/
236: g_qc_lab_orgn_code VARCHAR2(4); /*--NSRIVAST, INVCONV*/
237: g_orgn_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*NSRIVAST, INVCONV*/
238: g_lab_organization_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*NSRIVAST, INVCONV*/
239: g_ss_organization_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*sxfeinst, INVCONV*/
240:
241: g_from_sample_no VARCHAR2(80);
242: g_to_sample_no VARCHAR2(80);

Line 239: g_ss_organization_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*sxfeinst, INVCONV*/

235: g_orgn_code VARCHAR2(4); /*--NSRIVAST, INVCONV*/
236: g_qc_lab_orgn_code VARCHAR2(4); /*--NSRIVAST, INVCONV*/
237: g_orgn_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*NSRIVAST, INVCONV*/
238: g_lab_organization_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*NSRIVAST, INVCONV*/
239: g_ss_organization_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*sxfeinst, INVCONV*/
240:
241: g_from_sample_no VARCHAR2(80);
242: g_to_sample_no VARCHAR2(80);
243: g_sample_id NUMBER;

Line 366: g_wip_orgn_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*NSRIVAST, INVCONV*/

362: g_sample_event_id NUMBER;
363: g_disposition VARCHAR2(80);
364:
365: g_wip_orgn_code VARCHAR2(4); /*--NSRIVAST, INVCONV*/
366: g_wip_orgn_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*NSRIVAST, INVCONV*/
367:
368: g_wip_recipe_vers NUMBER;
369: g_wip_formula_vers NUMBER;
370: g_wip_formulaline_no NUMBER;

Line 407: g_sg_organization_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*sxfeinst, INVCONV*/

403: g_variant_id NUMBER;
404: g_variant_no NUMBER;
405: g_time_point_id NUMBER;
406: --g_sg_orgn_code VARCHAR2(4);/*sxfeinst, INVCONV*/
407: g_sg_organization_id MTL_ORGANIZATIONS.ORGANIZATION_ID%TYPE ; /*sxfeinst, INVCONV*/
408: -- END B3124291 Incorporated Mini-Pack K Features to Outboud APIs
409: -- Start Incorporated Mini-Pack L Features to Outboud APIs
410: g_reserve_sample_id NUMBER;
411: g_retain_as VARCHAR2(3);