eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_QC_MIG12 dependencies on FND_API

Line 990: IF (p_commit = FND_API.G_TRUE) THEN

986: );
987:
988: GMD_QC_MIG12.g_quality_config_ins_count := GMD_QC_MIG12.g_quality_config_ins_count + 1;
989:
990: IF (p_commit = FND_API.G_TRUE) THEN
991: COMMIT;
992: END IF;
993:
994: END IF;

Line 1375: P_COMMIT => FND_API.G_TRUE,

1371: P_MIGRATION_RUN_ID => p_migration_run_id,
1372: P_ITEM_ID => v_test_method.test_kit_item_id,
1373: P_ORGANIZATION_ID => l_organization_id,
1374: P_MODE => NULL,
1375: P_COMMIT => FND_API.G_TRUE,
1376: X_INVENTORY_ITEM_ID => l_inventory_item_id,
1377: X_FAILURE_COUNT => l_failure_count);
1378:
1379: IF (l_failure_count > 0) THEN

Line 1402: IF (p_commit = FND_API.G_TRUE) THEN

1398: test_kit_organization_id = l_test_org,
1399: migrated_ind = 1
1400: WHERE test_method_id = v_test_method.test_method_id;
1401:
1402: IF (p_commit = FND_API.G_TRUE) THEN
1403: COMMIT;
1404: END IF;
1405:
1406: GMD_QC_MIG12.g_test_method_upd_count := GMD_QC_MIG12.g_test_method_upd_count + 1;

Line 1679: IF (p_commit = FND_API.G_TRUE) THEN

1675: ss_last_assigned = l_stbl_last_assigned,
1676: migrated_ind = 1
1677: WHERE orgn_code = v_qual_config.orgn_code;
1678:
1679: IF (p_commit = FND_API.G_TRUE) THEN
1680: COMMIT;
1681: END IF;
1682:
1683: GMD_QC_MIG12.g_quality_config_upd_count := GMD_QC_MIG12.g_quality_config_upd_count + 1;

Line 2041: IF (p_commit = FND_API.G_TRUE) THEN

2037: );
2038:
2039: GMD_QC_MIG12.g_quality_config_ins_count := GMD_QC_MIG12.g_quality_config_ins_count + 1;
2040:
2041: IF (p_commit = FND_API.G_TRUE) THEN
2042: COMMIT;
2043: END IF;
2044: ELSE -- vorg dont exist.
2045: EXIT;

Line 2119: IF (p_commit = FND_API.G_TRUE) THEN

2115: UPDATE gmd_quality_config
2116: SET migrated_ind = 1
2117: WHERE orgn_code IS NULL and migrated_ind IS NULL;
2118:
2119: IF (p_commit = FND_API.G_TRUE) THEN
2120: COMMIT;
2121: END IF;
2122: GMD_QC_MIG12.g_quality_config_upd_count := GMD_QC_MIG12.g_quality_config_upd_count + 1;
2123:

Line 2157: IF (p_commit = FND_API.G_TRUE) THEN

2153: SET sample_assignment_type = l_p_assign_type,
2154: sample_last_assigned = l_p_last_assign
2155: WHERE organization_id = l_config.organization_id;
2156:
2157: IF (p_commit = FND_API.G_TRUE) THEN
2158: COMMIT;
2159: END IF;
2160:
2161: END IF;

Line 2310: IF (p_commit = FND_API.G_TRUE) THEN

2306: SET frequency_per = l_sampling_uom,
2307: migrated_ind = 1
2308: WHERE sampling_plan_id = l_sampling_plan.sampling_plan_id;
2309:
2310: IF (p_commit = FND_API.G_TRUE) THEN
2311: COMMIT;
2312: END IF;
2313:
2314: GMD_QC_MIG12.g_sampling_plan_upd_count := GMD_QC_MIG12.g_sampling_plan_upd_count + 1;

Line 2897: P_COMMIT => FND_API.G_TRUE,

