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 152: l_csi_transaction_rec CSI_DATASTRUCTURES_PUB.transaction_rec;

148: l_api_version CONSTANT NUMBER := 1.0;
149: l_msg_count number;
150: l_row_id number;
151: l_ahl_mtltxn_id number;
152: l_csi_transaction_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
153: l_path_position_id NUMBER;
154: l_dummy VARCHAR2(1);
155:
156: -- Added for Post 11.5.10 Enh.

Line 1447: p_x_csi_transaction_rec in out nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,

1443: END; -- procedure get_unit_config_information
1444: ------------------------------------------
1445:
1446: Procedure create_csi_transaction_rec(
1447: p_x_csi_transaction_rec in out nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,
1448:
1449: X_Return_Status Out NOCOPY Varchar2)
1450: IS
1451:

Line 1477: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,

1473:
1474: Procedure Process_UC(
1475: p_x_parts_rec in out nocopy Ahl_Parts_Rec_type,
1476: p_module_type in Varchar2,
1477: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,
1478: X_Return_Status Out NOCOPY Varchar2,
1479: x_path_position_id Out NOCOPY Number,
1480: x_warning_msg_tbl OUT NOCOPY ahl_uc_validation_pub.error_tbl_type)
1481: IS

Line 1506: l_instance_rec csi_datastructures_pub.instance_rec;

1502: l_curr_job_qty NUMBER;
1503: l_dest_instance_id NUMBER;
1504: l_remaining_qty NUMBER;
1505:
1506: l_instance_rec csi_datastructures_pub.instance_rec;
1507:
1508: CURSOR csi_item_instance_csr(p_instance_id IN NUMBER) IS
1509: select instance_number,object_Version_number
1510: from csi_item_instances CII

Line 2108: p_x_csi_transaction_rec in out nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,

2104: END Process_UC;
2105:
2106:
2107: Procedure Process_IB(
2108: p_x_csi_transaction_rec in out nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,
2109: p_x_parts_rec in out nocopy Ahl_Parts_Rec_type,
2110: X_Return_Status Out NOCOPY Varchar2)
2111: IS
2112: --

Line 2113: l_csi_relationship_tbl CSI_DATASTRUCTURES_PUB.ii_relationship_tbl;

2109: p_x_parts_rec in out nocopy Ahl_Parts_Rec_type,
2110: X_Return_Status Out NOCOPY Varchar2)
2111: IS
2112: --
2113: l_csi_relationship_tbl CSI_DATASTRUCTURES_PUB.ii_relationship_tbl;
2114: l_csi_transaction_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
2115:
2116: l_csi_relationship_rec CSI_DATASTRUCTURES_PUB.ii_relationship_rec;
2117: l_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;

Line 2114: l_csi_transaction_rec CSI_DATASTRUCTURES_PUB.transaction_rec;

2110: X_Return_Status Out NOCOPY Varchar2)
2111: IS
2112: --
2113: l_csi_relationship_tbl CSI_DATASTRUCTURES_PUB.ii_relationship_tbl;
2114: l_csi_transaction_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
2115:
2116: l_csi_relationship_rec CSI_DATASTRUCTURES_PUB.ii_relationship_rec;
2117: l_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
2118: l_unit_config_header_name varchar2(80):= null;

Line 2116: l_csi_relationship_rec CSI_DATASTRUCTURES_PUB.ii_relationship_rec;

2112: --
2113: l_csi_relationship_tbl CSI_DATASTRUCTURES_PUB.ii_relationship_tbl;
2114: l_csi_transaction_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
2115:
2116: l_csi_relationship_rec CSI_DATASTRUCTURES_PUB.ii_relationship_rec;
2117: l_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
2118: l_unit_config_header_name varchar2(80):= null;
2119: l_msg_count number;
2120: l_msg_data varchar2(2000);

Line 2117: l_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;

2113: l_csi_relationship_tbl CSI_DATASTRUCTURES_PUB.ii_relationship_tbl;
2114: l_csi_transaction_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
2115:
2116: l_csi_relationship_rec CSI_DATASTRUCTURES_PUB.ii_relationship_rec;
2117: l_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
2118: l_unit_config_header_name varchar2(80):= null;
2119: l_msg_count number;
2120: l_msg_data varchar2(2000);
2121:

Line 2123: l_instance_rec csi_datastructures_pub.instance_rec;

2119: l_msg_count number;
2120: l_msg_data varchar2(2000);
2121:
2122: -- Parameters to call Update_Item_Instance.
2123: l_instance_rec csi_datastructures_pub.instance_rec;
2124: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2125: l_party_tbl csi_datastructures_pub.party_tbl;
2126: l_account_tbl csi_datastructures_pub.party_account_tbl;
2127:

Line 2124: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

2120: l_msg_data varchar2(2000);
2121:
2122: -- Parameters to call Update_Item_Instance.
2123: l_instance_rec csi_datastructures_pub.instance_rec;
2124: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2125: l_party_tbl csi_datastructures_pub.party_tbl;
2126: l_account_tbl csi_datastructures_pub.party_account_tbl;
2127:
2128: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 2125: l_party_tbl csi_datastructures_pub.party_tbl;

2121:
2122: -- Parameters to call Update_Item_Instance.
2123: l_instance_rec csi_datastructures_pub.instance_rec;
2124: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2125: l_party_tbl csi_datastructures_pub.party_tbl;
2126: l_account_tbl csi_datastructures_pub.party_account_tbl;
2127:
2128: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2129: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

Line 2126: l_account_tbl csi_datastructures_pub.party_account_tbl;

2122: -- Parameters to call Update_Item_Instance.
2123: l_instance_rec csi_datastructures_pub.instance_rec;
2124: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2125: l_party_tbl csi_datastructures_pub.party_tbl;
2126: l_account_tbl csi_datastructures_pub.party_account_tbl;
2127:
2128: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2129: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2130: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

Line 2128: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

2124: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2125: l_party_tbl csi_datastructures_pub.party_tbl;
2126: l_account_tbl csi_datastructures_pub.party_account_tbl;
2127:
2128: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2129: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2130: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2131:
2132: CURSOR check_inst_nonserial(p_instance_id IN NUMBER) IS

Line 2129: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

2125: l_party_tbl csi_datastructures_pub.party_tbl;
2126: l_account_tbl csi_datastructures_pub.party_account_tbl;
2127:
2128: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2129: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2130: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2131:
2132: CURSOR check_inst_nonserial(p_instance_id IN NUMBER) IS
2133: SELECT 'X'

Line 2130: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

2126: l_account_tbl csi_datastructures_pub.party_account_tbl;
2127:
2128: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2129: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2130: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2131:
2132: CURSOR check_inst_nonserial(p_instance_id IN NUMBER) IS
2133: SELECT 'X'
2134: FROM mtl_system_items_b mtl, csi_item_instances csi

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

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

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

2480: csi_ii_relationships_pub.expire_relationship(
2481: p_api_version => 1.0
2482: ,p_relationship_rec => l_csi_relationship_rec
2483: ,p_txn_rec => p_x_csi_transaction_rec
2484: ,x_instance_id_lst=> l_instance_id_lst-- csi_datastructures_pub.id_tbl,
2485: ,x_return_status => x_return_status
2486: ,x_msg_count => l_msg_count
2487: ,x_msg_data => l_msg_data );
2488: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

Line 2676: p_x_csi_transaction_rec IN out nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,

2672:
2673: END Process_IB;
2674:
2675: Procedure Update_item_location(p_x_parts_rec IN out nocopy ahl_parts_rec_type,
2676: p_x_csi_transaction_rec IN out nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,
2677:
2678: X_Return_Status Out NOCOPY Varchar2)
2679: IS
2680: --

Line 2683: l_instance_rec csi_datastructures_pub.instance_rec;

2679: IS
2680: --
2681: l_wip_entity_type number;
2682: l_wip_entity_id number;
2683: l_instance_rec csi_datastructures_pub.instance_rec;
2684: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2685: l_party_tbl csi_datastructures_pub.party_tbl;
2686: l_account_tbl csi_datastructures_pub.party_account_tbl;
2687: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 2684: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

2680: --
2681: l_wip_entity_type number;
2682: l_wip_entity_id number;
2683: l_instance_rec csi_datastructures_pub.instance_rec;
2684: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2685: l_party_tbl csi_datastructures_pub.party_tbl;
2686: l_account_tbl csi_datastructures_pub.party_account_tbl;
2687: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2688: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

Line 2685: l_party_tbl csi_datastructures_pub.party_tbl;

2681: l_wip_entity_type number;
2682: l_wip_entity_id number;
2683: l_instance_rec csi_datastructures_pub.instance_rec;
2684: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2685: l_party_tbl csi_datastructures_pub.party_tbl;
2686: l_account_tbl csi_datastructures_pub.party_account_tbl;
2687: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2688: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2689: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

Line 2686: l_account_tbl csi_datastructures_pub.party_account_tbl;

2682: l_wip_entity_id number;
2683: l_instance_rec csi_datastructures_pub.instance_rec;
2684: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2685: l_party_tbl csi_datastructures_pub.party_tbl;
2686: l_account_tbl csi_datastructures_pub.party_account_tbl;
2687: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2688: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2689: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2690: l_instance_id_lst csi_datastructures_pub.id_tbl;

Line 2687: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

2683: l_instance_rec csi_datastructures_pub.instance_rec;
2684: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2685: l_party_tbl csi_datastructures_pub.party_tbl;
2686: l_account_tbl csi_datastructures_pub.party_account_tbl;
2687: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2688: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2689: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2690: l_instance_id_lst csi_datastructures_pub.id_tbl;
2691: l_msg_count number;

Line 2688: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

2684: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2685: l_party_tbl csi_datastructures_pub.party_tbl;
2686: l_account_tbl csi_datastructures_pub.party_account_tbl;
2687: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2688: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2689: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2690: l_instance_id_lst csi_datastructures_pub.id_tbl;
2691: l_msg_count number;
2692: l_msg_data varchar2(2000);

Line 2689: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

2685: l_party_tbl csi_datastructures_pub.party_tbl;
2686: l_account_tbl csi_datastructures_pub.party_account_tbl;
2687: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2688: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2689: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2690: l_instance_id_lst csi_datastructures_pub.id_tbl;
2691: l_msg_count number;
2692: l_msg_data varchar2(2000);
2693:

Line 2690: l_instance_id_lst csi_datastructures_pub.id_tbl;

2686: l_account_tbl csi_datastructures_pub.party_account_tbl;
2687: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2688: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2689: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2690: l_instance_id_lst csi_datastructures_pub.id_tbl;
2691: l_msg_count number;
2692: l_msg_data varchar2(2000);
2693:
2694: -- For wip_entity_id for the workorder

Line 3425: l_instance_rec csi_datastructures_pub.instance_rec;

3421:
3422: l_api_name CONSTANT VARCHAR2(30) := 'move_instance_location';
3423: l_api_version CONSTANT NUMBER := 1.0;
3424:
3425: l_instance_rec csi_datastructures_pub.instance_rec;
3426: l_csi_transaction_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
3427: l_serialized VARCHAR2(1);
3428:
3429:

Line 3426: l_csi_transaction_rec CSI_DATASTRUCTURES_PUB.transaction_rec;

3422: l_api_name CONSTANT VARCHAR2(30) := 'move_instance_location';
3423: l_api_version CONSTANT NUMBER := 1.0;
3424:
3425: l_instance_rec csi_datastructures_pub.instance_rec;
3426: l_csi_transaction_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
3427: l_serialized VARCHAR2(1);
3428:
3429:
3430:

Line 3618: x_instance_rec Out NOCOPY csi_datastructures_pub.instance_rec,

3614:
3615: PROCEDURE get_dest_instance_rec(
3616: p_module_type IN VARCHAR2 Default NULL,
3617: p_move_item_instance_rec IN move_item_instance_rec_type,
3618: x_instance_rec Out NOCOPY csi_datastructures_pub.instance_rec,
3619: x_serialized Out NOCOPY Varchar2,
3620: x_Return_Status Out NOCOPY Varchar2
3621: ) IS
3622: l_api_name CONSTANT VARCHAR2(30) := 'get_dest_instance_rec';

Line 3659: l_instance_rec csi_datastructures_pub.instance_rec;

3655: AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
3656: AND ((CIR.ACTIVE_START_DATE IS NULL) OR (CIR.ACTIVE_START_DATE <= SYSDATE))
3657: AND ((CIR.ACTIVE_END_DATE IS NULL) OR (CIR.ACTIVE_END_DATE > SYSDATE)));
3658:
3659: l_instance_rec csi_datastructures_pub.instance_rec;
3660: l_from_wip_entity_id NUMBER;
3661: l_curr_wip_entity_id NUMBER;
3662: l_to_wip_entity_id NUMBER;
3663: l_serial_number VARCHAR2(30);

Line 3953: p_instance_rec IN csi_datastructures_pub.instance_rec,

3949:
3950: END get_dest_instance_rec;
3951:
3952: PROCEDURE update_csi_item_instance(
3953: p_instance_rec IN csi_datastructures_pub.instance_rec,
3954: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,
3955: X_Return_Status Out NOCOPY Varchar2
3956: ) IS
3957: l_api_name CONSTANT VARCHAR2(30) := 'update_csi_item_instance';

