eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_QP_FORM_FORMULA_LINES dependencies on QP_PRICE_FORMULA_PUB

Line 10: g_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;

6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_QP_Form_Formula_Lines';
7:
8: -- Global variables holding cached record.
9:
10: g_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
11: g_db_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:

Line 11: g_db_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;

7:
8: -- Global variables holding cached record.
9:
10: g_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
11: g_db_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_FORMULA_LINES

Line 16: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type

12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_FORMULA_LINES
16: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
17: , p_db_record IN BOOLEAN := FALSE
18: );
19:
20: FUNCTION Get_FORMULA_LINES

Line 24: RETURN QP_Price_Formula_PUB.Formula_Lines_Rec_Type;

20: FUNCTION Get_FORMULA_LINES
21: ( p_db_record IN BOOLEAN := FALSE
22: , p_price_formula_line_id IN NUMBER
23: )
24: RETURN QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
25:
26: PROCEDURE Clear_FORMULA_LINES;
27:
28: -- Global variable holding performed operations.

Line 30: g_opr__tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;

26: PROCEDURE Clear_FORMULA_LINES;
27:
28: -- Global variable holding performed operations.
29:
30: g_opr__tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
31:
32:
33: -- Procedure : Create_Factor_List
34: --

Line 262: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;

258: , x_price_modifier_list OUT NOCOPY /* file.sql.39 change */ VARCHAR2
259: , x_reqd_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
260: )
261: IS
262: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
263: l_FORMULA_LINES_val_rec QP_Price_Formula_PUB.Formula_Lines_Val_Rec_Type;
264: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
265: l_control_rec QP_GLOBALS.Control_Rec_Type;
266: l_return_status VARCHAR2(1);

Line 263: l_FORMULA_LINES_val_rec QP_Price_Formula_PUB.Formula_Lines_Val_Rec_Type;

259: , x_reqd_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
260: )
261: IS
262: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
263: l_FORMULA_LINES_val_rec QP_Price_Formula_PUB.Formula_Lines_Val_Rec_Type;
264: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
265: l_control_rec QP_GLOBALS.Control_Rec_Type;
266: l_return_status VARCHAR2(1);
267: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;

Line 264: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;

260: )
261: IS
262: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
263: l_FORMULA_LINES_val_rec QP_Price_Formula_PUB.Formula_Lines_Val_Rec_Type;
264: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
265: l_control_rec QP_GLOBALS.Control_Rec_Type;
266: l_return_status VARCHAR2(1);
267: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
268: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;

Line 267: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;

263: l_FORMULA_LINES_val_rec QP_Price_Formula_PUB.Formula_Lines_Val_Rec_Type;
264: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
265: l_control_rec QP_GLOBALS.Control_Rec_Type;
266: l_return_status VARCHAR2(1);
267: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
268: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
269: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
270: BEGIN
271:

Line 268: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;

264: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
265: l_control_rec QP_GLOBALS.Control_Rec_Type;
266: l_return_status VARCHAR2(1);
267: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
268: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
269: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
270: BEGIN
271:
272: -- Set control flags.

Line 269: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;

265: l_control_rec QP_GLOBALS.Control_Rec_Type;
266: l_return_status VARCHAR2(1);
267: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
268: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
269: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
270: BEGIN
271:
272: -- Set control flags.
273:

Line 513: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;

509: , x_price_modifier_list OUT NOCOPY /* file.sql.39 change */ VARCHAR2
510: , x_reqd_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
511: )
512: IS
513: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
514: l_old_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
515: l_FORMULA_LINES_val_rec QP_Price_Formula_PUB.Formula_Lines_Val_Rec_Type;
516: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
517: l_old_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;

Line 514: l_old_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;

510: , x_reqd_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
511: )
512: IS
513: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
514: l_old_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
515: l_FORMULA_LINES_val_rec QP_Price_Formula_PUB.Formula_Lines_Val_Rec_Type;
516: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
517: l_old_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
518: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 515: l_FORMULA_LINES_val_rec QP_Price_Formula_PUB.Formula_Lines_Val_Rec_Type;