2893: P_MIGRATION_RUN_ID => p_migration_run_id,
2894: P_ITEM_ID => v_samp_rec.item_id,
2895: P_ORGANIZATION_ID => l_organization_id,
2896: P_MODE => NULL,
2897: P_COMMIT => FND_API.G_TRUE,
2898: X_INVENTORY_ITEM_ID => l_inventory_item_id,
2899: X_FAILURE_COUNT => l_failure_count);
2900:
2901: IF (l_failure_count > 0) THEN

Line 2943: P_COMMIT => FND_API.G_TRUE,

2939: P_SUBLOT_NO => v_samp_rec.sublot_no,
2940: P_WHSE_CODE => NULL,
2941: P_LOCATION => NULL,
2942: P_GET_PARENT_ONLY => 0,
2943: P_COMMIT => FND_API.G_TRUE,
2944: X_LOT_NUMBER => l_lot_number,
2945: X_PARENT_LOT_NUMBER => l_parent_lot_number,
2946: X_FAILURE_COUNT => l_failure_count
2947: );

Line 3037: P_COMMIT => FND_API.G_TRUE,

3033: P_SUBLOT_NO => l_sublot_no,
3034: P_WHSE_CODE => NULL,
3035: P_LOCATION => NULL,
3036: P_GET_PARENT_ONLY => 0,
3037: P_COMMIT => FND_API.G_TRUE,
3038: X_LOT_NUMBER => l_lot_number,
3039: X_PARENT_LOT_NUMBER => l_parent_lot_number,
3040: X_FAILURE_COUNT => l_failure_count
3041: );

Line 3070: P_COMMIT => FND_API.G_TRUE,

3066: P_SUBLOT_NO => v_samp_rec.sublot_no,
3067: P_WHSE_CODE => NULL,
3068: P_LOCATION => NULL,
3069: P_GET_PARENT_ONLY => 0,
3070: P_COMMIT => FND_API.G_TRUE,
3071: X_LOT_NUMBER => l_lot_number,
3072: X_PARENT_LOT_NUMBER => l_parent_lot_number,
3073: X_FAILURE_COUNT => l_failure_count
3074: );

Line 3132: IF (p_commit = FND_API.G_TRUE) THEN

3128: material_detail_id = l_material_detail_id, -- Bug# 5261810
3129: migrated_ind = 1
3130: WHERE sample_id = v_samp_rec.sample_id;
3131:
3132: IF (p_commit = FND_API.G_TRUE) THEN
3133: COMMIT;
3134: END IF;
3135:
3136: GMD_QC_MIG12.g_sample_upd_count := GMD_QC_MIG12.g_sample_upd_count + 1;

Line 3532: IF (p_commit = FND_API.G_TRUE) THEN

3528: material_detail_id = l_samp_data.material_detail_id, -- Bug# 5261810
3529: migrated_ind = 1
3530: WHERE sampling_event_id = v_samp_event.sampling_event_id;
3531:
3532: IF (p_commit = FND_API.G_TRUE) THEN
3533: COMMIT;
3534: END IF;
3535:
3536: GMD_QC_MIG12.g_sample_event_upd_count := GMD_QC_MIG12.g_sample_event_upd_count + 1;

Line 3719: P_COMMIT => FND_API.G_TRUE,

3715: P_MIGRATION_RUN_ID => p_migration_run_id,
3716: P_ITEM_ID => v_result.test_kit_item_id,
3717: P_ORGANIZATION_ID => v_result.lab_organization_id,
3718: P_MODE => NULL,
3719: P_COMMIT => FND_API.G_TRUE,
3720: X_INVENTORY_ITEM_ID => l_inventory_item_id,
3721: X_FAILURE_COUNT => l_failure_count);
3722:
3723: IF (l_failure_count > 0) THEN

Line 3752: P_COMMIT => FND_API.G_TRUE,

3748: P_SUBLOT_NO => v_result.test_kit_sublot_no,
3749: P_WHSE_CODE => NULL,
3750: P_LOCATION => NULL,
3751: P_GET_PARENT_ONLY => 0,
3752: P_COMMIT => FND_API.G_TRUE,
3753: X_LOT_NUMBER => l_lot_number,
3754: X_PARENT_LOT_NUMBER => l_parent_lot_number,
3755: X_FAILURE_COUNT => l_failure_count
3756: );

