1: PACKAGE BODY BOM_CONFIG_EXPLOSIONS_PKG as
2: /* $Header: OEXCBCEB.pls 115.1 99/07/16 08:11:42 porting ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT VARCHAR2,
5: X_Top_Bill_Sequence_Id NUMBER,
48: X_Pricing_attribute13 VARCHAR2 DEFAULT NULL,
49: X_Pricing_attribute14 VARCHAR2 DEFAULT NULL,
50: X_Pricing_attribute15 VARCHAR2 DEFAULT NULL
51: ) IS
52: CURSOR C IS SELECT rowid FROM BOM_CONFIG_EXPLOSIONS
53: WHERE group_id = X_Group_Id
54: AND sort_order = X_Sort_Order;
55:
56: BEGIN
55:
56: BEGIN
57:
58:
59: INSERT INTO bom_config_explosions(
60: top_bill_sequence_id,
61: bill_sequence_id,
62: organization_id,
63: explosion_type,
296: X_Select_Quantity NUMBER
297:
298: ) IS
299: BEGIN
300: UPDATE bom_config_explosions
301: SET
302: select_flag = X_Select_Flag,
303: select_quantity = X_Select_Quantity
304: WHERE rowid = X_Rowid;
307: Raise NO_DATA_FOUND;
308: end if;
309: END Update_Row;
310:
311: END BOM_CONFIG_EXPLOSIONS_PKG;