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.CSP_MO_MTLTXNS_UTIL dependencies on CSP_MATERIAL_TRANSACTIONS_PVT

Line 375: l_csp_mtltxn_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;

371: -- for inserting data, the validation_level should be none
372: -- because we do not want to call core apps standard validations.
373: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_NONE;
374: l_move_order_line_id NUMBER;
375: l_csp_mtltxn_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
376: l_csp_mtltxn_over_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
377: l_csp_mtltxn_bak_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
378: l_csp_mtltxn_misc_issue_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
379: l_mtlt_tbl csp_pp_util.g_mtlt_tbl_type;

Line 376: l_csp_mtltxn_over_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;

372: -- because we do not want to call core apps standard validations.
373: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_NONE;
374: l_move_order_line_id NUMBER;
375: l_csp_mtltxn_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
376: l_csp_mtltxn_over_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
377: l_csp_mtltxn_bak_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
378: l_csp_mtltxn_misc_issue_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
379: l_mtlt_tbl csp_pp_util.g_mtlt_tbl_type;
380: l_msnt_tbl csp_pp_util.g_msnt_tbl_type;

Line 377: l_csp_mtltxn_bak_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;

373: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_NONE;
374: l_move_order_line_id NUMBER;
375: l_csp_mtltxn_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
376: l_csp_mtltxn_over_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
377: l_csp_mtltxn_bak_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
378: l_csp_mtltxn_misc_issue_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
379: l_mtlt_tbl csp_pp_util.g_mtlt_tbl_type;
380: l_msnt_tbl csp_pp_util.g_msnt_tbl_type;
381: l_trolin_rec INV_Move_Order_PUB.Trolin_Rec_Type;

Line 378: l_csp_mtltxn_misc_issue_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;

374: l_move_order_line_id NUMBER;
375: l_csp_mtltxn_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
376: l_csp_mtltxn_over_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
377: l_csp_mtltxn_bak_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
378: l_csp_mtltxn_misc_issue_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
379: l_mtlt_tbl csp_pp_util.g_mtlt_tbl_type;
380: l_msnt_tbl csp_pp_util.g_msnt_tbl_type;
381: l_trolin_rec INV_Move_Order_PUB.Trolin_Rec_Type;
382: l_packlist_headers_rec CSP_packlist_headers_PVT.PLH_Rec_Type;