Line 3777: IF (p_commit = FND_API.G_TRUE) THEN

3773: test_kit_inv_item_id = l_inventory_item_id,
3774: migrated_ind = 1
3775: WHERE result_id = v_result.result_id;
3776:
3777: IF (p_commit = FND_API.G_TRUE) THEN
3778: COMMIT;
3779: END IF;
3780:
3781: GMD_QC_MIG12.g_result_upd_count := GMD_QC_MIG12.g_result_upd_count + 1;

Line 4400: P_COMMIT => FND_API.G_TRUE,

4396: P_MIGRATION_RUN_ID => p_migration_run_id,
4397: P_ITEM_ID => v_specs_b.item_id,
4398: P_ORGANIZATION_ID => l_owner_org_id,
4399: P_MODE => NULL,
4400: P_COMMIT => FND_API.G_TRUE,
4401: X_INVENTORY_ITEM_ID => l_spec_inv_item_id,
4402: X_FAILURE_COUNT => l_failure_count);
4403:
4404: IF (l_failure_count > 0) THEN

Line 4424: IF (p_commit = FND_API.G_TRUE) THEN

4420: grade_code = grade,
4421: migrated_ind = 1
4422: WHERE spec_id = v_specs_b.spec_id;
4423:
4424: IF (p_commit = FND_API.G_TRUE) THEN
4425: COMMIT;
4426: END IF;
4427:
4428: GMD_QC_MIG12.g_specs_upd_count := GMD_QC_MIG12.g_specs_upd_count + 1;

Line 4689: P_COMMIT => FND_API.G_TRUE,

4685: P_SUBLOT_NO => l_inv_spec.sublot_no,
4686: P_WHSE_CODE => NULL,
4687: P_LOCATION => NULL,
4688: P_GET_PARENT_ONLY => 0,
4689: P_COMMIT => FND_API.G_TRUE,
4690: X_LOT_NUMBER => l_lot_number,
4691: X_PARENT_LOT_NUMBER => l_parent_lot_number,
4692: X_FAILURE_COUNT => l_failure_count
4693: );

Line 4743: IF (p_commit = FND_API.G_TRUE) THEN

4739: in_spec_lot_status_id = l_in_spec_status_id,
4740: migrated_ind = 1
4741: WHERE spec_vr_id = l_inv_spec.spec_vr_id;
4742:
4743: IF (p_commit = FND_API.G_TRUE) THEN
4744: COMMIT;
4745: END IF;
4746:
4747: GMD_QC_MIG12.g_inv_spec_upd_count := GMD_QC_MIG12.g_inv_spec_upd_count + 1;

Line 4785: IF (p_commit = FND_API.G_TRUE) THEN

4781:
4782: DELETE gmd_inventory_spec_vrs
4783: WHERE spec_vr_id = l_inv_spec.spec_vr_id;
4784:
4785: IF (p_commit = FND_API.G_TRUE) THEN
4786: COMMIT;
4787: END IF;
4788:
4789: GMD_QC_MIG12.g_inv_spec_del_count := GMD_QC_MIG12.g_inv_spec_del_count + 1;

Line 4859: P_COMMIT => FND_API.G_TRUE,

4855: P_SUBLOT_NO => l_inv_spec.sublot_no,
4856: P_WHSE_CODE => NULL,
4857: P_LOCATION => NULL,
4858: P_GET_PARENT_ONLY => 0,
4859: P_COMMIT => FND_API.G_TRUE,
4860: X_LOT_NUMBER => l_lot_number,
4861: X_PARENT_LOT_NUMBER => l_parent_lot_number,
4862: X_FAILURE_COUNT => l_failure_count
4863: );

Line 4963: P_COMMIT => FND_API.G_TRUE,

4959: P_SUBLOT_NO => l_inv_spec.sublot_no,
4960: P_WHSE_CODE => NULL,
4961: P_LOCATION => NULL,
4962: P_GET_PARENT_ONLY => 0,
4963: P_COMMIT => FND_API.G_TRUE,
4964: X_LOT_NUMBER => l_lot_number,
4965: X_PARENT_LOT_NUMBER => l_parent_lot_number,
4966: X_FAILURE_COUNT => l_failure_count
4967: );

