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 982: IF (p_commit = FND_API.G_TRUE) THEN

978: );
979:
980: GMD_QC_MIG12.g_quality_config_ins_count := GMD_QC_MIG12.g_quality_config_ins_count + 1;
981:
982: IF (p_commit = FND_API.G_TRUE) THEN
983: COMMIT;
984: END IF;
985:
986: END IF;

Line 1367: P_COMMIT => FND_API.G_TRUE,

1363: P_MIGRATION_RUN_ID => p_migration_run_id,
1364: P_ITEM_ID => v_test_method.test_kit_item_id,
1365: P_ORGANIZATION_ID => l_organization_id,
1366: P_MODE => NULL,
1367: P_COMMIT => FND_API.G_TRUE,
1368: X_INVENTORY_ITEM_ID => l_inventory_item_id,
1369: X_FAILURE_COUNT => l_failure_count);
1370:
1371: IF (l_failure_count > 0) THEN

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

1390: test_kit_organization_id = l_test_org,
1391: migrated_ind = 1
1392: WHERE test_method_id = v_test_method.test_method_id;
1393:
1394: IF (p_commit = FND_API.G_TRUE) THEN
1395: COMMIT;
1396: END IF;
1397:
1398: GMD_QC_MIG12.g_test_method_upd_count := GMD_QC_MIG12.g_test_method_upd_count + 1;

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

1667: ss_last_assigned = l_stbl_last_assigned,
1668: migrated_ind = 1
1669: WHERE orgn_code = v_qual_config.orgn_code;
1670:
1671: IF (p_commit = FND_API.G_TRUE) THEN
1672: COMMIT;
1673: END IF;
1674:
1675: GMD_QC_MIG12.g_quality_config_upd_count := GMD_QC_MIG12.g_quality_config_upd_count + 1;

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

2029: );
2030:
2031: GMD_QC_MIG12.g_quality_config_ins_count := GMD_QC_MIG12.g_quality_config_ins_count + 1;
2032:
2033: IF (p_commit = FND_API.G_TRUE) THEN
2034: COMMIT;
2035: END IF;
2036: ELSE -- vorg dont exist.
2037: EXIT;

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

2107: UPDATE gmd_quality_config
2108: SET migrated_ind = 1
2109: WHERE orgn_code IS NULL and migrated_ind IS NULL;
2110:
2111: IF (p_commit = FND_API.G_TRUE) THEN
2112: COMMIT;
2113: END IF;
2114: GMD_QC_MIG12.g_quality_config_upd_count := GMD_QC_MIG12.g_quality_config_upd_count + 1;
2115:

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

2145: SET sample_assignment_type = l_p_assign_type,
2146: sample_last_assigned = l_p_last_assign
2147: WHERE organization_id = l_config.organization_id;
2148:
2149: IF (p_commit = FND_API.G_TRUE) THEN
2150: COMMIT;
2151: END IF;
2152:
2153: END IF;

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

2298: SET frequency_per = l_sampling_uom,
2299: migrated_ind = 1
2300: WHERE sampling_plan_id = l_sampling_plan.sampling_plan_id;
2301:
2302: IF (p_commit = FND_API.G_TRUE) THEN
2303: COMMIT;
2304: END IF;
2305:
2306: GMD_QC_MIG12.g_sampling_plan_upd_count := GMD_QC_MIG12.g_sampling_plan_upd_count + 1;

Line 2855: P_COMMIT => FND_API.G_TRUE,

2851: P_MIGRATION_RUN_ID => p_migration_run_id,
2852: P_ITEM_ID => v_samp_rec.item_id,
2853: P_ORGANIZATION_ID => l_organization_id,
2854: P_MODE => NULL,
2855: P_COMMIT => FND_API.G_TRUE,
2856: X_INVENTORY_ITEM_ID => l_inventory_item_id,
2857: X_FAILURE_COUNT => l_failure_count);
2858:
2859: IF (l_failure_count > 0) THEN

Line 2899: P_COMMIT => FND_API.G_TRUE,

