DBA Data[Home] [Help]

APPS.GMLCOPPR dependencies on OP_CHRG_ITM

Line 1281: PROCEDURE copy_charge_asc ( p_old_chargeitem_id IN OP_CHRG_ITM.CHARGEITEM_ID%TYPE ,

1277: | user defined: Procedure specific : -30050 to -30059 |
1278: | |
1279: +========================================================================*/
1280:
1281: PROCEDURE copy_charge_asc ( p_old_chargeitem_id IN OP_CHRG_ITM.CHARGEITEM_ID%TYPE ,
1282: p_charge_id IN OP_CHRG_ITM.CHARGE_ID%TYPE ,
1283: p_copy_text IN VARCHAR2 ,
1284: p_user_id IN OP_CHRG_MST.CREATED_BY%TYPE ,
1285: p_err_num OUT NOCOPY NUMBER ,

Line 1282: p_charge_id IN OP_CHRG_ITM.CHARGE_ID%TYPE ,

1278: | |
1279: +========================================================================*/
1280:
1281: PROCEDURE copy_charge_asc ( p_old_chargeitem_id IN OP_CHRG_ITM.CHARGEITEM_ID%TYPE ,
1282: p_charge_id IN OP_CHRG_ITM.CHARGE_ID%TYPE ,
1283: p_copy_text IN VARCHAR2 ,
1284: p_user_id IN OP_CHRG_MST.CREATED_BY%TYPE ,
1285: p_err_num OUT NOCOPY NUMBER ,
1286: p_err_msg OUT NOCOPY VARCHAR2

Line 1292: FROM op_chrg_itm

1288: /* Cursors */
1289:
1290: CURSOR Cur_chrg_itm IS
1291: SELECT *
1292: FROM op_chrg_itm
1293: WHERE chargeitem_id = p_old_chargeitem_id;
1294:
1295: /* Charge type */
1296: CURSOR Cur_linecharge_ind IS

Line 1305: X_chargeitem_id OP_CHRG_ITM.CHARGEITEM_ID%TYPE;

1301: /* Composites */
1302: V_chrg_itm Cur_chrg_itm%ROWTYPE ;
1303:
1304: /* Scalars */
1305: X_chargeitem_id OP_CHRG_ITM.CHARGEITEM_ID%TYPE;
1306: X_chrg_itm_text_code OP_CHRG_ITM.TEXT_CODE%TYPE ;
1307: X_linecharge_ind OP_CHRG_MST.LINECHARGE_IND%TYPE ;
1308:
1309: /* Exceptions */

Line 1306: X_chrg_itm_text_code OP_CHRG_ITM.TEXT_CODE%TYPE ;

1302: V_chrg_itm Cur_chrg_itm%ROWTYPE ;
1303:
1304: /* Scalars */
1305: X_chargeitem_id OP_CHRG_ITM.CHARGEITEM_ID%TYPE;
1306: X_chrg_itm_text_code OP_CHRG_ITM.TEXT_CODE%TYPE ;
1307: X_linecharge_ind OP_CHRG_MST.LINECHARGE_IND%TYPE ;
1308:
1309: /* Exceptions */
1310: e_charge_type_mismatch EXCEPTION ;

Line 1350: INSERT INTO OP_CHRG_ITM

1346: ELSE
1347: X_chrg_itm_text_code := NULL;
1348: END IF;
1349:
1350: INSERT INTO OP_CHRG_ITM
1351: ( chargeitem_id , charge_id ,
1352: created_by , last_updated_by ,
1353: creation_date , last_update_date ,
1354: last_update_login , delete_mark ,