Line 5096: IF (p_commit = FND_API.G_TRUE) THEN

5092: END LOOP; -- get_sample_org
5093:
5094: CLOSE get_sample_org;
5095:
5096: IF (p_commit = FND_API.G_TRUE) THEN
5097: COMMIT;
5098: END IF;
5099:
5100: END IF; -- clone endif

Line 5487: IF (p_commit = FND_API.G_TRUE) THEN

5483: WHERE spec_vr_id = l_wip_spec.spec_vr_id;
5484:
5485: GMD_QC_MIG12.g_wip_spec_upd_count := GMD_QC_MIG12.g_wip_spec_upd_count + 1;
5486:
5487: IF (p_commit = FND_API.G_TRUE) THEN
5488: COMMIT;
5489: END IF;
5490:
5491: ELSE -- org is null

Line 5511: IF (p_commit = FND_API.G_TRUE) THEN

5507:
5508: DELETE gmd_wip_spec_vrs
5509: WHERE spec_vr_id = l_wip_spec.spec_vr_id;
5510:
5511: IF (p_commit = FND_API.G_TRUE) THEN
5512: COMMIT;
5513: END IF;
5514:
5515: GMD_QC_MIG12.g_wip_spec_del_count := GMD_QC_MIG12.g_wip_spec_del_count + 1;

Line 5898: IF (p_commit = FND_API.G_TRUE) THEN

5894: UPDATE gmd_customer_spec_vrs
5895: SET migrated_ind = 1
5896: WHERE spec_vr_id = l_cust_spec.spec_vr_id;
5897:
5898: IF (p_commit = FND_API.G_TRUE) THEN
5899: COMMIT;
5900: END IF;
5901:
5902: GMD_QC_MIG12.g_cust_spec_upd_count := GMD_QC_MIG12.g_cust_spec_upd_count + 1;

Line 5924: IF (p_commit = FND_API.G_TRUE) THEN

5920:
5921: DELETE gmd_customer_spec_vrs
5922: WHERE spec_vr_id = l_wip_spec.spec_vr_id;
5923:
5924: IF (p_commit = FND_API.G_TRUE) THEN
5925: COMMIT;
5926: END IF;
5927:
5928: GMD_QC_MIG12.g_cust_spec_del_count := GMD_QC_MIG12.g_cust_spec_del_count + 1;

Line 6115: IF (p_commit = FND_API.G_TRUE) THEN

6111: CLOSE get_cust_sample_org; -- Bug# 5554719
6112:
6113: END IF; -- orgn code is null check
6114:
6115: IF (p_commit = FND_API.G_TRUE) THEN
6116: COMMIT;
6117: END IF;
6118:
6119: EXCEPTION

Line 6276: IF (p_commit = FND_API.G_TRUE) THEN

6272: org_id = l_supl_org_id,
6273: migrated_ind = 1
6274: WHERE spec_vr_id = l_supl_spec.spec_vr_id;
6275:
6276: IF (p_commit = FND_API.G_TRUE) THEN
6277: COMMIT;
6278: END IF;
6279:
6280: GMD_QC_MIG12.g_supl_spec_upd_count := GMD_QC_MIG12.g_supl_spec_upd_count + 1;

Line 6302: IF (p_commit = FND_API.G_TRUE) THEN

6298:
6299: DELETE gmd_supplier_spec_vrs
6300: WHERE spec_vr_id = l_supl_spec.spec_vr_id;
6301:
6302: IF (p_commit = FND_API.G_TRUE) THEN
6303: COMMIT;
6304: END IF;
6305:
6306: GMD_QC_MIG12.g_supl_spec_del_count := GMD_QC_MIG12.g_supl_spec_del_count + 1;

Line 6347: IF (p_commit = FND_API.G_TRUE) THEN

