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.AHL_PRD_PARTS_CHANGE_PVT dependencies on CSI_DATASTRUCTURES_PUB

Line 25: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,

21: p_x_parts_rec In Out Nocopy Ahl_Parts_Rec_type,
22: X_Return_Status Out Nocopy Varchar2);
23:
24: PROCEDURE create_csi_transaction_rec(
25: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,
26: x_return_status Out Nocopy Varchar2);
27:
28: --For UC processing
29: PROCEDURE Process_UC(

Line 32: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,

28: --For UC processing
29: PROCEDURE Process_UC(
30: p_x_parts_rec In Out Nocopy Ahl_Parts_Rec_type,
31: p_module_type In varchar2,
32: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,
33: x_return_status Out Nocopy Varchar2,
34: x_path_position_id Out NOCOPY Number,
35: x_warning_msg_tbl OUT NOCOPY ahl_uc_validation_pub.error_tbl_type);
36:

Line 39: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,

35: x_warning_msg_tbl OUT NOCOPY ahl_uc_validation_pub.error_tbl_type);
36:
37: --For IB processing
38: PROCEDURE Process_IB(
39: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,
40: p_x_parts_rec In Out Nocopy Ahl_Parts_Rec_type,
41: x_return_status Out Nocopy Varchar2);
42:
43: --For status update of a removed item after UC or IB processing

Line 46: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,

42:
43: --For status update of a removed item after UC or IB processing
44: PROCEDURE update_item_location(
45: p_x_parts_rec In Out Nocopy ahl_parts_rec_type,
46: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,
47: x_return_status Out Nocopy Varchar2);
48:
49: --For Material transaction api
50: PROCEDURE process_material_txn(

Line 84: x_instance_rec Out NOCOPY csi_datastructures_pub.instance_rec,

80: /*Validate and get the instance to be moved with ids*/
81: PROCEDURE get_dest_instance_rec(
82: p_module_type In Varchar2 Default NULL,
83: p_move_item_instance_rec IN move_item_instance_rec_type,
84: x_instance_rec Out NOCOPY csi_datastructures_pub.instance_rec,
85: x_serialized Out NOCOPY Varchar2,
86: x_Return_Status Out NOCOPY Varchar2
87: );
88: /*Change the location of item instance from one wip job to another */

Line 90: p_instance_rec IN csi_datastructures_pub.instance_rec,

86: x_Return_Status Out NOCOPY Varchar2
87: );
88: /*Change the location of item instance from one wip job to another */
89: PROCEDURE update_csi_item_instance(
90: p_instance_rec IN csi_datastructures_pub.instance_rec,
91: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,
92: X_Return_Status Out NOCOPY Varchar2
93: );
94: /*Change the location of item instance(non serialized) from one wip job to another

Line 91: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,

87: );
88: /*Change the location of item instance from one wip job to another */
89: PROCEDURE update_csi_item_instance(
90: p_instance_rec IN csi_datastructures_pub.instance_rec,
91: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,
92: X_Return_Status Out NOCOPY Varchar2
93: );
94: /*Change the location of item instance(non serialized) from one wip job to another
95: Does splitting if needed */

Line 100: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,

96: PROCEDURE move_nonser_instance(
97: p_source_instance_id IN NUMBER,
98: p_move_quantity IN NUMBER,
99: p_dest_wip_job_id IN NUMBER,
100: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,
101: X_Return_Status Out NOCOPY Varchar2
102: );
103: /*Create a new instance if needed if a non-serialized item is split
104: and if it does not exist at destination wip job*/

Line 109: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,

105: PROCEDURE create_similar_instance(
106: p_source_instance_id IN NUMBER,
107: p_dest_quantity IN NUMBER,
108: p_dest_wip_job_id IN NUMBER,
109: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,
110: x_dest_instance_id OUT NOCOPY NUMBER,
111: x_return_status OUT NOCOPY VARCHAR2
112: );
113: --------------------------------------

