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.CSD_HV_WIP_JOB_PVT dependencies on STANDARD

Line 667: standard_rate_flag,

663: autocharge_type,
664: basis_type,
665: completion_date,
666: scheduled_flag,
667: standard_rate_flag,
668: substitution_type,
669: supply_subinventory,
670: supply_locator_id, --bug8465719
671: -- swai: add columns for operations

Line 680: standard_operation_id,

676: first_unit_start_date,
677: last_unit_completion_date,
678: last_unit_start_date,
679: minimum_transfer_quantity,
680: standard_operation_id,
681: description
682: )
683: Values
684: (

Line 718: l_job_details_rec.standard_rate_flag,

714: l_job_details_rec.autocharge_type,
715: l_job_details_rec.basis_type,
716: l_job_details_rec.completion_date,
717: l_job_details_rec.scheduled_flag,
718: l_job_details_rec.standard_rate_flag,
719: l_job_details_rec.substitution_type,
720: l_job_details_rec.supply_subinventory,
721: l_job_details_rec.supply_locator_id, --bug#8465719
722: -- swai: add columns for operations

Line 731: l_job_details_rec.standard_operation_id,

727: l_job_details_rec.first_unit_start_date,
728: l_job_details_rec.last_unit_completion_date,
729: l_job_details_rec.last_unit_start_date,
730: l_job_details_rec.minimum_transfer_quantity,
731: l_job_details_rec.standard_operation_id,
732: l_job_details_rec.description
733: );
734:
735:

Line 1627: -- Standard call to check for call compatibility.

1623: END IF;
1624:
1625: SAVEPOINT PROCESS_JOB_COMP_TXN_PVT;
1626:
1627: -- Standard call to check for call compatibility.
1628: IF NOT FND_API.Compatible_API_Call(lc_api_version_number,
1629: p_api_version_number,
1630: lc_api_name,
1631: G_PKG_NAME) THEN

Line 1919: -- Standard call to check for call compatibility.

1915: END IF;
1916:
1917: SAVEPOINT INSERT_JOB_COMP_TXN_PVT;
1918:
1919: -- Standard call to check for call compatibility.
1920: IF NOT FND_API.Compatible_API_Call(lc_api_version_number,
1921: p_api_version_number,
1922: lc_api_name,
1923: G_PKG_NAME) THEN

Line 2199: -- Standard check for p_commit

2195: -- Regardless of whether or not details are needed, pass back
2196: -- the transaction header ID.
2197: x_transaction_header_id := l_transactions_interface_rec.transaction_header_id;
2198:
2199: -- Standard check for p_commit
2200: IF FND_API.to_Boolean( p_commit )
2201: THEN
2202: COMMIT WORK;
2203: END IF;

Line 2295: -- Standard call to check for call compatibility.

2291: END IF;
2292:
2293: SAVEPOINT PROCESS_MTI_TRANSACTIONS_PVT;
2294:
2295: -- Standard call to check for call compatibility.
2296: IF NOT FND_API.Compatible_API_Call(lc_api_version_number,
2297: p_api_version_number,
2298: lc_api_name,
2299: G_PKG_NAME) THEN

Line 2392: -- Standard check for p_commit

2388: p_transaction_date_end => NULL
2389: );
2390: END LOOP;
2391:
2392: -- Standard check for p_commit
2393: IF FND_API.to_Boolean( p_commit )
2394: THEN
2395: COMMIT WORK;
2396: END IF;

Line 2548: -- Standard call to check for call compatibility.