6343: org_id = l_supl_org_id,
6344: migrated_ind = 1
6345: WHERE spec_vr_id = l_supl_spec.spec_vr_id;
6346:
6347: IF (p_commit = FND_API.G_TRUE) THEN
6348: COMMIT;
6349: END IF;
6350:
6351: GMD_QC_MIG12.g_supl_spec_upd_count := GMD_QC_MIG12.g_supl_spec_upd_count + 1;

Line 6499: IF (p_commit = FND_API.G_TRUE) THEN

6495: CLOSE get_supl_sample_org;
6496:
6497: END IF; -- orgn code not null
6498:
6499: IF (p_commit = FND_API.G_TRUE) THEN
6500: COMMIT;
6501: END IF;
6502:
6503:

Line 6751: IF (p_commit = FND_API.G_TRUE) THEN

6747: locator_id = l_locator_id,
6748: migrated_ind = 1
6749: WHERE spec_vr_id = l_mon_spec.spec_vr_id;
6750:
6751: IF (p_commit = FND_API.G_TRUE) THEN
6752: COMMIT;
6753: END IF;
6754:
6755: GMD_QC_MIG12.g_mon_spec_upd_count := GMD_QC_MIG12.g_mon_spec_upd_count + 1;

Line 6777: IF (p_commit = FND_API.G_TRUE) THEN

6773:
6774: DELETE gmd_monitoring_spec_vrs
6775: WHERE spec_vr_id = l_mon_spec.spec_vr_id;
6776:
6777: IF (p_commit = FND_API.G_TRUE) THEN
6778: COMMIT;
6779: END IF;
6780:
6781: GMD_QC_MIG12.g_mon_spec_del_count := GMD_QC_MIG12.g_mon_spec_del_count + 1;

Line 6819: IF (p_commit = FND_API.G_TRUE) THEN

6815: locator_id = l_locator_id,
6816: migrated_ind = 1
6817: WHERE spec_vr_id = l_mon_spec.spec_vr_id;
6818:
6819: IF (p_commit = FND_API.G_TRUE) THEN
6820: COMMIT;
6821: END IF;
6822:
6823: GMD_QC_MIG12.g_mon_spec_upd_count := GMD_QC_MIG12.g_mon_spec_upd_count + 1;

Line 6960: IF (p_commit = FND_API.G_TRUE) THEN

6956: CLOSE get_mon_sample_org;
6957:
6958: END IF; -- orgn code null.
6959:
6960: IF (p_commit = FND_API.G_TRUE) THEN
6961: COMMIT;
6962: END IF;
6963:
6964:

Line 7521: IF (p_commit = FND_API.G_TRUE) THEN

7517: storage_locator_id = l_plan_locator_id,
7518: migrated_ind = 1
7519: WHERE storage_plan_detail_id = l_plan_det.storage_plan_detail_id;
7520:
7521: IF (p_commit = FND_API.G_TRUE) THEN
7522: COMMIT;
7523: END IF;
7524:
7525: GMD_QC_MIG12.g_store_plan_upd_count := GMD_QC_MIG12.g_store_plan_upd_count + 1;

Line 7687: P_COMMIT => FND_API.G_TRUE,

7683: P_MIGRATION_RUN_ID => p_migration_run_id,
7684: P_ITEM_ID => l_stab_rec.item_id,
7685: P_ORGANIZATION_ID => l_stab_org_id,
7686: P_MODE => NULL,
7687: P_COMMIT => FND_API.G_TRUE,
7688: X_INVENTORY_ITEM_ID => l_inventory_item_id,
7689: X_FAILURE_COUNT => l_failure_count);
7690: IF (l_failure_count > 0) THEN
7691: RAISE STAB_ODM_ITEM;

Line 7703: IF (p_commit = FND_API.G_TRUE) THEN

7699: organization_id = l_stab_org_id,
7700: migrated_ind = 1
7701: WHERE ss_id = l_stab_rec.ss_id;
7702:
7703: IF (p_commit = FND_API.G_TRUE) THEN
7704: COMMIT;
7705: END IF;
7706:
7707: GMD_QC_MIG12.g_stab_upd_count := GMD_QC_MIG12.g_stab_upd_count + 1;

Line 7863: P_COMMIT => FND_API.G_TRUE,