Line 138: l_csi_transaction_rec CSI_DATASTRUCTURES_PUB.transaction_rec;

134: l_api_version CONSTANT NUMBER := 1.0;
135: l_msg_count number;
136: l_row_id number;
137: l_ahl_mtltxn_id number;
138: l_csi_transaction_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
139: l_path_position_id NUMBER;
140:
141: -- Added for Post 11.5.10 Enh.
142: l_Issue_Mtl_Txn_id NUMBER;

Line 1414: p_x_csi_transaction_rec in out nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,

1410: END; -- procedure get_unit_config_information
1411: ------------------------------------------
1412:
1413: Procedure create_csi_transaction_rec(
1414: p_x_csi_transaction_rec in out nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,
1415:
1416: X_Return_Status Out NOCOPY Varchar2)
1417: IS
1418:

Line 1444: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,

1440:
1441: Procedure Process_UC(
1442: p_x_parts_rec in out nocopy Ahl_Parts_Rec_type,
1443: p_module_type in Varchar2,
1444: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,
1445: X_Return_Status Out NOCOPY Varchar2,
1446: x_path_position_id Out NOCOPY Number,
1447: x_warning_msg_tbl OUT NOCOPY ahl_uc_validation_pub.error_tbl_type)
1448: IS

Line 1473: l_instance_rec csi_datastructures_pub.instance_rec;

1469: l_curr_job_qty NUMBER;
1470: l_dest_instance_id NUMBER;
1471: l_remaining_qty NUMBER;
1472:
1473: l_instance_rec csi_datastructures_pub.instance_rec;
1474:
1475: CURSOR csi_item_instance_csr(p_instance_id IN NUMBER) IS
1476: select instance_number,object_Version_number
1477: from csi_item_instances CII

Line 2058: p_x_csi_transaction_rec in out nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,

2054: END Process_UC;
2055:
2056:
2057: Procedure Process_IB(
2058: p_x_csi_transaction_rec in out nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,
2059: p_x_parts_rec in out nocopy Ahl_Parts_Rec_type,
2060: X_Return_Status Out NOCOPY Varchar2)
2061: IS
2062: --

Line 2063: l_csi_relationship_tbl CSI_DATASTRUCTURES_PUB.ii_relationship_tbl;

2059: p_x_parts_rec in out nocopy Ahl_Parts_Rec_type,
2060: X_Return_Status Out NOCOPY Varchar2)
2061: IS
2062: --
2063: l_csi_relationship_tbl CSI_DATASTRUCTURES_PUB.ii_relationship_tbl;
2064: l_csi_transaction_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
2065:
2066: l_csi_relationship_rec CSI_DATASTRUCTURES_PUB.ii_relationship_rec;
2067: l_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;

Line 2064: l_csi_transaction_rec CSI_DATASTRUCTURES_PUB.transaction_rec;

2060: X_Return_Status Out NOCOPY Varchar2)
2061: IS
2062: --
2063: l_csi_relationship_tbl CSI_DATASTRUCTURES_PUB.ii_relationship_tbl;
2064: l_csi_transaction_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
2065:
2066: l_csi_relationship_rec CSI_DATASTRUCTURES_PUB.ii_relationship_rec;
2067: l_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
2068: l_unit_config_header_name varchar2(80):= null;

Line 2066: l_csi_relationship_rec CSI_DATASTRUCTURES_PUB.ii_relationship_rec;

2062: --
2063: l_csi_relationship_tbl CSI_DATASTRUCTURES_PUB.ii_relationship_tbl;
2064: l_csi_transaction_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
2065:
2066: l_csi_relationship_rec CSI_DATASTRUCTURES_PUB.ii_relationship_rec;
2067: l_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
2068: l_unit_config_header_name varchar2(80):= null;
2069: l_msg_count number;
2070: l_msg_data varchar2(2000);

Line 2067: l_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;