2544: 'Entering private API process_oper_comp_txn' );
2545: END IF;
2546:
2547: SAVEPOINT PROCESS_OPER_COMP_TXN_PVT;
2548: -- Standard call to check for call compatibility.
2549: IF NOT FND_API.Compatible_API_Call
2550: (lc_api_version_number,
2551: p_api_version_number,
2552: lc_api_name,

Line 2742: -- Standard check for p_commit

2738:
2739: -- END IF;
2740:
2741:
2742: -- Standard check for p_commit
2743: IF FND_API.to_Boolean( p_commit )
2744: THEN
2745: COMMIT WORK;
2746: END IF;

Line 2929: -- Standard call to check for call compatibility.

2925: 'Entering private API process_issue_mtl_txn' );
2926: END IF;
2927:
2928: SAVEPOINT PROCESS_ISSUE_MTL_TXN_PVT;
2929: -- Standard call to check for call compatibility.
2930: IF NOT FND_API.Compatible_API_Call
2931: (lc_api_version_number,
2932: p_api_version_number,
2933: lc_api_name,

Line 3473: ,p_STANDARD_OPERATION_ID => null

3469: ,p_FIRST_UNIT_START_DATE => null
3470: ,p_LAST_UNIT_COMPLETION_DATE => null
3471: ,p_LAST_UNIT_START_DATE => null
3472: ,p_MINIMUM_TRANSFER_QUANTITY => null
3473: ,p_STANDARD_OPERATION_ID => null
3474: ,p_OBJECT_VERSION_NUMBER => p_mtl_txn_dtls_tbl(mtl_ctr).object_version_number
3475: ,p_CREATE_RO_FLAG => nvl(p_mtl_txn_dtls_tbl(mtl_ctr).CREATE_RO_FLAG, FND_API.G_MISS_CHAR) -- bug#13698799 auto create ro, parent ro
3476: );
3477: /*

Line 3694: -- Standard check for p_commit

3690: END IF;
3691:
3692:
3693:
3694: -- Standard check for p_commit
3695: IF l_need_details_flag = 'F' and FND_API.to_Boolean( p_commit )
3696: THEN
3697: COMMIT WORK;
3698: END IF;

Line 3791: -- Standard call to check for call compatibility.

3787: 'Entering private API process_issue_mtl_txns_lot_srl' );
3788: END IF;
3789:
3790: SAVEPOINT PROCESS_MTL_TXNS_LOT_SRL_PVT;
3791: -- Standard call to check for call compatibility.
3792: IF NOT FND_API.Compatible_API_Call
3793: (lc_api_version_number,
3794: p_api_version_number,
3795: lc_api_name,

Line 3851: -- Standard check for p_commit

3847: FND_MSG_PUB.ADD;
3848: RAISE FND_API.G_EXC_ERROR;
3849: END IF;
3850:
3851: -- Standard check for p_commit
3852: IF FND_API.to_Boolean( p_commit )
3853: THEN
3854: COMMIT WORK;
3855: END IF;

Line 3953: -- Standard call to check for call compatibility.

3949: 'Entering private API update_mtl_txns_lot_srl' );
3950: END IF;
3951:
3952: SAVEPOINT UPDATE_MTL_TXNS_LOT_SRL_PVT;
3953: -- Standard call to check for call compatibility.
3954: IF NOT FND_API.Compatible_API_Call
3955: (lc_api_version_number,
3956: p_api_version_number,
3957: lc_api_name,

Line 4054: -- Standard check for p_commit

4050: END IF;
4051: END IF; -- end lot control condition
4052: END LOOP;
4053:
4054: -- Standard check for p_commit
4055: IF FND_API.to_Boolean( p_commit )
4056: THEN
4057: COMMIT WORK;
4058: END IF;

Line 4177: -- Standard call to check for call compatibility.

4173: 'Entering private API process_transact_res_txn' );
4174: END IF;
4175:
4176: SAVEPOINT PROCESS_TRANSACT_RES_TXN_PVT;
4177: -- Standard call to check for call compatibility.
4178: IF NOT FND_API.Compatible_API_Call
4179: (lc_api_version_number,
4180: p_api_version_number,
4181: lc_api_name,

Line 4250: l_job_details_rec.standard_rate_flag := fnd_profile.value('CSD_HV_STD_FLG');

4246: FND_MSG_PUB.ADD;
4247: RAISE FND_API.G_EXC_ERROR;
4248: end if;
4249:
4250: l_job_details_rec.standard_rate_flag := fnd_profile.value('CSD_HV_STD_FLG');
4251:
4252: -- If standard_rate_flag is null, throw an error and return;
4253:
4254: IF l_job_details_rec.standard_rate_flag is NULL THEN

Line 4252: -- If standard_rate_flag is null, throw an error and return;

4248: end if;
4249:
4250: l_job_details_rec.standard_rate_flag := fnd_profile.value('CSD_HV_STD_FLG');
4251:
4252: -- If standard_rate_flag is null, throw an error and return;
4253:
4254: IF l_job_details_rec.standard_rate_flag is NULL THEN
4255:
4256: FND_MESSAGE.SET_NAME('CSD','CSD_STD_FLG_NULL');

Line 4254: IF l_job_details_rec.standard_rate_flag is NULL THEN

4250: l_job_details_rec.standard_rate_flag := fnd_profile.value('CSD_HV_STD_FLG');
4251:
4252: -- If standard_rate_flag is null, throw an error and return;
4253:
4254: IF l_job_details_rec.standard_rate_flag is NULL THEN
4255:
4256: FND_MESSAGE.SET_NAME('CSD','CSD_STD_FLG_NULL');
4257: FND_MSG_PUB.ADD;
4258: RAISE FND_API.G_EXC_ERROR;

Line 4470: ,p_STANDARD_OPERATION_ID => null

4466: ,p_FIRST_UNIT_START_DATE => null
4467: ,p_LAST_UNIT_COMPLETION_DATE => null
4468: ,p_LAST_UNIT_START_DATE => null
4469: ,p_MINIMUM_TRANSFER_QUANTITY => null
4470: ,p_STANDARD_OPERATION_ID => null
4471: ,p_OBJECT_VERSION_NUMBER => p_res_txn_dtls_tbl(res_ctr).object_version_number
4472: ,p_CREATE_RO_FLAG => null
4473: );
4474:

Line 4566: -- Standard check for p_commit

4562:
4563: END IF;
4564:
4565:
4566: -- Standard check for p_commit
4567: IF FND_API.to_Boolean( p_commit )
4568: THEN
4569: COMMIT WORK;
4570: END IF;

Line 4655: -- Non Standard Update Discrete Job Load Type

4651:
4652: -- Constants Used for Inserting into wip_job_schedule_interface,
4653: -- These are the values needed for WIP Mass Load to pick up the records
4654:
4655: -- Non Standard Update Discrete Job Load Type
4656: lc_non_std_update_load_type CONSTANT NUMBER := 3;
4657:
4658:
4659: lc_load_mtl_type CONSTANT NUMBER := 2;

Line 4764: -- Standard Start of API savepoint

4760: lc_mod_name||'begin',
4761: 'Entering private API process_save_mtl_txn_dtls' );
4762: END IF;
4763:
4764: -- Standard Start of API savepoint
4765: SAVEPOINT PROCESS_SAVE_MTL_TXN_DTLS_PVT;
4766: -- Standard call to check for call compatibility.
4767: IF NOT FND_API.Compatible_API_Call
4768: (lc_api_version_number,

Line 4766: -- Standard call to check for call compatibility.

4762: END IF;
4763:
4764: -- Standard Start of API savepoint
4765: SAVEPOINT PROCESS_SAVE_MTL_TXN_DTLS_PVT;
4766: -- Standard call to check for call compatibility.
4767: IF NOT FND_API.Compatible_API_Call
4768: (lc_api_version_number,
4769: p_api_version_number,
4770: lc_api_name,

Line 5286: ,p_STANDARD_OPERATION_ID => null

5282: ,p_FIRST_UNIT_START_DATE => null
5283: ,p_LAST_UNIT_COMPLETION_DATE => null
5284: ,p_LAST_UNIT_START_DATE => null
5285: ,p_MINIMUM_TRANSFER_QUANTITY => null
5286: ,p_STANDARD_OPERATION_ID => null
5287: -- yvchen: bug 13258460 - 12.1.3+ add DFF attributes
5288: ,p_ATTRIBUTE_CATEGORY => p_mtl_txn_dtls_tbl(mtl_ctr).ATTRIBUTE_CATEGORY
5289: ,p_ATTRIBUTE1 => p_mtl_txn_dtls_tbl(mtl_ctr).ATTRIBUTE1
5290: ,p_ATTRIBUTE2 => p_mtl_txn_dtls_tbl(mtl_ctr).ATTRIBUTE2

Line 5341: ,p_STANDARD_OPERATION_ID => null

5337: ,p_FIRST_UNIT_START_DATE => null
5338: ,p_LAST_UNIT_COMPLETION_DATE => null
5339: ,p_LAST_UNIT_START_DATE => null
5340: ,p_MINIMUM_TRANSFER_QUANTITY => null
5341: ,p_STANDARD_OPERATION_ID => null
5342: ,p_OBJECT_VERSION_NUMBER => p_mtl_txn_dtls_tbl(mtl_ctr).object_version_number
5343: -- yvchen: bug 13258460 - 12.1.3+ add DFF attributes
5344: ,p_ATTRIBUTE_CATEGORY => nvl(p_mtl_txn_dtls_tbl(mtl_ctr).ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR)
5345: ,p_ATTRIBUTE1 => nvl(p_mtl_txn_dtls_tbl(mtl_ctr).ATTRIBUTE1, FND_API.G_MISS_CHAR)

Line 5367: -- Standard check for p_commit

5363: end if;
5364:
5365: END LOOP;
5366:
5367: -- Standard check for p_commit
5368: IF FND_API.to_Boolean( p_commit )
5369: THEN
5370: COMMIT WORK;
5371: END IF;

Line 5457: -- Non Standard Update Discrete Job Load Type

5453:
5454: -- Constants Used for Inserting into wip_job_schedule_interface,
5455: -- These are the values needed for WIP Mass Load to pick up the records
5456:
5457: -- Non Standard Update Discrete Job Load Type
5458: lc_non_std_update_load_type CONSTANT NUMBER := 3;
5459:
5460:
5461: lc_load_res_type CONSTANT NUMBER := 1;

Line 5468: -- lc_yes_standard_rate_flag CONSTANT NUMBER := 1;

5464: -- 11/7/05
5465: -- lc_manual_autocharge_type CONSTANT NUMBER := 2;
5466: -- lc_item_basis_type CONSTANT NUMBER := 1;
5467: -- lc_no_scheduled_flag CONSTANT NUMBER := 2;
5468: -- lc_yes_standard_rate_flag CONSTANT NUMBER := 1;
5469:
5470:
5471: -- Job Records to hold the Job header and details information
5472:

Line 5517: -- Standard Start of API savepoint

5513: lc_mod_name||'begin',
5514: 'Entering private API process_save_res_txn_dtls' );
5515: END IF;
5516:
5517: -- Standard Start of API savepoint
5518: SAVEPOINT PROCESS_SAVE_RES_TXN_DTLS_PVT;
5519: -- Standard call to check for call compatibility.
5520: IF NOT FND_API.Compatible_API_Call
5521: (lc_api_version_number,

Line 5519: -- Standard call to check for call compatibility.

5515: END IF;
5516:
5517: -- Standard Start of API savepoint
5518: SAVEPOINT PROCESS_SAVE_RES_TXN_DTLS_PVT;
5519: -- Standard call to check for call compatibility.
5520: IF NOT FND_API.Compatible_API_Call
5521: (lc_api_version_number,
5522: p_api_version_number,
5523: lc_api_name,

Line 5552: -- l_job_details_rec.standard_rate_flag := lc_yes_standard_rate_flag;

5548: -- l_job_details_rec.autocharge_type := lc_manual_autocharge_type;
5549: -- l_job_details_rec.basis_type := lc_item_basis_type;
5550: l_job_details_rec.completion_date := sysdate;
5551: -- l_job_details_rec.scheduled_flag := lc_no_scheduled_flag;
5552: -- l_job_details_rec.standard_rate_flag := lc_yes_standard_rate_flag;
5553:
5554:
5555:
5556: -- Populate the row who columns

Line 5750: ,p_STANDARD_OPERATION_ID => null

5746: ,p_FIRST_UNIT_START_DATE => null
5747: ,p_LAST_UNIT_COMPLETION_DATE => null
5748: ,p_LAST_UNIT_START_DATE => null
5749: ,p_MINIMUM_TRANSFER_QUANTITY => null
5750: ,p_STANDARD_OPERATION_ID => null
5751: -- swai: bug 15955754, FP of bug 14823164 - 12.1.3+ add DFF attributes
5752: ,p_ATTRIBUTE_CATEGORY => p_res_txn_dtls_tbl(res_ctr).ATTRIBUTE_CATEGORY
5753: ,p_ATTRIBUTE1 => p_res_txn_dtls_tbl(res_ctr).ATTRIBUTE1
5754: ,p_ATTRIBUTE2 => p_res_txn_dtls_tbl(res_ctr).ATTRIBUTE2

Line 5805: ,p_STANDARD_OPERATION_ID => null

5801: ,p_FIRST_UNIT_START_DATE => null
5802: ,p_LAST_UNIT_COMPLETION_DATE => null
5803: ,p_LAST_UNIT_START_DATE => null
5804: ,p_MINIMUM_TRANSFER_QUANTITY => null
5805: ,p_STANDARD_OPERATION_ID => null
5806: ,p_OBJECT_VERSION_NUMBER => p_res_txn_dtls_tbl(res_ctr).object_version_number
5807: -- swai: bug 15955754, FP of bug 14823164 - 12.1.3+ add DFF attributes
5808: ,p_ATTRIBUTE_CATEGORY => nvl(p_res_txn_dtls_tbl(res_ctr).ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR)
5809: ,p_ATTRIBUTE1 => nvl(p_res_txn_dtls_tbl(res_ctr).ATTRIBUTE1, FND_API.G_MISS_CHAR)

Line 5831: -- Standard check for p_commit

5827: end if;
5828:
5829: END LOOP;
5830:
5831: -- Standard check for p_commit
5832: IF FND_API.to_Boolean( p_commit )
5833: THEN
5834: COMMIT WORK;
5835: END IF;

Line 5915: lc_non_std_update_load_type CONSTANT NUMBER := 3; -- load type for update non standard discrete job

5911: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_wip_job_pvt.process_save_op_dtls.';
5912:
5913: -- Constants Used for Inserting into wip_job_schedule_interface,
5914: -- These are the values needed for WIP Mass Load to pick up the records
5915: lc_non_std_update_load_type CONSTANT NUMBER := 3; -- load type for update non standard discrete job
5916:
5917: -- Constants Used for Inserting into wip_job_dtls_interface
5918: lc_load_op_type CONSTANT NUMBER := 3; -- load type for operations
5919: lc_substitution_add_type CONSTANT NUMBER := 2; -- indicates add record (vs. change=3 or delete=1)

Line 5946: -- Standard Start of API savepoint

5942: lc_mod_name||'begin',
5943: 'Entering private API process_save_op_dtls' );
5944: END IF;
5945:
5946: -- Standard Start of API savepoint
5947: SAVEPOINT PROCESS_SAVE_OP_DTLS_PVT;
5948:
5949: -- Standard call to check for call compatibility.
5950: IF NOT FND_API.Compatible_API_Call

Line 5949: -- Standard call to check for call compatibility.

5945:
5946: -- Standard Start of API savepoint
5947: SAVEPOINT PROCESS_SAVE_OP_DTLS_PVT;
5948:
5949: -- Standard call to check for call compatibility.
5950: IF NOT FND_API.Compatible_API_Call
5951: (lc_api_version_number,
5952: p_api_version_number,
5953: lc_api_name,

Line 6019: l_job_details_rec.standard_operation_id := p_op_dtls_tbl(op_ctr).standard_operation_id;

6015:
6016: IF p_op_dtls_tbl(op_ctr).new_row = 'Y' THEN
6017: l_job_details_rec.substitution_type := lc_substitution_add_type;
6018: l_job_details_rec.department_id := p_op_dtls_tbl(op_ctr).department_id;
6019: l_job_details_rec.standard_operation_id := p_op_dtls_tbl(op_ctr).standard_operation_id;
6020: ELSE
6021: l_job_details_rec.substitution_type := lc_substitution_change_type;
6022: END IF;
6023:

Line 6150: ,p_STANDARD_OPERATION_ID => p_op_dtls_tbl(op_ctr).STANDARD_OPERATION_ID

6146: ,p_FIRST_UNIT_START_DATE => p_op_dtls_tbl(op_ctr).FIRST_UNIT_START_DATE
6147: ,p_LAST_UNIT_COMPLETION_DATE => p_op_dtls_tbl(op_ctr).LAST_UNIT_COMPLETION_DATE
6148: ,p_LAST_UNIT_START_DATE => p_op_dtls_tbl(op_ctr).LAST_UNIT_START_DATE
6149: ,p_MINIMUM_TRANSFER_QUANTITY => p_op_dtls_tbl(op_ctr).MINIMUM_TRANSFER_QUANTITY
6150: ,p_STANDARD_OPERATION_ID => p_op_dtls_tbl(op_ctr).STANDARD_OPERATION_ID
6151: -- yvchen: bug 13258460 - 12.1.3+ add DFF attributes
6152: ,p_ATTRIBUTE_CATEGORY => p_op_dtls_tbl(op_ctr).ATTRIBUTE_CATEGORY
6153: ,p_ATTRIBUTE1 => p_op_dtls_tbl(op_ctr).ATTRIBUTE1
6154: ,p_ATTRIBUTE2 => p_op_dtls_tbl(op_ctr).ATTRIBUTE2

Line 6204: ,p_STANDARD_OPERATION_ID => p_op_dtls_tbl(op_ctr).STANDARD_OPERATION_ID

6200: ,p_FIRST_UNIT_START_DATE => p_op_dtls_tbl(op_ctr).FIRST_UNIT_START_DATE
6201: ,p_LAST_UNIT_COMPLETION_DATE => p_op_dtls_tbl(op_ctr).LAST_UNIT_COMPLETION_DATE
6202: ,p_LAST_UNIT_START_DATE => p_op_dtls_tbl(op_ctr).LAST_UNIT_START_DATE
6203: ,p_MINIMUM_TRANSFER_QUANTITY => p_op_dtls_tbl(op_ctr).MINIMUM_TRANSFER_QUANTITY
6204: ,p_STANDARD_OPERATION_ID => p_op_dtls_tbl(op_ctr).STANDARD_OPERATION_ID
6205: ,p_OBJECT_VERSION_NUMBER => p_op_dtls_tbl(op_ctr).object_version_number
6206: -- yvchen: bug 13258460 - 12.1.3+ add DFF attributes
6207: ,p_ATTRIBUTE_CATEGORY => nvl(p_op_dtls_tbl(op_ctr).ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR)
6208: ,p_ATTRIBUTE1 => nvl(p_op_dtls_tbl(op_ctr).ATTRIBUTE1, FND_API.G_MISS_CHAR)

Line 6229: -- Standard check for p_commit

6225:
6226: end if;
6227: END LOOP;
6228:
6229: -- Standard check for p_commit
6230: IF FND_API.to_Boolean( p_commit )
6231: THEN
6232: COMMIT WORK;
6233: END IF;

Line 6320: -- Non Standard Discrete Job Load Type

6316:
6317: lc_released_status_code CONSTANT NUMBER := 3;
6318: lc_unreleased_status_code CONSTANT NUMBER := 1;
6319:
6320: -- Non Standard Discrete Job Load Type
6321: lc_non_standard_load_type CONSTANT NUMBER := 4;
6322:
6323:
6324: -- COnstants used for FND_LOG debug messages

Line 6321: lc_non_standard_load_type CONSTANT NUMBER := 4;

6317: lc_released_status_code CONSTANT NUMBER := 3;
6318: lc_unreleased_status_code CONSTANT NUMBER := 1;
6319:
6320: -- Non Standard Discrete Job Load Type
6321: lc_non_standard_load_type CONSTANT NUMBER := 4;
6322:
6323:
6324: -- COnstants used for FND_LOG debug messages
6325:

Line 6417: -- Standard Start of API savepoint

6413: lc_mod_name||'begin',
6414: 'Entering Private API create_wip_job');
6415: END IF;
6416:
6417: -- Standard Start of API savepoint
6418: SAVEPOINT CREATE_WIP_JOB_PVT;
6419: -- Standard call to check for call compatibility.
6420: IF NOT FND_API.Compatible_API_Call
6421: (lc_api_version_number,

Line 6419: -- Standard call to check for call compatibility.

6415: END IF;
6416:
6417: -- Standard Start of API savepoint
6418: SAVEPOINT CREATE_WIP_JOB_PVT;
6419: -- Standard call to check for call compatibility.
6420: IF NOT FND_API.Compatible_API_Call
6421: (lc_api_version_number,
6422: p_api_version_number,
6423: lc_api_name,

Line 6503: l_job_header_rec.load_type := lc_non_standard_load_type;

6499: l_job_header_rec.status_type := lc_unreleased_status_code;
6500: end if;
6501:
6502:
6503: l_job_header_rec.load_type := lc_non_standard_load_type;
6504:
6505:
6506:
6507: l_job_header_rec.first_unit_start_date := sysdate;

Line 6980: -- Standard check for p_commit

6976: RETURN;
6977:
6978: END IF;
6979:
6980: -- Standard check for p_commit
6981: IF FND_API.to_Boolean( p_commit )
6982: THEN
6983: COMMIT WORK;
6984: END IF;

Line 7071: -- Non Standard Discrete Job Load Type

7067: -- The Lookup Type is WIP_JOB_STATUS
7068: lc_released_status_code CONSTANT NUMBER := 3;
7069: lc_unreleased_status_code CONSTANT NUMBER := 1;
7070:
7071: -- Non Standard Discrete Job Load Type
7072: lc_non_standard_load_type CONSTANT NUMBER := 4;
7073:
7074: lc_service_code CONSTANT VARCHAR2(30) := 'SERVICE_CODE';
7075:

Line 7072: lc_non_standard_load_type CONSTANT NUMBER := 4;

7068: lc_released_status_code CONSTANT NUMBER := 3;
7069: lc_unreleased_status_code CONSTANT NUMBER := 1;
7070:
7071: -- Non Standard Discrete Job Load Type
7072: lc_non_standard_load_type CONSTANT NUMBER := 4;
7073:
7074: lc_service_code CONSTANT VARCHAR2(30) := 'SERVICE_CODE';
7075:
7076:

Line 7220: -- Standard Start of API savepoint

7216: lc_mod_name||'begin',
7217: 'Entering Private API generate_wip_jobs_from_scs');
7218: END IF;
7219:
7220: -- Standard Start of API savepoint
7221: SAVEPOINT GENERATE_WIP_JOBS_FROM_SCS_PVT;
7222: -- Standard call to check for call compatibility.
7223: IF NOT FND_API.Compatible_API_Call
7224: (lc_api_version_number,

Line 7222: -- Standard call to check for call compatibility.

7218: END IF;
7219:
7220: -- Standard Start of API savepoint
7221: SAVEPOINT GENERATE_WIP_JOBS_FROM_SCS_PVT;
7222: -- Standard call to check for call compatibility.
7223: IF NOT FND_API.Compatible_API_Call
7224: (lc_api_version_number,
7225: p_api_version_number,
7226: lc_api_name,

Line 7284: l_job_header_rec.load_type := lc_non_standard_load_type;

7280: l_job_header_rec.status_type := lc_unreleased_status_code;
7281: end if;
7282:
7283:
7284: l_job_header_rec.load_type := lc_non_standard_load_type;
7285: l_job_header_rec.first_unit_start_date := sysdate;
7286: l_job_header_rec.last_unit_completion_date := sysdate;
7287: l_job_header_rec.start_quantity := p_repair_quantity;
7288:

Line 7911: -- Standard check for p_commit

7907: p_data => x_msg_data);
7908: end if;
7909: -- swai: end bug 5239301
7910:
7911: -- Standard check for p_commit
7912: IF FND_API.to_Boolean( p_commit )
7913: THEN
7914: COMMIT WORK;
7915: END IF;

Line 8099: -- Standard call to check for call compatibility.

8095: END IF;
8096:
8097: SAVEPOINT PROCESS_AUTO_ISSUE_MTL_TXN_PVT;
8098:
8099: -- Standard call to check for call compatibility.
8100: IF NOT FND_API.Compatible_API_Call (lc_api_version_number,
8101: p_api_version_number,
8102: lc_api_name,
8103: G_PKG_NAME)

Line 8132: -- Standard check for p_commit

8128: x_transaction_header_id => x_transaction_header_id
8129: );
8130: end if;
8131:
8132: -- Standard check for p_commit
8133: IF FND_API.to_Boolean( p_commit )
8134: THEN
8135: COMMIT WORK;
8136: END IF;

Line 8321: -- Standard call to check for call compatibility.

8317: END IF;
8318:
8319: SAVEPOINT PROCESS_AUTO_TRANS_RES_TXN_PVT;
8320:
8321: -- Standard call to check for call compatibility.
8322: IF NOT FND_API.Compatible_API_Call (lc_api_version_number,
8323: p_api_version_number,
8324: lc_api_name,
8325: G_PKG_NAME)

Line 8353: -- Standard check for p_commit

8349: p_res_txn_dtls_tbl => l_res_txn_dtls_tbl
8350: );
8351: end if;
8352:
8353: -- Standard check for p_commit
8354: IF FND_API.to_Boolean( p_commit )
8355: THEN
8356: COMMIT WORK;
8357: END IF;

Line 8463: bom_standard_operations bso

8459: mfg_lookups ml,
8460: mtl_system_items_kfv msik,
8461: csd_service_codes_vl cscv,
8462: csd_wip_transaction_details WTD,
8463: bom_standard_operations bso
8464: WHERE
8465: CRJX.wip_entity_id = p_wip_entity_id AND
8466: WO.operation_seq_num = p_operation_seq_num AND
8467: CRJX.wip_entity_id = WO.wip_entity_id(+) AND

Line 8480: wo.standard_operation_id = bso.standard_operation_id(+) AND

8476: wdj.status_type <> 12 AND
8477: WO.wip_entity_id = WTD.WIP_ENTITY_ID(+) AND
8478: WO.operation_seq_num = WTD.operation_seq_num(+) AND
8479: WO.department_id = wtd.department_id(+) AND
8480: wo.standard_operation_id = bso.standard_operation_id(+) AND
8481: wo.quantity_completed <> wo.scheduled_quantity; -- only uncompleted operationss
8482:
8483: -- local variables --
8484: l_mv_txn_dtls_tbl MV_TXN_DTLS_TBL_TYPE;

Line 8496: -- Standard call to check for call compatibility.

8492: END IF;
8493:
8494: SAVEPOINT PROCESS_AUTO_OPER_COMP_TXN_PVT;
8495:
8496: -- Standard call to check for call compatibility.
8497: IF NOT FND_API.Compatible_API_Call (lc_api_version_number,
8498: p_api_version_number,
8499: lc_api_name,
8500: G_PKG_NAME)

Line 8528: -- Standard check for p_commit

8524: p_mv_txn_dtls_tbl => l_mv_txn_dtls_tbl
8525: );
8526: end if;
8527:
8528: -- Standard check for p_commit
8529: IF FND_API.to_Boolean( p_commit )
8530: THEN
8531: COMMIT WORK;
8532: END IF;

Line 8753: -- Standard call to check for call compatibility.

8749: END IF;
8750:
8751: SAVEPOINT PROCESS_TIME_CLOCK_RES_TXN_PVT;
8752:
8753: -- Standard call to check for call compatibility.
8754: IF NOT FND_API.Compatible_API_Call (lc_api_version_number,
8755: p_api_version_number,
8756: lc_api_name,
8757: G_PKG_NAME)

Line 9022: -- Standard call to check for call compatibility.

9018: END IF;
9019:
9020: SAVEPOINT PROCESS_COMP_WORK_RO_STATUS;
9021:
9022: -- Standard call to check for call compatibility.
9023: IF NOT FND_API.Compatible_API_Call (lc_api_version_number,
9024: p_api_version_number,
9025: lc_api_name,
9026: G_PKG_NAME)

Line 9077: -- Standard check for p_commit

9073: fetch c_get_repair_status
9074: into x_new_flow_status_code, x_new_ro_status_code;
9075: close c_get_repair_status;
9076:
9077: -- Standard check for p_commit
9078: IF FND_API.to_Boolean( p_commit )
9079: THEN
9080: COMMIT WORK;
9081: END IF;

Line 9170: lc_non_std_update_load_type CONSTANT NUMBER := 3; -- update non-standard job

9166: -- Constants Used for Inserting into wip_job_schedule_interface,
9167: -- These are the values needed for WIP Mass Load to pick up the records
9168:
9169: -- Constants for WIP_JOB_SCHEDULE_INTERFACE table
9170: lc_non_std_update_load_type CONSTANT NUMBER := 3; -- update non-standard job
9171:
9172: -- Constants for WIP_JOB_DTLS_INTERFACE table
9173: lc_load_mtl_type CONSTANT NUMBER := 2; -- material
9174: lc_substitution_del_type CONSTANT NUMBER := 1; -- delete

Line 9199: -- Standard Start of API savepoint

9195: lc_mod_name||'begin',
9196: 'Entering private API process_delete_mtl_txn_dtl' );
9197: END IF;
9198:
9199: -- Standard Start of API savepoint
9200: SAVEPOINT PROCESS_DELETE_MTL_TXN_DTL_PVT;
9201:
9202: -- Standard call to check for call compatibility.
9203: IF NOT FND_API.Compatible_API_Call

Line 9202: -- Standard call to check for call compatibility.

9198:
9199: -- Standard Start of API savepoint
9200: SAVEPOINT PROCESS_DELETE_MTL_TXN_DTL_PVT;
9201:
9202: -- Standard call to check for call compatibility.
9203: IF NOT FND_API.Compatible_API_Call
9204: (lc_api_version_number,
9205: p_api_version_number,
9206: lc_api_name,

Line 9356: -- Standard check for p_commit

9352: p_WIP_TRANSACTION_DETAIL_ID => l_WIP_TRANSACTION_DETAIL_ID);
9353:
9354: end if;
9355:
9356: -- Standard check for p_commit
9357: IF FND_API.to_Boolean( p_commit ) THEN
9358: COMMIT WORK;
9359: END IF;
9360:

Line 9626: -- Standard Start of API savepoint

9622: lc_mod_name||'begin',
9623: 'Entering private API process_delete_op_dtl' );
9624: END IF;
9625:
9626: -- Standard Start of API savepoint
9627: SAVEPOINT PROCESS_DELETE_op_dtl_PVT;
9628:
9629: -- Standard call to check for call compatibility.
9630: IF NOT FND_API.Compatible_API_Call

Line 9629: -- Standard call to check for call compatibility.

9625:
9626: -- Standard Start of API savepoint
9627: SAVEPOINT PROCESS_DELETE_op_dtl_PVT;
9628:
9629: -- Standard call to check for call compatibility.
9630: IF NOT FND_API.Compatible_API_Call
9631: (lc_api_version_number,
9632: p_api_version_number,
9633: lc_api_name,

Line 9749: ,p_STANDARD_OPERATION_ID => null

9745: ,p_FIRST_UNIT_START_DATE => null
9746: ,p_LAST_UNIT_COMPLETION_DATE => null
9747: ,p_LAST_UNIT_START_DATE => null
9748: ,p_MINIMUM_TRANSFER_QUANTITY => null
9749: ,p_STANDARD_OPERATION_ID => null
9750: ,p_OBJECT_VERSION_NUMBER => l_obj_ver_num + 1
9751: ,p_ATTRIBUTE_CATEGORY => null
9752: ,p_ATTRIBUTE1 => null
9753: ,p_ATTRIBUTE2 => null

Line 9786: -- Standard check for p_commit

9782: p_WIP_TRANSACTION_DETAIL_ID => wip_txn_detail_rec.WIP_TRANSACTION_DETAIL_ID);
9783:
9784: END LOOP;
9785:
9786: -- Standard check for p_commit
9787: IF FND_API.to_Boolean( p_commit ) THEN
9788: COMMIT WORK;
9789: END IF;
9790:

Line 9884: -- Standard call to check for call compatibility.

9880: THEN
9881: fnd_log.string(fnd_log.level_statement,lc_mod_name||'begin','Entering private API' );
9882: END IF;
9883:
9884: -- Standard call to check for call compatibility.
9885: IF NOT fnd_api.Compatible_API_Call
9886: (lc_api_version_number,
9887: p_api_version_number,
9888: lc_api_name,

Line 10352: -- Standard call to check for call compatibility.

10348: END IF;
10349:
10350: SAVEPOINT GENERATE_ESTIMATE_FROM_WIP;
10351:
10352: -- Standard call to check for call compatibility.
10353: IF NOT FND_API.Compatible_API_Call(lc_api_version_number,
10354: p_api_version_number,
10355: lc_api_name,
10356: G_PKG_NAME) THEN

Line 10430: -- Standard check for p_commit

10426: RAISE FND_API.G_EXC_ERROR;
10427: END IF;
10428:
10429:
10430: -- Standard check for p_commit
10431: IF FND_API.to_Boolean( p_commit )
10432: THEN
10433: COMMIT WORK;
10434: END IF;