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 2936: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,

2932: /*------------------------------------------------------------------------*/
2933: PROCEDURE book_prodtxn
2934: (
2935: x_return_status OUT NOCOPY VARCHAR2,
2936: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,
2937: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,
2938: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec
2939:
2940: ) IS

Line 2938: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec

2934: (
2935: x_return_status OUT NOCOPY VARCHAR2,
2936: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,
2937: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,
2938: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec
2939:
2940: ) IS
2941:
2942: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.book_prodtxn';

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

3160: Debug('l_order_rec.org_id' || px_order_rec.org_id,
3161: l_mod_name,
3162: 1);
3163:
3164: Csd_Process_Pvt.PROCESS_SALES_ORDER(p_api_version => 1.0,
3165: p_commit => Fnd_Api.g_false,
3166: p_init_msg_list => Fnd_Api.g_false,
3167: p_validation_level => Fnd_Api.g_valid_level_full,
3168: p_action => 'BOOK',

Line 3281: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,

3277: /*------------------------------------------------------------------------*/
3278: PROCEDURE pickrelease_prodtxn
3279: (
3280: x_return_status OUT NOCOPY VARCHAR2,
3281: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,
3282: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,
3283: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec
3284: ) IS
3285: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.pickrelease_prodtxn';

Line 3283: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec

3279: (
3280: x_return_status OUT NOCOPY VARCHAR2,
3281: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,
3282: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,
3283: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec
3284: ) IS
3285: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.pickrelease_prodtxn';
3286: l_ship_from_org_id NUMBER;
3287: l_picking_rule_id NUMBER;

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

3535: IF (l_eligible_lines_pick_release > 0 ) then /*bug#5049102 call API to pick release only if there are some eligible delivery */
3536: Debug('Call process_sales_order to Release SO',
3537: l_mod_name,
3538: 1);
3539: Csd_Process_Pvt.PROCESS_SALES_ORDER(p_api_version => 1.0,
3540: p_commit => Fnd_Api.g_false,
3541: p_init_msg_list => Fnd_Api.g_false,
3542: p_validation_level => Fnd_Api.g_valid_level_full,
3543: p_action => 'PICK-RELEASE',

Line 3681: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,

3677: /*------------------------------------------------------------------------*/
3678: PROCEDURE ship_prodtxn
3679: (
3680: x_return_status OUT NOCOPY VARCHAR2,
3681: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,
3682: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,
3683: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec
3684: ) IS
3685: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.ship_prodtxn';

Line 3683: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec

3679: (
3680: x_return_status OUT NOCOPY VARCHAR2,
3681: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,
3682: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,
3683: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec
3684: ) IS
3685: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.ship_prodtxn';
3686: l_ship_from_org_id NUMBER;
3687: l_picking_rule_id NUMBER;

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

3775:
3776: Debug('Call Process_sales_order to ship SO',
3777: l_mod_name,
3778: 1);
3779: Csd_Process_Pvt.PROCESS_SALES_ORDER(p_api_version => 1.0,
3780: p_commit => Fnd_Api.g_false,
3781: p_init_msg_list => Fnd_Api.g_false,
3782: p_validation_level => Fnd_Api.g_valid_level_full,
3783: p_action => 'SHIP',