2063: l_csi_relationship_tbl CSI_DATASTRUCTURES_PUB.ii_relationship_tbl;
2064: l_csi_transaction_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
2065:
2066: l_csi_relationship_rec CSI_DATASTRUCTURES_PUB.ii_relationship_rec;
2067: l_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
2068: l_unit_config_header_name varchar2(80):= null;
2069: l_msg_count number;
2070: l_msg_data varchar2(2000);
2071:

Line 2073: l_instance_rec csi_datastructures_pub.instance_rec;

2069: l_msg_count number;
2070: l_msg_data varchar2(2000);
2071:
2072: -- Parameters to call Update_Item_Instance.
2073: l_instance_rec csi_datastructures_pub.instance_rec;
2074: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2075: l_party_tbl csi_datastructures_pub.party_tbl;
2076: l_account_tbl csi_datastructures_pub.party_account_tbl;
2077:

Line 2074: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

2070: l_msg_data varchar2(2000);
2071:
2072: -- Parameters to call Update_Item_Instance.
2073: l_instance_rec csi_datastructures_pub.instance_rec;
2074: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2075: l_party_tbl csi_datastructures_pub.party_tbl;
2076: l_account_tbl csi_datastructures_pub.party_account_tbl;
2077:
2078: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 2075: l_party_tbl csi_datastructures_pub.party_tbl;

2071:
2072: -- Parameters to call Update_Item_Instance.
2073: l_instance_rec csi_datastructures_pub.instance_rec;
2074: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2075: l_party_tbl csi_datastructures_pub.party_tbl;
2076: l_account_tbl csi_datastructures_pub.party_account_tbl;
2077:
2078: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2079: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

Line 2076: l_account_tbl csi_datastructures_pub.party_account_tbl;

2072: -- Parameters to call Update_Item_Instance.
2073: l_instance_rec csi_datastructures_pub.instance_rec;
2074: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2075: l_party_tbl csi_datastructures_pub.party_tbl;
2076: l_account_tbl csi_datastructures_pub.party_account_tbl;
2077:
2078: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2079: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2080: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

Line 2078: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

2074: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2075: l_party_tbl csi_datastructures_pub.party_tbl;
2076: l_account_tbl csi_datastructures_pub.party_account_tbl;
2077:
2078: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2079: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2080: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2081:
2082: CURSOR check_inst_nonserial(p_instance_id IN NUMBER) IS

Line 2079: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

2075: l_party_tbl csi_datastructures_pub.party_tbl;
2076: l_account_tbl csi_datastructures_pub.party_account_tbl;
2077:
2078: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2079: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2080: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2081:
2082: CURSOR check_inst_nonserial(p_instance_id IN NUMBER) IS
2083: SELECT 'X'

Line 2080: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

2076: l_account_tbl csi_datastructures_pub.party_account_tbl;
2077:
2078: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2079: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2080: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2081:
2082: CURSOR check_inst_nonserial(p_instance_id IN NUMBER) IS
2083: SELECT 'X'
2084: FROM mtl_system_items_b mtl, csi_item_instances csi

Line 2372: ,x_instance_id_lst=> l_instance_id_lst-- csi_datastructures_pub.id_tbl,

2368: csi_ii_relationships_pub.expire_relationship(
2369: p_api_version => 1.0
2370: ,p_relationship_rec => l_csi_relationship_rec
2371: ,p_txn_rec => p_x_csi_transaction_rec
2372: ,x_instance_id_lst=> l_instance_id_lst-- csi_datastructures_pub.id_tbl,
2373: ,x_return_status => x_return_status
2374: ,x_msg_count => l_msg_count
2375: ,x_msg_data => l_msg_data );
2376: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

Line 2427: ,x_instance_id_lst=> l_instance_id_lst-- csi_datastructures_pub.id_tbl,

2423: csi_ii_relationships_pub.expire_relationship(
2424: p_api_version => 1.0
2425: ,p_relationship_rec => l_csi_relationship_rec
2426: ,p_txn_rec => p_x_csi_transaction_rec
2427: ,x_instance_id_lst=> l_instance_id_lst-- csi_datastructures_pub.id_tbl,
2428: ,x_return_status => x_return_status
2429: ,x_msg_count => l_msg_count
2430: ,x_msg_data => l_msg_data );
2431: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

