APPS.QP_PRICE_FORMULA_UPG_UTIL_PVT dependencies on QP_PRICE_FORMULA_UPG_UTIL_PVT

Line 1: PACKAGE BODY QP_PRICE_FORMULA_UPG_UTIL_PVT AS

1: PACKAGE BODY QP_PRICE_FORMULA_UPG_UTIL_PVT AS
2: /* $Header: QPXVUPFB.pls 120.2 2006/03/21 11:15:55 rnayani noship $ */
3:
4: /***********************************************************************
5: Type Definition for a table of varchar2 to hold multiple contexts

Line 669: QP_PRICE_FORMULA_UPG_UTIL_PVT.Insert_List_Header(

665: SELECT QP_LIST_HEADERS_B_S.nextval
666: INTO l_list_header_id
667: FROM DUAL;
668:
669: QP_PRICE_FORMULA_UPG_UTIL_PVT.Insert_List_Header(
670: l_list_header_id,
671: l_comp_rec.creation_date,
672: l_comp_rec.created_by,
673: l_comp_rec.last_update_date,

Line 708: QP_PRICE_FORMULA_UPG_UTIL_PVT.Insert_List_Line(

704: SELECT QP_LIST_LINES_S.nextval
705: INTO l_list_line_id
706: FROM DUAL;
707:
708: QP_PRICE_FORMULA_UPG_UTIL_PVT.Insert_List_Line(
709: l_list_line_id,
710: l_comp_rec.creation_date,
711: l_comp_rec.created_by,
712: l_comp_rec.last_update_date,

Line 736: QP_PRICE_FORMULA_UPG_UTIL_PVT.Insert_Pricing_Attribute(

732: null, null, null, null, null,
733: null, null, null, null, null,
734: null, null, null, null, null );
735:
736: QP_PRICE_FORMULA_UPG_UTIL_PVT.Insert_Pricing_Attribute(
737: nvl(l_comp_rec.creation_date,sysdate), nvl(l_comp_rec.created_by, -1),
738: nvl(l_comp_rec.last_update_date,sysdate), nvl(l_comp_rec.last_updated_by,-1),
739: nvl(l_comp_rec.last_update_login,-1), l_list_line_id, 'N', 'N',
740: null, null, null, null, 'C', '=');

Line 1157: QP_PRICE_FORMULA_UPG_UTIL_PVT.Insert_Price_Formula(

1153: END;
1154:
1155: IF l_exists IS NULL THEN -- Formula Id does not already exist
1156:
1157: QP_PRICE_FORMULA_UPG_UTIL_PVT.Insert_Price_Formula(
1158: l_rec.pricing_rule_id, --price_formula_id
1159: l_rec.creation_date,
1160: l_rec.created_by,
1161: l_rec.last_update_date,

Line 1293: QP_PRICE_FORMULA_UPG_UTIL_PVT.Insert_List_Header(

1289: --dbms_output.put_line(l_lines_rec.pricing_rule_id);
1290: --dbms_output.put_line(l_lines_rec.step_number);
1291:
1292:
1293: QP_PRICE_FORMULA_UPG_UTIL_PVT.Insert_List_Header(
1294: l_list_header_id,
1295: l_value_rec.c_creation_date,
1296: l_value_rec.c_created_by,
1297: l_value_rec.c_last_update_date,

Line 1333: QP_PRICE_FORMULA_UPG_UTIL_PVT.Insert_List_Line(

1329: SELECT QP_LIST_LINES_S.nextval
1330: INTO l_list_line_id
1331: FROM DUAL;
1332:
1333: QP_PRICE_FORMULA_UPG_UTIL_PVT.Insert_List_Line(
1334: l_list_line_id,
1335: nvl(l_value_rec.creation_date,sysdate),
1336: nvl(l_value_rec.created_by,-1),
1337: nvl(l_value_rec.last_update_date, sysdate),

Line 1380: QP_PRICE_FORMULA_UPG_UTIL_PVT.Insert_Pricing_Attribute(

1376: attribute_flag => x_attribute_flag,
1377: value_flag => x_value_flag, datatype => x_datatype,
1378: precedence => x_precedence, error_code => x_error_code);
1379:
1380: QP_PRICE_FORMULA_UPG_UTIL_PVT.Insert_Pricing_Attribute(
1381: nvl(l_value_rec.creation_date,sysdate), nvl(l_value_rec.created_by, -1),
1382: nvl(l_value_rec.last_update_date,sysdate), nvl(l_value_rec.last_updated_by,-1),
1383: nvl(l_value_rec.last_update_login,-1), l_list_line_id, 'N', 'N',
1384: l_context1, l_attribute1, l_attr_value, null,

Line 1404: QP_PRICE_FORMULA_UPG_UTIL_PVT.Insert_Pricing_Attribute(

1400: attribute_flag => x_attribute_flag,
1401: value_flag => x_value_flag, datatype => x_datatype,
1402: precedence => x_precedence, error_code => x_error_code);
1403:
1404: QP_PRICE_FORMULA_UPG_UTIL_PVT.Insert_Pricing_Attribute(
1405: nvl(l_value_rec.creation_date,sysdate), nvl(l_value_rec.created_by, -1),
1406: nvl(l_value_rec.last_update_date,sysdate), nvl(l_value_rec.last_updated_by,-1),
1407: nvl(l_value_rec.last_update_login,-1), l_list_line_id, 'N', 'N',
1408: l_context2, l_attribute2, l_attr_value, null,

Line 1428: QP_PRICE_FORMULA_UPG_UTIL_PVT.Insert_Pricing_Attribute(

1424: attribute_flag => x_attribute_flag,
1425: value_flag => x_value_flag, datatype => x_datatype,
1426: precedence => x_precedence, error_code => x_error_code);
1427:
1428: QP_PRICE_FORMULA_UPG_UTIL_PVT.Insert_Pricing_Attribute(
1429: nvl(l_value_rec.creation_date,sysdate), nvl(l_value_rec.created_by, -1),
1430: nvl(l_value_rec.last_update_date,sysdate), nvl(l_value_rec.last_updated_by,-1),
1431: nvl(l_value_rec.last_update_login,-1), l_list_line_id, 'N', 'N',
1432: l_context3, l_attribute3, l_attr_value, null,

Line 1452: QP_PRICE_FORMULA_UPG_UTIL_PVT.Insert_Pricing_Attribute(

1448: attribute_flag => x_attribute_flag,
1449: value_flag => x_value_flag, datatype => x_datatype,
1450: precedence => x_precedence, error_code => x_error_code);
1451:
1452: QP_PRICE_FORMULA_UPG_UTIL_PVT.Insert_Pricing_Attribute(
1453: nvl(l_value_rec.creation_date,sysdate), nvl(l_value_rec.created_by, -1),
1454: nvl(l_value_rec.last_update_date,sysdate), nvl(l_value_rec.last_updated_by,-1),
1455: nvl(l_value_rec.last_update_login,-1), l_list_line_id, 'N', 'N',
1456: l_context4, l_attribute4, l_attr_value, null,

Line 1476: QP_PRICE_FORMULA_UPG_UTIL_PVT.Insert_Pricing_Attribute(

1472: attribute_flag => x_attribute_flag,
1473: value_flag => x_value_flag, datatype => x_datatype,
1474: precedence => x_precedence, error_code => x_error_code);
1475:
1476: QP_PRICE_FORMULA_UPG_UTIL_PVT.Insert_Pricing_Attribute(
1477: nvl(l_value_rec.creation_date,sysdate), nvl(l_value_rec.created_by, -1),
1478: nvl(l_value_rec.last_update_date,sysdate), nvl(l_value_rec.last_updated_by,-1),
1479: nvl(l_value_rec.last_update_login,-1), l_list_line_id, 'N', 'N',
1480: l_context5, l_attribute5, l_attr_value, null,

Line 1487: QP_PRICE_FORMULA_UPG_UTIL_PVT.Insert_Price_Formula_Line(

1483:
1484: END LOOP; -- Loop through rule lines values
1485:
1486:
1487: QP_PRICE_FORMULA_UPG_UTIL_PVT.Insert_Price_Formula_Line(
1488: l_price_formula_line_id, --price_formula_line_id
1489: l_lines_rec.creation_date,
1490: l_lines_rec.created_by,
1491: l_lines_rec.last_update_date,

Line 1576: END QP_PRICE_FORMULA_UPG_UTIL_PVT;

1572:
1573: END Upgrade_Price_Formulas;
1574:
1575:
1576: END QP_PRICE_FORMULA_UPG_UTIL_PVT;