511: )
512: IS
513: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
514: l_old_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
515: l_FORMULA_LINES_val_rec QP_Price_Formula_PUB.Formula_Lines_Val_Rec_Type;
516: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
517: l_old_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
518: l_control_rec QP_GLOBALS.Control_Rec_Type;
519: l_return_status VARCHAR2(1);

Line 516: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;

512: IS
513: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
514: l_old_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
515: l_FORMULA_LINES_val_rec QP_Price_Formula_PUB.Formula_Lines_Val_Rec_Type;
516: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
517: l_old_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
518: l_control_rec QP_GLOBALS.Control_Rec_Type;
519: l_return_status VARCHAR2(1);
520: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;

Line 517: l_old_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;

513: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
514: l_old_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
515: l_FORMULA_LINES_val_rec QP_Price_Formula_PUB.Formula_Lines_Val_Rec_Type;
516: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
517: l_old_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
518: l_control_rec QP_GLOBALS.Control_Rec_Type;
519: l_return_status VARCHAR2(1);
520: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
521: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;

Line 520: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;

516: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
517: l_old_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
518: l_control_rec QP_GLOBALS.Control_Rec_Type;
519: l_return_status VARCHAR2(1);
520: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
521: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
522: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
523: BEGIN
524:

Line 521: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;

517: l_old_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
518: l_control_rec QP_GLOBALS.Control_Rec_Type;
519: l_return_status VARCHAR2(1);
520: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
521: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
522: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
523: BEGIN
524:
525: -- Set control flags.

Line 522: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;

518: l_control_rec QP_GLOBALS.Control_Rec_Type;
519: l_return_status VARCHAR2(1);
520: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
521: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
522: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
523: BEGIN
524:
525: -- Set control flags.
526:

Line 962: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;

958: , x_last_updated_by OUT NOCOPY /* file.sql.39 change */ NUMBER
959: , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
960: )
961: IS
962: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
963: l_old_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
964: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
965: l_old_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
966: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 963: l_old_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;

959: , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
960: )
961: IS
962: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
963: l_old_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
964: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
965: l_old_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
966: l_control_rec QP_GLOBALS.Control_Rec_Type;
967: l_return_status VARCHAR2(1);

Line 964: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;

960: )
961: IS
962: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
963: l_old_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
964: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
965: l_old_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
966: l_control_rec QP_GLOBALS.Control_Rec_Type;
967: l_return_status VARCHAR2(1);
968: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;

Line 965: l_old_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;

961: IS
962: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
963: l_old_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
964: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
965: l_old_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
966: l_control_rec QP_GLOBALS.Control_Rec_Type;
967: l_return_status VARCHAR2(1);
968: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
969: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;

Line 968: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;

964: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
965: l_old_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
966: l_control_rec QP_GLOBALS.Control_Rec_Type;
967: l_return_status VARCHAR2(1);
968: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
969: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
970: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
971: BEGIN
972:

Line 969: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;

965: l_old_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
966: l_control_rec QP_GLOBALS.Control_Rec_Type;
967: l_return_status VARCHAR2(1);
968: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
969: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
970: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
971: BEGIN
972:
973: -- Set control flags.

Line 970: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;

966: l_control_rec QP_GLOBALS.Control_Rec_Type;
967: l_return_status VARCHAR2(1);
968: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
969: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
970: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
971: BEGIN
972:
973: -- Set control flags.
974:

Line 1121: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;

1117: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1118: , p_price_formula_line_id IN NUMBER
1119: )
1120: IS
1121: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1122: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
1123: l_control_rec QP_GLOBALS.Control_Rec_Type;
1124: l_return_status VARCHAR2(1);
1125: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;

Line 1122: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;

1118: , p_price_formula_line_id IN NUMBER
1119: )
1120: IS
1121: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1122: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
1123: l_control_rec QP_GLOBALS.Control_Rec_Type;
1124: l_return_status VARCHAR2(1);
1125: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
1126: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;

Line 1125: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;

1121: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1122: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
1123: l_control_rec QP_GLOBALS.Control_Rec_Type;
1124: l_return_status VARCHAR2(1);
1125: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
1126: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1127: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
1128: BEGIN
1129:

Line 1126: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;

1122: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
1123: l_control_rec QP_GLOBALS.Control_Rec_Type;
1124: l_return_status VARCHAR2(1);
1125: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
1126: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1127: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
1128: BEGIN
1129:
1130: -- Set control flags.

Line 1127: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;

1123: l_control_rec QP_GLOBALS.Control_Rec_Type;
1124: l_return_status VARCHAR2(1);
1125: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
1126: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1127: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
1128: BEGIN
1129:
1130: -- Set control flags.
1131:

Line 1253: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;

1249: )
1250: IS
1251: l_control_rec QP_GLOBALS.Control_Rec_Type;
1252: l_return_status VARCHAR2(1);
1253: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
1254: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1255: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
1256: BEGIN
1257:

Line 1254: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;

1250: IS
1251: l_control_rec QP_GLOBALS.Control_Rec_Type;
1252: l_return_status VARCHAR2(1);
1253: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
1254: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1255: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
1256: BEGIN
1257:
1258: -- Set control flags.

Line 1255: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;

1251: l_control_rec QP_GLOBALS.Control_Rec_Type;
1252: l_return_status VARCHAR2(1);
1253: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
1254: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1255: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
1256: BEGIN
1257:
1258: -- Set control flags.
1259:

Line 1394: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;

1390: , p_reqd_flag IN VARCHAR2
1391: )
1392: IS
1393: l_return_status VARCHAR2(1);
1394: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1395: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
1396: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
1397: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1398: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;

Line 1395: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;

1391: )
1392: IS
1393: l_return_status VARCHAR2(1);
1394: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1395: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
1396: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
1397: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1398: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
1399: BEGIN

Line 1396: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;

1392: IS
1393: l_return_status VARCHAR2(1);
1394: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1395: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
1396: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
1397: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1398: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
1399: BEGIN
1400:

Line 1397: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;

1393: l_return_status VARCHAR2(1);
1394: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1395: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
1396: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
1397: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1398: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
1399: BEGIN
1400:
1401: -- Load FORMULA_LINES record

Line 1398: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;

1394: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1395: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
1396: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
1397: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1398: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
1399: BEGIN
1400:
1401: -- Load FORMULA_LINES record
1402:

Line 1509: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type

1505:
1506: -- Procedures maintaining FORMULA_LINES record cache.
1507:
1508: PROCEDURE Write_FORMULA_LINES
1509: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
1510: , p_db_record IN BOOLEAN := FALSE
1511: )
1512: IS
1513: BEGIN

Line 1529: RETURN QP_Price_Formula_PUB.Formula_Lines_Rec_Type

1525: FUNCTION Get_FORMULA_LINES
1526: ( p_db_record IN BOOLEAN := FALSE
1527: , p_price_formula_line_id IN NUMBER
1528: )
1529: RETURN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
1530: IS
1531: BEGIN
1532:
1533: IF p_price_formula_line_id <> g_FORMULA_LINES_rec.price_formula_line_id

Line 1566: g_FORMULA_LINES_rec := QP_Price_Formula_PUB.G_MISS_FORMULA_LINES_REC;

1562: PROCEDURE Clear_Formula_Lines
1563: IS
1564: BEGIN
1565:
1566: g_FORMULA_LINES_rec := QP_Price_Formula_PUB.G_MISS_FORMULA_LINES_REC;
1567: g_db_FORMULA_LINES_rec := QP_Price_Formula_PUB.G_MISS_FORMULA_LINES_REC;
1568:
1569: END Clear_Formula_Lines;
1570:

Line 1567: g_db_FORMULA_LINES_rec := QP_Price_Formula_PUB.G_MISS_FORMULA_LINES_REC;

1563: IS
1564: BEGIN
1565:
1566: g_FORMULA_LINES_rec := QP_Price_Formula_PUB.G_MISS_FORMULA_LINES_REC;
1567: g_db_FORMULA_LINES_rec := QP_Price_Formula_PUB.G_MISS_FORMULA_LINES_REC;
1568:
1569: END Clear_Formula_Lines;
1570:
1571: END QP_QP_Form_Formula_Lines;