Line 2619: p_x_csi_transaction_rec IN out nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,

2615:
2616: END Process_IB;
2617:
2618: Procedure Update_item_location(p_x_parts_rec IN out nocopy ahl_parts_rec_type,
2619: p_x_csi_transaction_rec IN out nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,
2620:
2621: X_Return_Status Out NOCOPY Varchar2)
2622: IS
2623: --

Line 2626: l_instance_rec csi_datastructures_pub.instance_rec;

2622: IS
2623: --
2624: l_wip_entity_type number;
2625: l_wip_entity_id number;
2626: l_instance_rec csi_datastructures_pub.instance_rec;
2627: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2628: l_party_tbl csi_datastructures_pub.party_tbl;
2629: l_account_tbl csi_datastructures_pub.party_account_tbl;
2630: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 2627: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

2623: --
2624: l_wip_entity_type number;
2625: l_wip_entity_id number;
2626: l_instance_rec csi_datastructures_pub.instance_rec;
2627: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2628: l_party_tbl csi_datastructures_pub.party_tbl;
2629: l_account_tbl csi_datastructures_pub.party_account_tbl;
2630: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2631: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

Line 2628: l_party_tbl csi_datastructures_pub.party_tbl;

2624: l_wip_entity_type number;
2625: l_wip_entity_id number;
2626: l_instance_rec csi_datastructures_pub.instance_rec;
2627: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2628: l_party_tbl csi_datastructures_pub.party_tbl;
2629: l_account_tbl csi_datastructures_pub.party_account_tbl;
2630: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2631: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2632: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

Line 2629: l_account_tbl csi_datastructures_pub.party_account_tbl;

2625: l_wip_entity_id number;
2626: l_instance_rec csi_datastructures_pub.instance_rec;
2627: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2628: l_party_tbl csi_datastructures_pub.party_tbl;
2629: l_account_tbl csi_datastructures_pub.party_account_tbl;
2630: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2631: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2632: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2633: l_instance_id_lst csi_datastructures_pub.id_tbl;

Line 2630: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

2626: l_instance_rec csi_datastructures_pub.instance_rec;
2627: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2628: l_party_tbl csi_datastructures_pub.party_tbl;
2629: l_account_tbl csi_datastructures_pub.party_account_tbl;
2630: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2631: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2632: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2633: l_instance_id_lst csi_datastructures_pub.id_tbl;
2634: l_msg_count number;

Line 2631: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

2627: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2628: l_party_tbl csi_datastructures_pub.party_tbl;
2629: l_account_tbl csi_datastructures_pub.party_account_tbl;
2630: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2631: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2632: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2633: l_instance_id_lst csi_datastructures_pub.id_tbl;
2634: l_msg_count number;
2635: l_msg_data varchar2(2000);

Line 2632: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

2628: l_party_tbl csi_datastructures_pub.party_tbl;
2629: l_account_tbl csi_datastructures_pub.party_account_tbl;
2630: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2631: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2632: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2633: l_instance_id_lst csi_datastructures_pub.id_tbl;
2634: l_msg_count number;
2635: l_msg_data varchar2(2000);
2636:

Line 2633: l_instance_id_lst csi_datastructures_pub.id_tbl;

2629: l_account_tbl csi_datastructures_pub.party_account_tbl;
2630: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2631: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2632: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2633: l_instance_id_lst csi_datastructures_pub.id_tbl;
2634: l_msg_count number;
2635: l_msg_data varchar2(2000);
2636:
2637: -- For wip_entity_id for the workorder

Line 3368: l_instance_rec csi_datastructures_pub.instance_rec;