Line 3954: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,

3950: END get_dest_instance_rec;
3951:
3952: PROCEDURE update_csi_item_instance(
3953: p_instance_rec IN csi_datastructures_pub.instance_rec,
3954: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,
3955: X_Return_Status Out NOCOPY Varchar2
3956: ) IS
3957: l_api_name CONSTANT VARCHAR2(30) := 'update_csi_item_instance';
3958: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 3958: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

3954: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,
3955: X_Return_Status Out NOCOPY Varchar2
3956: ) IS
3957: l_api_name CONSTANT VARCHAR2(30) := 'update_csi_item_instance';
3958: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3959: l_party_tbl csi_datastructures_pub.party_tbl;
3960: l_account_tbl csi_datastructures_pub.party_account_tbl;
3961: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3962: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

Line 3959: l_party_tbl csi_datastructures_pub.party_tbl;

3955: X_Return_Status Out NOCOPY Varchar2
3956: ) IS
3957: l_api_name CONSTANT VARCHAR2(30) := 'update_csi_item_instance';
3958: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3959: l_party_tbl csi_datastructures_pub.party_tbl;
3960: l_account_tbl csi_datastructures_pub.party_account_tbl;
3961: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3962: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3963: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

Line 3960: l_account_tbl csi_datastructures_pub.party_account_tbl;

3956: ) IS
3957: l_api_name CONSTANT VARCHAR2(30) := 'update_csi_item_instance';
3958: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3959: l_party_tbl csi_datastructures_pub.party_tbl;
3960: l_account_tbl csi_datastructures_pub.party_account_tbl;
3961: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3962: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3963: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
3964: l_instance_id_lst csi_datastructures_pub.id_tbl;

Line 3961: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

3957: l_api_name CONSTANT VARCHAR2(30) := 'update_csi_item_instance';
3958: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3959: l_party_tbl csi_datastructures_pub.party_tbl;
3960: l_account_tbl csi_datastructures_pub.party_account_tbl;
3961: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3962: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3963: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
3964: l_instance_id_lst csi_datastructures_pub.id_tbl;
3965: l_msg_count number;

Line 3962: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

3958: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3959: l_party_tbl csi_datastructures_pub.party_tbl;
3960: l_account_tbl csi_datastructures_pub.party_account_tbl;
3961: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3962: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3963: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
3964: l_instance_id_lst csi_datastructures_pub.id_tbl;
3965: l_msg_count number;
3966: l_msg_data varchar2(2000);

Line 3963: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

3959: l_party_tbl csi_datastructures_pub.party_tbl;
3960: l_account_tbl csi_datastructures_pub.party_account_tbl;
3961: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3962: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3963: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
3964: l_instance_id_lst csi_datastructures_pub.id_tbl;
3965: l_msg_count number;
3966: l_msg_data varchar2(2000);
3967:

Line 3964: l_instance_id_lst csi_datastructures_pub.id_tbl;

3960: l_account_tbl csi_datastructures_pub.party_account_tbl;
3961: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3962: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3963: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
3964: l_instance_id_lst csi_datastructures_pub.id_tbl;
3965: l_msg_count number;
3966: l_msg_data varchar2(2000);
3967:
3968: --to populate csi_transaction record

Line 3973: l_instance_rec csi_datastructures_pub.instance_rec;

3969: /*CURSOR ahl_wip_location_csr IS
3970: select wip_location_id
3971: from csi_install_parameters ;*/
3972:
3973: l_instance_rec csi_datastructures_pub.instance_rec;
3974: --to find an expired instance if there
3975: /*CURSOR dest_instance_csr(p_source_instance_id IN NUMBER ) IS
3976: SELECT 'x'
3977: FROM CSI_ITEM_INSTANCES CI1, CSI_ITEM_INSTANCES CI2

Line 4085: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,

4081: PROCEDURE move_nonser_instance(
4082: p_source_instance_id IN NUMBER,
4083: p_move_quantity IN NUMBER,
4084: p_dest_wip_job_id IN NUMBER,
4085: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,
4086: X_Return_Status Out NOCOPY Varchar2
4087: ) IS
4088: l_api_name CONSTANT VARCHAR2(30) := 'move_nonser_instance';
4089:

Line 4090: l_instance_rec csi_datastructures_pub.instance_rec;

4086: X_Return_Status Out NOCOPY Varchar2
4087: ) IS
4088: l_api_name CONSTANT VARCHAR2(30) := 'move_nonser_instance';
4089:
4090: l_instance_rec csi_datastructures_pub.instance_rec;
4091: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4092: l_party_tbl csi_datastructures_pub.party_tbl;
4093: l_account_tbl csi_datastructures_pub.party_account_tbl;
4094: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 4091: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

4087: ) IS
4088: l_api_name CONSTANT VARCHAR2(30) := 'move_nonser_instance';
4089:
4090: l_instance_rec csi_datastructures_pub.instance_rec;
4091: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4092: l_party_tbl csi_datastructures_pub.party_tbl;
4093: l_account_tbl csi_datastructures_pub.party_account_tbl;
4094: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4095: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

Line 4092: l_party_tbl csi_datastructures_pub.party_tbl;

4088: l_api_name CONSTANT VARCHAR2(30) := 'move_nonser_instance';
4089:
4090: l_instance_rec csi_datastructures_pub.instance_rec;
4091: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4092: l_party_tbl csi_datastructures_pub.party_tbl;
4093: l_account_tbl csi_datastructures_pub.party_account_tbl;
4094: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4095: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4096: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

Line 4093: l_account_tbl csi_datastructures_pub.party_account_tbl;

4089:
4090: l_instance_rec csi_datastructures_pub.instance_rec;
4091: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4092: l_party_tbl csi_datastructures_pub.party_tbl;
4093: l_account_tbl csi_datastructures_pub.party_account_tbl;
4094: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4095: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4096: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4097: l_instance_id_lst csi_datastructures_pub.id_tbl;

Line 4094: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

4090: l_instance_rec csi_datastructures_pub.instance_rec;
4091: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4092: l_party_tbl csi_datastructures_pub.party_tbl;
4093: l_account_tbl csi_datastructures_pub.party_account_tbl;
4094: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4095: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4096: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4097: l_instance_id_lst csi_datastructures_pub.id_tbl;
4098: l_msg_count number;

Line 4095: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

4091: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4092: l_party_tbl csi_datastructures_pub.party_tbl;
4093: l_account_tbl csi_datastructures_pub.party_account_tbl;
4094: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4095: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4096: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4097: l_instance_id_lst csi_datastructures_pub.id_tbl;
4098: l_msg_count number;
4099: l_msg_data varchar2(2000);

Line 4096: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

4092: l_party_tbl csi_datastructures_pub.party_tbl;
4093: l_account_tbl csi_datastructures_pub.party_account_tbl;
4094: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4095: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4096: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4097: l_instance_id_lst csi_datastructures_pub.id_tbl;
4098: l_msg_count number;
4099: l_msg_data varchar2(2000);
4100:

Line 4097: l_instance_id_lst csi_datastructures_pub.id_tbl;

4093: l_account_tbl csi_datastructures_pub.party_account_tbl;
4094: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4095: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4096: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4097: l_instance_id_lst csi_datastructures_pub.id_tbl;
4098: l_msg_count number;
4099: l_msg_data varchar2(2000);
4100:
4101:

Line 4504: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,

4500: PROCEDURE create_similar_instance(
4501: p_source_instance_id IN NUMBER,
4502: p_dest_quantity IN NUMBER,
4503: p_dest_wip_job_id IN NUMBER,
4504: p_x_csi_transaction_rec In Out Nocopy CSI_DATASTRUCTURES_PUB.transaction_rec,
4505: x_dest_instance_id OUT NOCOPY NUMBER,
4506: x_return_status OUT NOCOPY VARCHAR2
4507: ) IS
4508: l_api_name CONSTANT VARCHAR2(30) := 'create_similar_instance';

Line 4509: l_source_instance_rec csi_datastructures_pub.instance_rec;

4505: x_dest_instance_id OUT NOCOPY NUMBER,
4506: x_return_status OUT NOCOPY VARCHAR2
4507: ) IS
4508: l_api_name CONSTANT VARCHAR2(30) := 'create_similar_instance';
4509: l_source_instance_rec csi_datastructures_pub.instance_rec;
4510: l_dest_instance_rec csi_datastructures_pub.instance_rec;
4511: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
4512:
4513: l_msg_count NUMBER;

Line 4510: l_dest_instance_rec csi_datastructures_pub.instance_rec;

4506: x_return_status OUT NOCOPY VARCHAR2
4507: ) IS
4508: l_api_name CONSTANT VARCHAR2(30) := 'create_similar_instance';
4509: l_source_instance_rec csi_datastructures_pub.instance_rec;
4510: l_dest_instance_rec csi_datastructures_pub.instance_rec;
4511: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
4512:
4513: l_msg_count NUMBER;
4514: l_msg_data VARCHAR2(2000);

Line 4511: l_new_instance_tbl csi_datastructures_pub.instance_tbl;

4507: ) IS
4508: l_api_name CONSTANT VARCHAR2(30) := 'create_similar_instance';
4509: l_source_instance_rec csi_datastructures_pub.instance_rec;
4510: l_dest_instance_rec csi_datastructures_pub.instance_rec;
4511: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
4512:
4513: l_msg_count NUMBER;
4514: l_msg_data VARCHAR2(2000);
4515:

Line 4823: l_instance_rec csi_datastructures_pub.instance_rec;

4819: l_debug_stmt NUMBER := FND_LOG.LEVEL_STATEMENT;
4820: l_debug_uexp NUMBER := FND_LOG.LEVEL_UNEXPECTED;
4821: l_debug_module VARCHAR2(80) := 'ahl.plsql.AHL_PRD_PARTS_CHANGE_PVT.update_part_condition';
4822:
4823: l_instance_rec csi_datastructures_pub.instance_rec;
4824: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4825: l_party_tbl csi_datastructures_pub.party_tbl;
4826: l_account_tbl csi_datastructures_pub.party_account_tbl;
4827: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 4824: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

4820: l_debug_uexp NUMBER := FND_LOG.LEVEL_UNEXPECTED;
4821: l_debug_module VARCHAR2(80) := 'ahl.plsql.AHL_PRD_PARTS_CHANGE_PVT.update_part_condition';
4822:
4823: l_instance_rec csi_datastructures_pub.instance_rec;
4824: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4825: l_party_tbl csi_datastructures_pub.party_tbl;
4826: l_account_tbl csi_datastructures_pub.party_account_tbl;
4827: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4828: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

Line 4825: l_party_tbl csi_datastructures_pub.party_tbl;

4821: l_debug_module VARCHAR2(80) := 'ahl.plsql.AHL_PRD_PARTS_CHANGE_PVT.update_part_condition';
4822:
4823: l_instance_rec csi_datastructures_pub.instance_rec;
4824: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4825: l_party_tbl csi_datastructures_pub.party_tbl;
4826: l_account_tbl csi_datastructures_pub.party_account_tbl;
4827: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4828: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4829: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

Line 4826: l_account_tbl csi_datastructures_pub.party_account_tbl;

4822:
4823: l_instance_rec csi_datastructures_pub.instance_rec;
4824: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4825: l_party_tbl csi_datastructures_pub.party_tbl;
4826: l_account_tbl csi_datastructures_pub.party_account_tbl;
4827: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4828: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4829: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4830: l_instance_id_lst csi_datastructures_pub.id_tbl;

Line 4827: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

4823: l_instance_rec csi_datastructures_pub.instance_rec;
4824: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4825: l_party_tbl csi_datastructures_pub.party_tbl;
4826: l_account_tbl csi_datastructures_pub.party_account_tbl;
4827: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4828: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4829: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4830: l_instance_id_lst csi_datastructures_pub.id_tbl;
4831: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;

Line 4828: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

4824: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4825: l_party_tbl csi_datastructures_pub.party_tbl;
4826: l_account_tbl csi_datastructures_pub.party_account_tbl;
4827: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4828: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4829: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4830: l_instance_id_lst csi_datastructures_pub.id_tbl;
4831: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
4832: l_transaction_type_id number;

Line 4829: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

4825: l_party_tbl csi_datastructures_pub.party_tbl;
4826: l_account_tbl csi_datastructures_pub.party_account_tbl;
4827: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4828: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4829: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4830: l_instance_id_lst csi_datastructures_pub.id_tbl;
4831: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
4832: l_transaction_type_id number;
4833:

Line 4830: l_instance_id_lst csi_datastructures_pub.id_tbl;

4826: l_account_tbl csi_datastructures_pub.party_account_tbl;
4827: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4828: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4829: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4830: l_instance_id_lst csi_datastructures_pub.id_tbl;
4831: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
4832: l_transaction_type_id number;
4833:
4834: l_return_val boolean;

Line 4831: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;

4827: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4828: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4829: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4830: l_instance_id_lst csi_datastructures_pub.id_tbl;
4831: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
4832: l_transaction_type_id number;
4833:
4834: l_return_val boolean;
4835: l_active_end_date date;