2895: P_SUBLOT_NO => v_samp_rec.sublot_no,
2896: P_WHSE_CODE => NULL,
2897: P_LOCATION => NULL,
2898: P_GET_PARENT_ONLY => 0,
2899: P_COMMIT => FND_API.G_TRUE,
2900: X_LOT_NUMBER => l_lot_number,
2901: X_PARENT_LOT_NUMBER => l_parent_lot_number,
2902: X_FAILURE_COUNT => l_failure_count
2903: );

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

2954: material_detail_id = l_material_detail_id, -- Bug# 5261810
2955: migrated_ind = 1
2956: WHERE sample_id = v_samp_rec.sample_id;
2957:
2958: IF (p_commit = FND_API.G_TRUE) THEN
2959: COMMIT;
2960: END IF;
2961:
2962: GMD_QC_MIG12.g_sample_upd_count := GMD_QC_MIG12.g_sample_upd_count + 1;

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

3354: material_detail_id = l_samp_data.material_detail_id, -- Bug# 5261810
3355: migrated_ind = 1
3356: WHERE sampling_event_id = v_samp_event.sampling_event_id;
3357:
3358: IF (p_commit = FND_API.G_TRUE) THEN
3359: COMMIT;
3360: END IF;
3361:
3362: GMD_QC_MIG12.g_sample_event_upd_count := GMD_QC_MIG12.g_sample_event_upd_count + 1;

Line 3448: P_COMMIT => FND_API.G_TRUE,

3444: P_MIGRATION_RUN_ID => p_migration_run_id,
3445: P_ITEM_ID => v_result.test_kit_item_id,
3446: P_ORGANIZATION_ID => v_result.lab_organization_id,
3447: P_MODE => NULL,
3448: P_COMMIT => FND_API.G_TRUE,
3449: X_INVENTORY_ITEM_ID => l_inventory_item_id,
3450: X_FAILURE_COUNT => l_failure_count);
3451:
3452: IF (l_failure_count > 0) THEN

Line 3481: P_COMMIT => FND_API.G_TRUE,

3477: P_SUBLOT_NO => v_result.test_kit_sublot_no,
3478: P_WHSE_CODE => NULL,
3479: P_LOCATION => NULL,
3480: P_GET_PARENT_ONLY => 0,
3481: P_COMMIT => FND_API.G_TRUE,
3482: X_LOT_NUMBER => l_lot_number,
3483: X_PARENT_LOT_NUMBER => l_parent_lot_number,
3484: X_FAILURE_COUNT => l_failure_count
3485: );

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

3502: test_kit_inv_item_id = l_inventory_item_id,
3503: migrated_ind = 1
3504: WHERE result_id = v_result.result_id;
3505:
3506: IF (p_commit = FND_API.G_TRUE) THEN
3507: COMMIT;
3508: END IF;
3509:
3510: GMD_QC_MIG12.g_result_upd_count := GMD_QC_MIG12.g_result_upd_count + 1;

Line 4131: P_COMMIT => FND_API.G_TRUE,

4127: P_MIGRATION_RUN_ID => p_migration_run_id,
4128: P_ITEM_ID => v_specs_b.item_id,
4129: P_ORGANIZATION_ID => l_owner_org_id,
4130: P_MODE => NULL,
4131: P_COMMIT => FND_API.G_TRUE,
4132: X_INVENTORY_ITEM_ID => l_spec_inv_item_id,
4133: X_FAILURE_COUNT => l_failure_count);
4134:
4135: IF (l_failure_count > 0) THEN

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

4151: grade_code = grade,
4152: migrated_ind = 1
4153: WHERE spec_id = v_specs_b.spec_id;
4154:
4155: IF (p_commit = FND_API.G_TRUE) THEN
4156: COMMIT;
4157: END IF;
4158:
4159: GMD_QC_MIG12.g_specs_upd_count := GMD_QC_MIG12.g_specs_upd_count + 1;

Line 4420: P_COMMIT => FND_API.G_TRUE,

4416: P_SUBLOT_NO => l_inv_spec.sublot_no,
4417: P_WHSE_CODE => NULL,
4418: P_LOCATION => NULL,
4419: P_GET_PARENT_ONLY => 0,
4420: P_COMMIT => FND_API.G_TRUE,
4421: X_LOT_NUMBER => l_lot_number,
4422: X_PARENT_LOT_NUMBER => l_parent_lot_number,
4423: X_FAILURE_COUNT => l_failure_count
4424: );

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