3364:
3365: l_api_name CONSTANT VARCHAR2(30) := 'move_instance_location';
3366: l_api_version CONSTANT NUMBER := 1.0;
3367:
3368: l_instance_rec csi_datastructures_pub.instance_rec;
3369: l_csi_transaction_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
3370: l_serialized VARCHAR2(1);
3371:
3372:

Line 3369: l_csi_transaction_rec CSI_DATASTRUCTURES_PUB.transaction_rec;

3365: l_api_name CONSTANT VARCHAR2(30) := 'move_instance_location';
3366: l_api_version CONSTANT NUMBER := 1.0;
3367:
3368: l_instance_rec csi_datastructures_pub.instance_rec;
3369: l_csi_transaction_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
3370: l_serialized VARCHAR2(1);
3371:
3372:
3373:

Line 3561: x_instance_rec Out NOCOPY csi_datastructures_pub.instance_rec,

3557:
3558: PROCEDURE get_dest_instance_rec(
3559: p_module_type IN VARCHAR2 Default NULL,
3560: p_move_item_instance_rec IN move_item_instance_rec_type,
3561: x_instance_rec Out NOCOPY csi_datastructures_pub.instance_rec,
3562: x_serialized Out NOCOPY Varchar2,
3563: x_Return_Status Out NOCOPY Varchar2
3564: ) IS
3565: l_api_name CONSTANT VARCHAR2(30) := 'get_dest_instance_rec';

Line 3602: l_instance_rec csi_datastructures_pub.instance_rec;

3598: AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
3599: AND ((CIR.ACTIVE_START_DATE IS NULL) OR (CIR.ACTIVE_START_DATE <= SYSDATE))
3600: AND ((CIR.ACTIVE_END_DATE IS NULL) OR (CIR.ACTIVE_END_DATE > SYSDATE)));
3601:
3602: l_instance_rec csi_datastructures_pub.instance_rec;
3603: l_from_wip_entity_id NUMBER;
3604: l_curr_wip_entity_id NUMBER;
3605: l_to_wip_entity_id NUMBER;
3606: l_serial_number VARCHAR2(30);

Line 3896: p_instance_rec IN csi_datastructures_pub.instance_rec,

3892:
3893: END get_dest_instance_rec;
3894:
3895: PROCEDURE update_csi_item_instance(
3896: p_instance_rec IN csi_datastructures_pub.instance_rec,
3897: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,
3898: X_Return_Status Out NOCOPY Varchar2
3899: ) IS
3900: l_api_name CONSTANT VARCHAR2(30) := 'update_csi_item_instance';

Line 3897: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,

3893: END get_dest_instance_rec;
3894:
3895: PROCEDURE update_csi_item_instance(
3896: p_instance_rec IN csi_datastructures_pub.instance_rec,
3897: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,
3898: X_Return_Status Out NOCOPY Varchar2
3899: ) IS
3900: l_api_name CONSTANT VARCHAR2(30) := 'update_csi_item_instance';
3901: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 3901: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

3897: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,
3898: X_Return_Status Out NOCOPY Varchar2
3899: ) IS
3900: l_api_name CONSTANT VARCHAR2(30) := 'update_csi_item_instance';
3901: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3902: l_party_tbl csi_datastructures_pub.party_tbl;
3903: l_account_tbl csi_datastructures_pub.party_account_tbl;
3904: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3905: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

Line 3902: l_party_tbl csi_datastructures_pub.party_tbl;

3898: X_Return_Status Out NOCOPY Varchar2
3899: ) IS
3900: l_api_name CONSTANT VARCHAR2(30) := 'update_csi_item_instance';
3901: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3902: l_party_tbl csi_datastructures_pub.party_tbl;
3903: l_account_tbl csi_datastructures_pub.party_account_tbl;
3904: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3905: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3906: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

Line 3903: l_account_tbl csi_datastructures_pub.party_account_tbl;

3899: ) IS
3900: l_api_name CONSTANT VARCHAR2(30) := 'update_csi_item_instance';
3901: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3902: l_party_tbl csi_datastructures_pub.party_tbl;
3903: l_account_tbl csi_datastructures_pub.party_account_tbl;
3904: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3905: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3906: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
3907: l_instance_id_lst csi_datastructures_pub.id_tbl;