7859: P_ITEM_ID => l_ss_item_id,
7860: P_LOT_ID => l_matl_rec.lot_id,
7861: P_WHSE_CODE => NULL,
7862: P_LOCATION => NULL,
7863: P_COMMIT => FND_API.G_TRUE,
7864: X_LOT_NUMBER => l_lot_number,
7865: X_PARENT_LOT_NUMBER => l_parent_lot_number,
7866: X_FAILURE_COUNT => l_failure_count
7867: );

Line 7894: IF (p_commit = FND_API.G_TRUE) THEN

7890: migrated_ind = 1
7891: WHERE source_id = l_matl_rec.source_id
7892: AND ss_id = l_matl_rec.ss_id;
7893:
7894: IF (p_commit = FND_API.G_TRUE) THEN
7895: COMMIT;
7896: END IF;
7897: GMD_QC_MIG12.g_matl_source_upd_count := GMD_QC_MIG12.g_matl_source_upd_count + 1;
7898:

Line 8109: IF (p_commit = FND_API.G_TRUE) THEN

8105: migrated_ind = 1
8106: WHERE variant_id = l_var_rec.variant_id;
8107:
8108:
8109: IF (p_commit = FND_API.G_TRUE) THEN
8110: COMMIT;
8111: END IF;
8112:
8113: GMD_QC_MIG12.g_ss_variant_upd_count := GMD_QC_MIG12.g_ss_variant_upd_count + 1;

Line 8330: P_COMMIT => FND_API.G_TRUE,

8326: P_MIGRATION_RUN_ID => p_migration_run_id,
8327: P_ITEM_ID => l_store_pack.item_id,
8328: P_ORGANIZATION_ID => l_def_ss_org_id,
8329: P_MODE => NULL,
8330: P_COMMIT => FND_API.G_TRUE,
8331: X_INVENTORY_ITEM_ID => l_store_pack_invitem_id,
8332: X_FAILURE_COUNT => l_failure_count);
8333: IF (l_failure_count > 0) THEN
8334: RAISE STORE_DEF_ODM_ITEM;

Line 8370: P_COMMIT => FND_API.G_TRUE,

8366: P_MIGRATION_RUN_ID => p_migration_run_id,
8367: P_ITEM_ID => l_store_pack.item_id,
8368: P_ORGANIZATION_ID => l_ss_org_id,
8369: P_MODE => NULL,
8370: P_COMMIT => FND_API.G_TRUE,
8371: X_INVENTORY_ITEM_ID => l_store_pack_invitem_id,
8372: X_FAILURE_COUNT => l_failure_count);
8373: IF (l_failure_count > 0) THEN
8374: CLOSE get_stab_study_org;

Line 8424: P_COMMIT => FND_API.G_TRUE,

8420: P_MIGRATION_RUN_ID => p_migration_run_id,
8421: P_ITEM_ID => l_store_pack.item_id,
8422: P_ORGANIZATION_ID => l_ss_org_id,
8423: P_MODE => NULL,
8424: P_COMMIT => FND_API.G_TRUE,
8425: X_INVENTORY_ITEM_ID => l_store_pack_invitem_id,
8426: X_FAILURE_COUNT => l_failure_count);
8427: IF (l_failure_count > 0) THEN
8428: CLOSE get_stab_study_org;

Line 8522: IF (p_commit = FND_API.G_TRUE) THEN

8518:
8519: CLOSE get_stab_study_org;
8520: END IF;
8521:
8522: IF (p_commit = FND_API.G_TRUE) THEN
8523: COMMIT;
8524: END IF;
8525:
8526: EXCEPTION

Line 8724: IF (p_commit = FND_API.G_TRUE) THEN

8720: organization_id = l_hist_org_id,
8721: migrated_ind = 1
8722: WHERE storage_history_id = l_hist_rec.storage_history_id;
8723:
8724: IF (p_commit = FND_API.G_TRUE) THEN
8725: COMMIT;
8726: END IF;
8727:
8728: GMD_QC_MIG12.g_ss_storehist_upd_count := GMD_QC_MIG12.g_ss_storehist_upd_count + 1;