4470: in_spec_lot_status_id = l_in_spec_status_id,
4471: migrated_ind = 1
4472: WHERE spec_vr_id = l_inv_spec.spec_vr_id;
4473:
4474: IF (p_commit = FND_API.G_TRUE) THEN
4475: COMMIT;
4476: END IF;
4477:
4478: GMD_QC_MIG12.g_inv_spec_upd_count := GMD_QC_MIG12.g_inv_spec_upd_count + 1;

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

4512:
4513: DELETE gmd_inventory_spec_vrs
4514: WHERE spec_vr_id = l_inv_spec.spec_vr_id;
4515:
4516: IF (p_commit = FND_API.G_TRUE) THEN
4517: COMMIT;
4518: END IF;
4519:
4520: GMD_QC_MIG12.g_inv_spec_del_count := GMD_QC_MIG12.g_inv_spec_del_count + 1;

Line 4590: P_COMMIT => FND_API.G_TRUE,

4586: P_SUBLOT_NO => l_inv_spec.sublot_no,
4587: P_WHSE_CODE => NULL,
4588: P_LOCATION => NULL,
4589: P_GET_PARENT_ONLY => 0,
4590: P_COMMIT => FND_API.G_TRUE,
4591: X_LOT_NUMBER => l_lot_number,
4592: X_PARENT_LOT_NUMBER => l_parent_lot_number,
4593: X_FAILURE_COUNT => l_failure_count
4594: );

Line 4694: P_COMMIT => FND_API.G_TRUE,

4690: P_SUBLOT_NO => l_inv_spec.sublot_no,
4691: P_WHSE_CODE => NULL,
4692: P_LOCATION => NULL,
4693: P_GET_PARENT_ONLY => 0,
4694: P_COMMIT => FND_API.G_TRUE,
4695: X_LOT_NUMBER => l_lot_number,
4696: X_PARENT_LOT_NUMBER => l_parent_lot_number,
4697: X_FAILURE_COUNT => l_failure_count
4698: );

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

4823: END LOOP; -- get_sample_org
4824:
4825: CLOSE get_sample_org;
4826:
4827: IF (p_commit = FND_API.G_TRUE) THEN
4828: COMMIT;
4829: END IF;
4830:
4831: END IF; -- clone endif

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

5214: WHERE spec_vr_id = l_wip_spec.spec_vr_id;
5215:
5216: GMD_QC_MIG12.g_wip_spec_upd_count := GMD_QC_MIG12.g_wip_spec_upd_count + 1;
5217:
5218: IF (p_commit = FND_API.G_TRUE) THEN
5219: COMMIT;
5220: END IF;
5221:
5222: ELSE -- org is null

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

5238:
5239: DELETE gmd_wip_spec_vrs
5240: WHERE spec_vr_id = l_wip_spec.spec_vr_id;
5241:
5242: IF (p_commit = FND_API.G_TRUE) THEN
5243: COMMIT;
5244: END IF;
5245:
5246: GMD_QC_MIG12.g_wip_spec_del_count := GMD_QC_MIG12.g_wip_spec_del_count + 1;

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

5625: UPDATE gmd_customer_spec_vrs
5626: SET migrated_ind = 1
5627: WHERE spec_vr_id = l_cust_spec.spec_vr_id;
5628:
5629: IF (p_commit = FND_API.G_TRUE) THEN
5630: COMMIT;
5631: END IF;
5632:
5633: GMD_QC_MIG12.g_cust_spec_upd_count := GMD_QC_MIG12.g_cust_spec_upd_count + 1;

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

5651:
5652: DELETE gmd_customer_spec_vrs
5653: WHERE spec_vr_id = l_wip_spec.spec_vr_id;
5654:
5655: IF (p_commit = FND_API.G_TRUE) THEN
5656: COMMIT;
5657: END IF;
5658:
5659: GMD_QC_MIG12.g_cust_spec_del_count := GMD_QC_MIG12.g_cust_spec_del_count + 1;

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

5842: CLOSE get_cust_sample_org; -- Bug# 5554719
5843:
5844: END IF; -- orgn code is null check
5845:
5846: IF (p_commit = FND_API.G_TRUE) THEN
5847: COMMIT;
5848: END IF;
5849:
5850: EXCEPTION

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

6003: org_id = l_supl_org_id,
6004: migrated_ind = 1
6005: WHERE spec_vr_id = l_supl_spec.spec_vr_id;
6006:
6007: IF (p_commit = FND_API.G_TRUE) THEN
6008: COMMIT;
6009: END IF;
6010:
6011: GMD_QC_MIG12.g_supl_spec_upd_count := GMD_QC_MIG12.g_supl_spec_upd_count + 1;

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

6029:
6030: DELETE gmd_supplier_spec_vrs
6031: WHERE spec_vr_id = l_supl_spec.spec_vr_id;
6032:
6033: IF (p_commit = FND_API.G_TRUE) THEN
6034: COMMIT;
6035: END IF;
6036:
6037: GMD_QC_MIG12.g_supl_spec_del_count := GMD_QC_MIG12.g_supl_spec_del_count + 1;

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

6074: org_id = l_supl_org_id,
6075: migrated_ind = 1
6076: WHERE spec_vr_id = l_supl_spec.spec_vr_id;
6077:
6078: IF (p_commit = FND_API.G_TRUE) THEN
6079: COMMIT;
6080: END IF;
6081:
6082: GMD_QC_MIG12.g_supl_spec_upd_count := GMD_QC_MIG12.g_supl_spec_upd_count + 1;

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

6226: CLOSE get_supl_sample_org;
6227:
6228: END IF; -- orgn code not null
6229:
6230: IF (p_commit = FND_API.G_TRUE) THEN
6231: COMMIT;
6232: END IF;
6233:
6234:

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

6478: locator_id = l_locator_id,
6479: migrated_ind = 1
6480: WHERE spec_vr_id = l_mon_spec.spec_vr_id;
6481:
6482: IF (p_commit = FND_API.G_TRUE) THEN
6483: COMMIT;
6484: END IF;
6485:
6486: GMD_QC_MIG12.g_mon_spec_upd_count := GMD_QC_MIG12.g_mon_spec_upd_count + 1;

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

6504:
6505: DELETE gmd_monitoring_spec_vrs
6506: WHERE spec_vr_id = l_mon_spec.spec_vr_id;
6507:
6508: IF (p_commit = FND_API.G_TRUE) THEN
6509: COMMIT;
6510: END IF;
6511:
6512: GMD_QC_MIG12.g_mon_spec_del_count := GMD_QC_MIG12.g_mon_spec_del_count + 1;

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

6546: locator_id = l_locator_id,
6547: migrated_ind = 1
6548: WHERE spec_vr_id = l_mon_spec.spec_vr_id;
6549:
6550: IF (p_commit = FND_API.G_TRUE) THEN
6551: COMMIT;
6552: END IF;
6553:
6554: GMD_QC_MIG12.g_mon_spec_upd_count := GMD_QC_MIG12.g_mon_spec_upd_count + 1;

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

6687: CLOSE get_mon_sample_org;
6688:
6689: END IF; -- orgn code null.
6690:
6691: IF (p_commit = FND_API.G_TRUE) THEN
6692: COMMIT;
6693: END IF;
6694:
6695:

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

7248: storage_locator_id = l_plan_locator_id,
7249: migrated_ind = 1
7250: WHERE storage_plan_detail_id = l_plan_det.storage_plan_detail_id;
7251:
7252: IF (p_commit = FND_API.G_TRUE) THEN
7253: COMMIT;
7254: END IF;
7255:
7256: GMD_QC_MIG12.g_store_plan_upd_count := GMD_QC_MIG12.g_store_plan_upd_count + 1;

Line 7418: P_COMMIT => FND_API.G_TRUE,

7414: P_MIGRATION_RUN_ID => p_migration_run_id,
7415: P_ITEM_ID => l_stab_rec.item_id,
7416: P_ORGANIZATION_ID => l_stab_org_id,
7417: P_MODE => NULL,
7418: P_COMMIT => FND_API.G_TRUE,
7419: X_INVENTORY_ITEM_ID => l_inventory_item_id,
7420: X_FAILURE_COUNT => l_failure_count);
7421: IF (l_failure_count > 0) THEN
7422: RAISE STAB_ODM_ITEM;

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