Line 3904: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

3900: l_api_name CONSTANT VARCHAR2(30) := 'update_csi_item_instance';
3901: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3902: l_party_tbl csi_datastructures_pub.party_tbl;
3903: l_account_tbl csi_datastructures_pub.party_account_tbl;
3904: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3905: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3906: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
3907: l_instance_id_lst csi_datastructures_pub.id_tbl;
3908: l_msg_count number;

Line 3905: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

3901: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3902: l_party_tbl csi_datastructures_pub.party_tbl;
3903: l_account_tbl csi_datastructures_pub.party_account_tbl;
3904: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3905: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3906: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
3907: l_instance_id_lst csi_datastructures_pub.id_tbl;
3908: l_msg_count number;
3909: l_msg_data varchar2(2000);

Line 3906: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

3902: l_party_tbl csi_datastructures_pub.party_tbl;
3903: l_account_tbl csi_datastructures_pub.party_account_tbl;
3904: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3905: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3906: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
3907: l_instance_id_lst csi_datastructures_pub.id_tbl;
3908: l_msg_count number;
3909: l_msg_data varchar2(2000);
3910:

Line 3907: l_instance_id_lst csi_datastructures_pub.id_tbl;

3903: l_account_tbl csi_datastructures_pub.party_account_tbl;
3904: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3905: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3906: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
3907: l_instance_id_lst csi_datastructures_pub.id_tbl;
3908: l_msg_count number;
3909: l_msg_data varchar2(2000);
3910:
3911: --to populate csi_transaction record

Line 3916: l_instance_rec csi_datastructures_pub.instance_rec;

