DBA Data[Home] [Help]

APPS.CSD_LOGISTICS_UTIL dependencies on CSD_PROCESS_PVT

Line 688: x_Product_Txn_Rec IN OUT NOCOPY Csd_Process_Pvt.Product_Txn_Rec) IS

684: /* p_UpdateProductTrxn_Rec IN user input values are stored in this record */
685: /* x_Product_Txn_Rec IN OUT database values are stored in this record*/
686: /*---------------------------------------------------------------------------*/
687: PROCEDURE Build_ProductTxnRec(p_Upd_ProdTxn_Rec IN Csd_Logistics_Pub.Upd_ProdTxn_Rec_Type,
688: x_Product_Txn_Rec IN OUT NOCOPY Csd_Process_Pvt.Product_Txn_Rec) IS
689:
690: BEGIN
691:
692: -- Action_Code

Line 1095: /* wrapper API CSD_Process_PVt.Update_Product_Txn_Wrapr and set values */

1091: /* procedure name: Set_ProductTrxnRec_Flags */
1092: /* description : */
1093: /* SU: This procedure is a helper routine to read the values from record */
1094: /* structure UpdateProductTrxn_rec, which is an input parameter for */
1095: /* wrapper API CSD_Process_PVt.Update_Product_Txn_Wrapr and set values */
1096: /* in record structure Product_Txn_Rec which is an out parameter */
1097: /* On Error: This procedure is built not to raise any exceptions, as no */
1098: /* exceptions are expected in the body. */
1099: /* Parameters Required: */

Line 1104: x_Product_Txn_Rec IN OUT NOCOPY Csd_Process_Pvt.Product_Txn_Rec) IS

1100: /* p_Upd_ProdTxn_Rec IN user input values are stored in this record */
1101: /* x_Product_Txn_Rec IN OUT database values are stored in this record*/
1102: /*---------------------------------------------------------------------------*/
1103: PROCEDURE Set_ProductTrxnRec_Flags(p_Upd_ProdTxn_Rec IN Csd_Logistics_Pub.Upd_ProdTxn_Rec_Type,
1104: x_Product_Txn_Rec IN OUT NOCOPY Csd_Process_Pvt.Product_Txn_Rec) IS
1105:
1106: -- Define Local CONSTANTS
1107: C_YES CONSTANT VARCHAR2(1) := 'Y';
1108: C_NO CONSTANT VARCHAR2(1) := 'N';

Line 1175: p_Product_Txn_Rec IN Csd_Process_Pvt.Product_Txn_Rec,

1171: /* x_msg_count OUT Standard API paramater */
1172: /* x_msg_data OUT Standard API paramater */
1173: /*---------------------------------------------------------------------------*/
1174: PROCEDURE Validate_ProductTrxnRec(p_Upd_ProdTxn_Rec IN Csd_Logistics_Pub.Upd_ProdTxn_Rec_Type,
1175: p_Product_Txn_Rec IN Csd_Process_Pvt.Product_Txn_Rec,
1176: x_return_status OUT NOCOPY VARCHAR2,
1177: x_msg_count OUT NOCOPY NUMBER,
1178: x_msg_data OUT NOCOPY VARCHAR2) IS
1179: -- Define local Variables

Line 1724: p_Product_Txn_Rec IN Csd_Process_Pvt.Product_Txn_Rec,

1720: /* x_msg_count OUT Standard API paramater */
1721: /* x_msg_data OUT Standard API paramater */
1722: /*---------------------------------------------------------------------------*/
1723: PROCEDURE Compare_ProductTrxnRec(p_Upd_ProdTxn_Rec IN Csd_Logistics_Pub.Upd_ProdTxn_Rec_Type,
1724: p_Product_Txn_Rec IN Csd_Process_Pvt.Product_Txn_Rec,
1725: x_return_status OUT NOCOPY VARCHAR2,
1726: x_msg_count OUT NOCOPY NUMBER,
1727: x_msg_data OUT NOCOPY VARCHAR2) IS
1728:

Line 2041: RETURN Csd_Process_Pvt.om_interface_rec

2037: /* Desc: Get acct, party details into order rec */
2038: /*************************************************************************/
2039:
2040: FUNCTION get_order_rec (p_repair_line_id IN NUMBER)
2041: RETURN Csd_Process_Pvt.om_interface_rec
2042: IS
2043: l_incident_id NUMBER;
2044: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.get_order_rec';
2045: x_order_rec Csd_Process_Pvt.om_interface_rec;

Line 2045: x_order_rec Csd_Process_Pvt.om_interface_rec;

2041: RETURN Csd_Process_Pvt.om_interface_rec
2042: IS
2043: l_incident_id NUMBER;
2044: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.get_order_rec';
2045: x_order_rec Csd_Process_Pvt.om_interface_rec;
2046:
2047: CURSOR cur_order_rec(p_incident_id IN NUMBER) IS
2048: SELECT customer_id, account_id
2049: FROM cs_incidents_all_b

Line 2153: p_product_txn_rec IN OUT NOCOPY Csd_Process_Pvt.PRODUCT_TXN_REC,