7430: organization_id = l_stab_org_id,
7431: migrated_ind = 1
7432: WHERE ss_id = l_stab_rec.ss_id;
7433:
7434: IF (p_commit = FND_API.G_TRUE) THEN
7435: COMMIT;
7436: END IF;
7437:
7438: GMD_QC_MIG12.g_stab_upd_count := GMD_QC_MIG12.g_stab_upd_count + 1;

Line 7594: P_COMMIT => FND_API.G_TRUE,

7590: P_ITEM_ID => l_ss_item_id,
7591: P_LOT_ID => l_matl_rec.lot_id,
7592: P_WHSE_CODE => NULL,
7593: P_LOCATION => NULL,
7594: P_COMMIT => FND_API.G_TRUE,
7595: X_LOT_NUMBER => l_lot_number,
7596: X_PARENT_LOT_NUMBER => l_parent_lot_number,
7597: X_FAILURE_COUNT => l_failure_count
7598: );

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

7621: migrated_ind = 1
7622: WHERE source_id = l_matl_rec.source_id
7623: AND ss_id = l_matl_rec.ss_id;
7624:
7625: IF (p_commit = FND_API.G_TRUE) THEN
7626: COMMIT;
7627: END IF;
7628: GMD_QC_MIG12.g_matl_source_upd_count := GMD_QC_MIG12.g_matl_source_upd_count + 1;
7629:

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

7836: migrated_ind = 1
7837: WHERE variant_id = l_var_rec.variant_id;
7838:
7839:
7840: IF (p_commit = FND_API.G_TRUE) THEN
7841: COMMIT;
7842: END IF;
7843:
7844: GMD_QC_MIG12.g_ss_variant_upd_count := GMD_QC_MIG12.g_ss_variant_upd_count + 1;

Line 8061: P_COMMIT => FND_API.G_TRUE,

8057: P_MIGRATION_RUN_ID => p_migration_run_id,
8058: P_ITEM_ID => l_store_pack.item_id,
8059: P_ORGANIZATION_ID => l_def_ss_org_id,
8060: P_MODE => NULL,
8061: P_COMMIT => FND_API.G_TRUE,
8062: X_INVENTORY_ITEM_ID => l_store_pack_invitem_id,
8063: X_FAILURE_COUNT => l_failure_count);
8064: IF (l_failure_count > 0) THEN
8065: RAISE STORE_DEF_ODM_ITEM;

Line 8101: P_COMMIT => FND_API.G_TRUE,

8097: P_MIGRATION_RUN_ID => p_migration_run_id,
8098: P_ITEM_ID => l_store_pack.item_id,
8099: P_ORGANIZATION_ID => l_ss_org_id,
8100: P_MODE => NULL,
8101: P_COMMIT => FND_API.G_TRUE,
8102: X_INVENTORY_ITEM_ID => l_store_pack_invitem_id,
8103: X_FAILURE_COUNT => l_failure_count);
8104: IF (l_failure_count > 0) THEN
8105: CLOSE get_stab_study_org;

Line 8155: P_COMMIT => FND_API.G_TRUE,

8151: P_MIGRATION_RUN_ID => p_migration_run_id,
8152: P_ITEM_ID => l_store_pack.item_id,
8153: P_ORGANIZATION_ID => l_ss_org_id,
8154: P_MODE => NULL,
8155: P_COMMIT => FND_API.G_TRUE,
8156: X_INVENTORY_ITEM_ID => l_store_pack_invitem_id,
8157: X_FAILURE_COUNT => l_failure_count);
8158: IF (l_failure_count > 0) THEN
8159: CLOSE get_stab_study_org;

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

8249:
8250: CLOSE get_stab_study_org;
8251: END IF;
8252:
8253: IF (p_commit = FND_API.G_TRUE) THEN
8254: COMMIT;
8255: END IF;
8256:
8257: EXCEPTION

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

8451: organization_id = l_hist_org_id,
8452: migrated_ind = 1
8453: WHERE storage_history_id = l_hist_rec.storage_history_id;
8454:
8455: IF (p_commit = FND_API.G_TRUE) THEN
8456: COMMIT;
8457: END IF;
8458:
8459: GMD_QC_MIG12.g_ss_storehist_upd_count := GMD_QC_MIG12.g_ss_storehist_upd_count + 1;