3912: /*CURSOR ahl_wip_location_csr IS
3913: select wip_location_id
3914: from csi_install_parameters ;*/
3915:
3916: l_instance_rec csi_datastructures_pub.instance_rec;
3917: --to find an expired instance if there
3918: /*CURSOR dest_instance_csr(p_source_instance_id IN NUMBER ) IS
3919: SELECT 'x'
3920: FROM CSI_ITEM_INSTANCES CI1, CSI_ITEM_INSTANCES CI2

Line 4028: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,

4024: PROCEDURE move_nonser_instance(
4025: p_source_instance_id IN NUMBER,
4026: p_move_quantity IN NUMBER,
4027: p_dest_wip_job_id IN NUMBER,
4028: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,
4029: X_Return_Status Out NOCOPY Varchar2
4030: ) IS
4031: l_api_name CONSTANT VARCHAR2(30) := 'move_nonser_instance';
4032:

Line 4033: l_instance_rec csi_datastructures_pub.instance_rec;

4029: X_Return_Status Out NOCOPY Varchar2
4030: ) IS
4031: l_api_name CONSTANT VARCHAR2(30) := 'move_nonser_instance';
4032:
4033: l_instance_rec csi_datastructures_pub.instance_rec;
4034: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4035: l_party_tbl csi_datastructures_pub.party_tbl;
4036: l_account_tbl csi_datastructures_pub.party_account_tbl;
4037: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 4034: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

4030: ) IS
4031: l_api_name CONSTANT VARCHAR2(30) := 'move_nonser_instance';
4032:
4033: l_instance_rec csi_datastructures_pub.instance_rec;
4034: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4035: l_party_tbl csi_datastructures_pub.party_tbl;
4036: l_account_tbl csi_datastructures_pub.party_account_tbl;
4037: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4038: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

Line 4035: l_party_tbl csi_datastructures_pub.party_tbl;

4031: l_api_name CONSTANT VARCHAR2(30) := 'move_nonser_instance';
4032:
4033: l_instance_rec csi_datastructures_pub.instance_rec;
4034: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4035: l_party_tbl csi_datastructures_pub.party_tbl;
4036: l_account_tbl csi_datastructures_pub.party_account_tbl;
4037: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4038: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4039: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

Line 4036: l_account_tbl csi_datastructures_pub.party_account_tbl;

4032:
4033: l_instance_rec csi_datastructures_pub.instance_rec;
4034: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4035: l_party_tbl csi_datastructures_pub.party_tbl;
4036: l_account_tbl csi_datastructures_pub.party_account_tbl;
4037: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4038: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4039: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4040: l_instance_id_lst csi_datastructures_pub.id_tbl;

Line 4037: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

4033: l_instance_rec csi_datastructures_pub.instance_rec;
4034: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4035: l_party_tbl csi_datastructures_pub.party_tbl;
4036: l_account_tbl csi_datastructures_pub.party_account_tbl;
4037: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4038: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4039: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4040: l_instance_id_lst csi_datastructures_pub.id_tbl;
4041: l_msg_count number;

Line 4038: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

4034: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4035: l_party_tbl csi_datastructures_pub.party_tbl;
4036: l_account_tbl csi_datastructures_pub.party_account_tbl;
4037: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4038: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4039: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4040: l_instance_id_lst csi_datastructures_pub.id_tbl;
4041: l_msg_count number;
4042: l_msg_data varchar2(2000);

Line 4039: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

4035: l_party_tbl csi_datastructures_pub.party_tbl;
4036: l_account_tbl csi_datastructures_pub.party_account_tbl;
4037: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4038: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4039: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4040: l_instance_id_lst csi_datastructures_pub.id_tbl;
4041: l_msg_count number;
4042: l_msg_data varchar2(2000);
4043:

Line 4040: l_instance_id_lst csi_datastructures_pub.id_tbl;

4036: l_account_tbl csi_datastructures_pub.party_account_tbl;
4037: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4038: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4039: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4040: l_instance_id_lst csi_datastructures_pub.id_tbl;
4041: l_msg_count number;
4042: l_msg_data varchar2(2000);
4043:
4044:

Line 4447: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,

4443: PROCEDURE create_similar_instance(
4444: p_source_instance_id IN NUMBER,
4445: p_dest_quantity IN NUMBER,
4446: p_dest_wip_job_id IN NUMBER,
4447: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,
4448: x_dest_instance_id OUT NOCOPY NUMBER,
4449: x_return_status OUT NOCOPY VARCHAR2
4450: ) IS
4451: l_api_name CONSTANT VARCHAR2(30) := 'create_similar_instance';

Line 4452: l_source_instance_rec csi_datastructures_pub.instance_rec;

4448: x_dest_instance_id OUT NOCOPY NUMBER,
4449: x_return_status OUT NOCOPY VARCHAR2
4450: ) IS
4451: l_api_name CONSTANT VARCHAR2(30) := 'create_similar_instance';
4452: l_source_instance_rec csi_datastructures_pub.instance_rec;
4453: l_dest_instance_rec csi_datastructures_pub.instance_rec;
4454: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
4455:
4456: l_msg_count NUMBER;

Line 4453: l_dest_instance_rec csi_datastructures_pub.instance_rec;

4449: x_return_status OUT NOCOPY VARCHAR2
4450: ) IS
4451: l_api_name CONSTANT VARCHAR2(30) := 'create_similar_instance';
4452: l_source_instance_rec csi_datastructures_pub.instance_rec;
4453: l_dest_instance_rec csi_datastructures_pub.instance_rec;
4454: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
4455:
4456: l_msg_count NUMBER;
4457: l_msg_data VARCHAR2(2000);

Line 4454: l_new_instance_tbl csi_datastructures_pub.instance_tbl;

4450: ) IS
4451: l_api_name CONSTANT VARCHAR2(30) := 'create_similar_instance';
4452: l_source_instance_rec csi_datastructures_pub.instance_rec;
4453: l_dest_instance_rec csi_datastructures_pub.instance_rec;
4454: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
4455:
4456: l_msg_count NUMBER;
4457: l_msg_data VARCHAR2(2000);
4458: