DBA Data[Home] [Help]

APPS.GMD_OUTBOUND_APIS_PUB dependencies on MTL_ORGANIZATIONS

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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