2149: /* x_estimate_detail_id OUT return status */
2150: /*------------------------------------------------------------------------*/
2151: PROCEDURE upd_prodtxn_n_chrgline
2152: (
2153: p_product_txn_rec IN OUT NOCOPY Csd_Process_Pvt.PRODUCT_TXN_REC,
2154: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,
2155: x_estimate_detail_id OUT NOCOPY NUMBER,
2156: x_repair_line_id OUT NOCOPY NUMBER,
2157: x_add_to_order_flag OUT NOCOPY VARCHAR2,

Line 2500: Csd_Process_Pvt.PROCESS_CHARGE_LINES(p_api_version => 1.0,

2496: l_Charges_Rec.estimate_detail_id,
2497: l_mod_name,
2498: C_STATEMENT_LEVEL);
2499:
2500: Csd_Process_Pvt.PROCESS_CHARGE_LINES(p_api_version => 1.0,
2501: p_commit => Fnd_Api.g_false,
2502: p_init_msg_list => Fnd_Api.g_false,
2503: p_validation_level => Fnd_Api.g_valid_level_full,
2504: p_action => 'UPDATE',

Line 2610: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,

2606: /*---------------------------------------------------------------------------*/
2607: PROCEDURE interface_prodtxn
2608: (
2609: x_return_status OUT NOCOPY VARCHAR2,
2610: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,
2611: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,
2612: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec
2613: ) IS
2614:

Line 2612: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec

2608: (
2609: x_return_status OUT NOCOPY VARCHAR2,
2610: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,
2611: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,
2612: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec
2613: ) IS
2614:
2615:
2616:

Line 2769: Csd_Process_Pvt.PROCESS_SALES_ORDER(p_api_version => 1.0,

2765: if (p_product_txn_rec.unit_number) is not null then
2766: FND_PROFILE.PUT('CSD_UNIT_NUMBER', p_product_txn_rec.unit_number);
2767: end if;
2768:
2769: Csd_Process_Pvt.PROCESS_SALES_ORDER(p_api_version => 1.0,
2770: p_commit => Fnd_Api.g_false,
2771: p_init_msg_list => Fnd_Api.g_true,
2772: p_validation_level => Fnd_Api.g_valid_level_full,
2773: p_action => 'CREATE',

Line 2929: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,

2925: /*------------------------------------------------------------------------*/
2926: PROCEDURE book_prodtxn
2927: (
2928: x_return_status OUT NOCOPY VARCHAR2,
2929: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,
2930: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,
2931: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec
2932:
2933: ) IS

Line 2931: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec

2927: (
2928: x_return_status OUT NOCOPY VARCHAR2,
2929: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,
2930: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,
2931: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec
2932:
2933: ) IS
2934:
2935: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.book_prodtxn';

Line 3150: Csd_Process_Pvt.PROCESS_SALES_ORDER(p_api_version => 1.0,

3146: Debug('l_order_rec.org_id' || px_order_rec.org_id,
3147: l_mod_name,
3148: 1);
3149:
3150: Csd_Process_Pvt.PROCESS_SALES_ORDER(p_api_version => 1.0,
3151: p_commit => Fnd_Api.g_false,
3152: p_init_msg_list => Fnd_Api.g_false,
3153: p_validation_level => Fnd_Api.g_valid_level_full,
3154: p_action => 'BOOK',

Line 3267: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,

3263: /*------------------------------------------------------------------------*/
3264: PROCEDURE pickrelease_prodtxn
3265: (
3266: x_return_status OUT NOCOPY VARCHAR2,
3267: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,
3268: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,
3269: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec
3270: ) IS
3271: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.pickrelease_prodtxn';

Line 3269: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec

3265: (
3266: x_return_status OUT NOCOPY VARCHAR2,
3267: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,
3268: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,
3269: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec
3270: ) IS
3271: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.pickrelease_prodtxn';
3272: l_ship_from_org_id NUMBER;
3273: l_picking_rule_id NUMBER;

Line 3525: Csd_Process_Pvt.PROCESS_SALES_ORDER(p_api_version => 1.0,

3521: IF (l_eligible_lines_pick_release > 0 ) then /*bug#5049102 call API to pick release only if there are some eligible delivery */
3522: Debug('Call process_sales_order to Release SO',
3523: l_mod_name,
3524: 1);
3525: Csd_Process_Pvt.PROCESS_SALES_ORDER(p_api_version => 1.0,
3526: p_commit => Fnd_Api.g_false,
3527: p_init_msg_list => Fnd_Api.g_false,
3528: p_validation_level => Fnd_Api.g_valid_level_full,
3529: p_action => 'PICK-RELEASE',

Line 3667: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,

3663: /*------------------------------------------------------------------------*/
3664: PROCEDURE ship_prodtxn
3665: (
3666: x_return_status OUT NOCOPY VARCHAR2,
3667: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,
3668: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,
3669: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec
3670: ) IS
3671: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.ship_prodtxn';

Line 3669: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec

3665: (
3666: x_return_status OUT NOCOPY VARCHAR2,
3667: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,
3668: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,
3669: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec
3670: ) IS
3671: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.ship_prodtxn';
3672: l_ship_from_org_id NUMBER;
3673: l_picking_rule_id NUMBER;

Line 3765: Csd_Process_Pvt.PROCESS_SALES_ORDER(p_api_version => 1.0,

3761:
3762: Debug('Call Process_sales_order to ship SO',
3763: l_mod_name,
3764: 1);
3765: Csd_Process_Pvt.PROCESS_SALES_ORDER(p_api_version => 1.0,
3766: p_commit => Fnd_Api.g_false,
3767: p_init_msg_list => Fnd_Api.g_false,
3768: p_validation_level => Fnd_Api.g_valid_level_full,
3769: p_action => 'SHIP',