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_PRICE_LIST_LINE_UTIL dependencies on QP_PRICE_LIST_PUB

Line 14: , p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type

10: -- Procedure Clear_Dependent_Attr
11:
12: PROCEDURE Clear_Dependent_Attr
13: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
14: , p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
15: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=
16: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
17: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type
18: )

Line 15: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=

11:
12: PROCEDURE Clear_Dependent_Attr
13: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
14: , p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
15: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=
16: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
17: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type
18: )
19: IS

Line 16: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC

12: PROCEDURE Clear_Dependent_Attr
13: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
14: , p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
15: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=
16: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
17: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type
18: )
19: IS
20: l_index NUMBER := 0;

Line 17: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type

13: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
14: , p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
15: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=
16: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
17: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type
18: )
19: IS
20: l_index NUMBER := 0;
21: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

Line 659: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type

655:
656: -- Procedure Apply_Attribute_Changes
657:
658: PROCEDURE Apply_Attribute_Changes
659: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
660: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=
661: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
662: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type
663: )

Line 660: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=

656: -- Procedure Apply_Attribute_Changes
657:
658: PROCEDURE Apply_Attribute_Changes
659: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
660: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=
661: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
662: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type
663: )
664: IS

Line 661: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC

657:
658: PROCEDURE Apply_Attribute_Changes
659: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
660: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=
661: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
662: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type
663: )
664: IS
665: l_return_status varchar2(30);

Line 662: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type

658: PROCEDURE Apply_Attribute_Changes
659: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
660: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=
661: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
662: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type
663: )
664: IS
665: l_return_status varchar2(30);
666: BEGIN

Line 1071: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type

1067:
1068: -- Function Complete_Record
1069:
1070: FUNCTION Complete_Record
1071: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
1072: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
1073: ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type
1074: IS
1075: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type := p_PRICE_LIST_LINE_rec;

Line 1072: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type

1068: -- Function Complete_Record
1069:
1070: FUNCTION Complete_Record
1071: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
1072: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
1073: ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type
1074: IS
1075: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type := p_PRICE_LIST_LINE_rec;
1076: BEGIN

Line 1073: ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type

1069:
1070: FUNCTION Complete_Record
1071: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
1072: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
1073: ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type
1074: IS
1075: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type := p_PRICE_LIST_LINE_rec;
1076: BEGIN
1077:

Line 1075: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type := p_PRICE_LIST_LINE_rec;

1071: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
1072: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
1073: ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type
1074: IS
1075: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type := p_PRICE_LIST_LINE_rec;
1076: BEGIN
1077:
1078: IF l_PRICE_LIST_LINE_rec.accrual_qty = FND_API.G_MISS_NUM THEN
1079: l_PRICE_LIST_LINE_rec.accrual_qty := p_old_PRICE_LIST_LINE_rec.accrual_qty;

Line 1381: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type

1377:
1378: -- Function Convert_Miss_To_Null
1379:
1380: FUNCTION Convert_Miss_To_Null
1381: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
1382: ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type
1383: IS
1384: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type := p_PRICE_LIST_LINE_rec;
1385: BEGIN

Line 1382: ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type

1378: -- Function Convert_Miss_To_Null
1379:
1380: FUNCTION Convert_Miss_To_Null
1381: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
1382: ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type
1383: IS
1384: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type := p_PRICE_LIST_LINE_rec;
1385: BEGIN
1386:

Line 1384: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type := p_PRICE_LIST_LINE_rec;

1380: FUNCTION Convert_Miss_To_Null
1381: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
1382: ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type
1383: IS
1384: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type := p_PRICE_LIST_LINE_rec;
1385: BEGIN
1386:
1387: IF l_PRICE_LIST_LINE_rec.accrual_qty = FND_API.G_MISS_NUM THEN
1388: l_PRICE_LIST_LINE_rec.accrual_qty := NULL;

Line 1703: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type

1699: Return l_rounding_factor;
1700: END Round_List_Price;
1701:
1702: PROCEDURE Update_Row
1703: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
1704: )
1705: IS
1706: l_operand NUMBER;
1707: l_check_active_flag VARCHAR2(1); /* Proration */

Line 1847: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type

1843:
1844: -- Procedure Insert_Row
1845:
1846: PROCEDURE Insert_Row
1847: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
1848: )
1849: IS
1850: l_return_status varchar2(30);
1851: l_operand NUMBER;

Line 2156: ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type

2152: -- Function Query_Row
2153:
2154: FUNCTION Query_Row
2155: ( p_list_line_id IN NUMBER
2156: ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type
2157: IS
2158: BEGIN
2159:
2160: RETURN Query_Rows

Line 2175: ) RETURN QP_Price_List_PUB.Price_List_Line_Tbl_Type

2171: ( p_list_line_id IN NUMBER :=
2172: FND_API.G_MISS_NUM
2173: , p_list_header_id IN NUMBER :=
2174: FND_API.G_MISS_NUM
2175: ) RETURN QP_Price_List_PUB.Price_List_Line_Tbl_Type
2176: IS
2177: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
2178: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
2179:

Line 2177: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

2173: , p_list_header_id IN NUMBER :=
2174: FND_API.G_MISS_NUM
2175: ) RETURN QP_Price_List_PUB.Price_List_Line_Tbl_Type
2176: IS
2177: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
2178: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
2179:
2180: CURSOR l_PRICE_LIST_LINE_csr IS
2181: SELECT ACCRUAL_QTY

Line 2178: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

2174: FND_API.G_MISS_NUM
2175: ) RETURN QP_Price_List_PUB.Price_List_Line_Tbl_Type
2176: IS
2177: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
2178: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
2179:
2180: CURSOR l_PRICE_LIST_LINE_csr IS
2181: SELECT ACCRUAL_QTY
2182: , ACCRUAL_UOM_CODE

Line 2613: , p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type

2609: --
2610:
2611: PROCEDURE Lock_Row
2612: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2613: , p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
2614: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type
2615: )
2616: IS
2617: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

Line 2614: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type

2610:
2611: PROCEDURE Lock_Row
2612: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2613: , p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
2614: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type
2615: )
2616: IS
2617: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
2618: BEGIN

Line 2617: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

2613: , p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
2614: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type
2615: )
2616: IS
2617: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
2618: BEGIN
2619:
2620:
2621: QP_Price_List_Line_Util.Print_Price_List_line(p_PRICE_LIST_LINE_rec,

Line 3113: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type

3109:
3110: -- Function Get_Values
3111:
3112: FUNCTION Get_Values
3113: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
3114: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=
3115: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
3116: ) RETURN QP_Price_List_PUB.Price_List_Line_Val_Rec_Type
3117: IS

Line 3114: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=

3110: -- Function Get_Values
3111:
3112: FUNCTION Get_Values
3113: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
3114: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=
3115: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
3116: ) RETURN QP_Price_List_PUB.Price_List_Line_Val_Rec_Type
3117: IS
3118: l_PRICE_LIST_LINE_val_rec QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;

Line 3115: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC

3111:
3112: FUNCTION Get_Values
3113: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
3114: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=
3115: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
3116: ) RETURN QP_Price_List_PUB.Price_List_Line_Val_Rec_Type
3117: IS
3118: l_PRICE_LIST_LINE_val_rec QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;
3119: BEGIN

Line 3116: ) RETURN QP_Price_List_PUB.Price_List_Line_Val_Rec_Type

3112: FUNCTION Get_Values
3113: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
3114: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=
3115: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
3116: ) RETURN QP_Price_List_PUB.Price_List_Line_Val_Rec_Type
3117: IS
3118: l_PRICE_LIST_LINE_val_rec QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;
3119: BEGIN
3120:

Line 3118: l_PRICE_LIST_LINE_val_rec QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;

3114: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=
3115: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
3116: ) RETURN QP_Price_List_PUB.Price_List_Line_Val_Rec_Type
3117: IS
3118: l_PRICE_LIST_LINE_val_rec QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;
3119: BEGIN
3120:
3121: /*
3122: IF p_PRICE_LIST_LINE_rec.accrual_uom_code IS NOT NULL AND

Line 3332: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type

3328:
3329: -- Function Get_Ids
3330:
3331: FUNCTION Get_Ids
3332: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
3333: , p_PRICE_LIST_LINE_val_rec IN QP_Price_List_PUB.Price_List_Line_Val_Rec_Type
3334: ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type
3335: IS
3336: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

Line 3333: , p_PRICE_LIST_LINE_val_rec IN QP_Price_List_PUB.Price_List_Line_Val_Rec_Type

3329: -- Function Get_Ids
3330:
3331: FUNCTION Get_Ids
3332: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
3333: , p_PRICE_LIST_LINE_val_rec IN QP_Price_List_PUB.Price_List_Line_Val_Rec_Type
3334: ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type
3335: IS
3336: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
3337: BEGIN

Line 3334: ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type

3330:
3331: FUNCTION Get_Ids
3332: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
3333: , p_PRICE_LIST_LINE_val_rec IN QP_Price_List_PUB.Price_List_Line_Val_Rec_Type
3334: ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type
3335: IS
3336: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
3337: BEGIN
3338:

Line 3336: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

3332: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
3333: , p_PRICE_LIST_LINE_val_rec IN QP_Price_List_PUB.Price_List_Line_Val_Rec_Type
3334: ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type
3335: IS
3336: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
3337: BEGIN
3338:
3339: -- initialize return_status.
3340:

Line 3958: (p_PRICE_LIST_LINE_rec IN QP_PRICE_LIST_PUB.PRICE_LIST_LINE_REC_TYPE,

3954: END Get_Ids;
3955:
3956:
3957: Procedure Print_Price_List_Line
3958: (p_PRICE_LIST_LINE_rec IN QP_PRICE_LIST_PUB.PRICE_LIST_LINE_REC_TYPE,
3959: p_counter IN NUMBER)
3960: IS
3961: BEGIN
3962: oe_debug_pub.add('additional message 1- 8206467');