Line 1024: CSP_Material_Transactions_PVT.Create_material_transactions(

1020: -- Messages are set in the Convert_Temp_UOM function.
1021: RAISE EXCP_USER_DEFINED;
1022: END IF;
1023:
1024: CSP_Material_Transactions_PVT.Create_material_transactions(
1025: P_Api_Version_Number => p_api_version_number,
1026: P_Init_Msg_List => p_init_msg_list,
1027: P_Commit => l_commit,
1028: p_validation_level => p_validation_level,

Line 1354: CSP_Material_Transactions_PVT.Create_material_transactions(

1350: l_csp_mtltxn_rec.transaction_temp_id := NULL;
1351: l_csp_mtltxn_rec.creation_date := sysdate;
1352: l_csp_mtltxn_rec.last_update_date := sysdate;
1353:
1354: CSP_Material_Transactions_PVT.Create_material_transactions(
1355: P_Api_Version_Number => p_api_version_number,
1356: P_Init_Msg_List => p_init_msg_list,
1357: P_Commit => l_commit,
1358: p_validation_level => p_validation_level,

Line 1383: CSP_Material_Transactions_PVT.Update_material_transactions(

1379: ELSE
1380: l_csp_mtltxn_bak_rec.primary_quantity := l_csp_mtltxn_bak_rec.transaction_quantity;
1381: END IF;
1382:
1383: CSP_Material_Transactions_PVT.Update_material_transactions(
1384: P_Api_Version_Number => p_api_version_number,
1385: P_Init_Msg_List => p_init_msg_list,
1386: P_Commit => l_commit,
1387: p_validation_level => p_validation_level,

Line 1409: CSP_Material_Transactions_PVT.Update_material_transactions(

1405:
1406: -- change the revision to the specific revision when p_reivison is not null, 05/31/00 klou.
1407: l_csp_mtltxn_rec.revision := nvl(p_revision, l_csp_mtltxn_rec.revision);
1408:
1409: CSP_Material_Transactions_PVT.Update_material_transactions(
1410: P_Api_Version_Number => p_api_version_number,
1411: P_Init_Msg_List => p_init_msg_list,
1412: P_Commit => fnd_api.g_false,
1413: p_validation_level => l_validation_level,

Line 1463: CSP_Material_Transactions_PVT.Create_material_transactions(

1459: END IF;
1460:
1461: l_csp_mtltxn_over_rec.transaction_temp_id := NULL;
1462:
1463: CSP_Material_Transactions_PVT.Create_material_transactions(
1464: P_Api_Version_Number => p_api_version_number,
1465: P_Init_Msg_List => p_init_msg_list,
1466: P_Commit => l_commit,
1467: p_validation_level => p_validation_level,

Line 1609: CSP_Material_Transactions_PVT.Update_material_transactions(

1605:
1606: -- change the revision to the specific revision when p_reivison is not null, 05/31/00 klou.
1607: l_csp_mtltxn_rec.revision := nvl(p_revision, l_csp_mtltxn_rec.revision);
1608:
1609: CSP_Material_Transactions_PVT.Update_material_transactions(
1610: P_Api_Version_Number => p_api_version_number,
1611: P_Init_Msg_List => p_init_msg_list,
1612: P_Commit => fnd_api.g_false,
1613: p_validation_level => l_validation_level,

Line 1727: CSP_Material_Transactions_PVT.Create_material_transactions(

1723: l_csp_mtltxn_rec.transfer_subinventory := p_to_subinventory_code;
1724: l_csp_mtltxn_rec.transfer_to_location := p_to_locator_id;
1725: END IF;
1726:
1727: CSP_Material_Transactions_PVT.Create_material_transactions(
1728: P_Api_Version_Number => p_api_version_number,
1729: P_Init_Msg_List => p_init_msg_list,
1730: P_Commit => l_commit,
1731: p_validation_level => p_validation_level,

Line 1754: CSP_Material_Transactions_PVT.Update_material_transactions(

1750: ELSE
1751: l_csp_mtltxn_bak_rec.primary_quantity := l_csp_mtltxn_bak_rec.transaction_quantity;
1752: END IF;
1753:
1754: CSP_Material_Transactions_PVT.Update_material_transactions(
1755: P_Api_Version_Number => p_api_version_number,
1756: P_Init_Msg_List => p_init_msg_list,
1757: P_Commit => fnd_api.g_false,
1758: p_validation_level => l_validation_level,

Line 1886: CSP_Material_Transactions_PVT.Create_material_transactions(

1882: END IF;
1883:
1884: l_csp_mtltxn_misc_issue_rec.transaction_temp_id := NULL;
1885:
1886: CSP_Material_Transactions_PVT.Create_material_transactions(
1887: P_Api_Version_Number => p_api_version_number,
1888: P_Init_Msg_List => p_init_msg_list,
1889: P_Commit => l_commit,
1890: p_validation_level => p_validation_level,

Line 1978: CSP_Material_Transactions_PVT.Update_material_transactions(

1974: ELSE
1975: l_csp_mtltxn_bak_rec.primary_quantity := l_csp_mtltxn_bak_rec.transaction_quantity;
1976: END IF;
1977:
1978: CSP_Material_Transactions_PVT.Update_material_transactions(
1979: P_Api_Version_Number => p_api_version_number,
1980: P_Init_Msg_List => p_init_msg_list,
1981: P_Commit => fnd_api.g_false,
1982: p_validation_level => l_validation_level,

Line 2216: l_csp_mtltxn_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;

2212: l_return_status VARCHAR2(1);
2213: l_mtlt_tbl csp_pp_util.g_mtlt_tbl_type;
2214: l_index NUMBER := 1;
2215: l_temp_id_to_be_processed NUMBER := p_transaction_temp_id;
2216: l_csp_mtltxn_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
2217: CURSOR l_ml_records IS
2218: SELECT
2219: TRANSACTION_HEADER_ID ,
2220: TRANSACTION_TEMP_ID ,

Line 2598: l_csp_mtltxn_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;

2594: l_transaction_header_id NUMBER := NULL;
2595: l_account_id NUMBER := NULL;
2596: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_NONE;
2597: --l_trolin_rec INV_Move_Order_PUB.Trolin_Rec_Type;
2598: l_csp_mtltxn_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
2599: EXCP_USER_DEFINED EXCEPTION;
2600: Cursor l_Get_txn_header_id_csr IS
2601: SELECT mtl_material_transactions_s.nextval
2602: FROM dual;

Line 2856: CSP_Material_Transactions_PVT.Update_material_transactions(

2852: l_trolin_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
2853: INV_Trolin_Util.Update_Row(l_trolin_rec);
2854: */
2855:
2856: CSP_Material_Transactions_PVT.Update_material_transactions(
2857: P_Api_Version_Number => l_api_version_number,
2858: P_Init_Msg_List => FND_API.G_TRUE,
2859: P_Commit => FND_API.G_FALSE,
2860: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 3519: FUNCTION Convert_Temp_UOM (p_csp_mtltxn_rec IN OUT NOCOPY CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type,

3515: , p_data => x_msg_data);
3516: x_return_status := fnd_api.g_ret_sts_error;
3517: END Transact_Serial_Lots;
3518:
3519: FUNCTION Convert_Temp_UOM (p_csp_mtltxn_rec IN OUT NOCOPY CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type,
3520: p_quantity_convert IN NUMBER)
3521: RETURN VARCHAR2
3522: -- This function calculates the primary quantity of a temp record if the transaction_uom is different
3523: -- from the item_primary_uom. It returns true if the conversion is successful. Otherwise, it