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.OE_PRICING_CONT_PVT dependencies on OE_GLOBALS

Line 21: , p_control_rec IN OE_GLOBALS.Control_Rec_Type

17: -- This procedure is no longer used
18: /*
19: PROCEDURE Contract
20: ( p_validation_level IN NUMBER
21: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
22: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
23: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
24: , x_Contract_rec OUT NOCOPY OE_Pricing_Cont_PUB.Contract_Rec_Type --file.sql.39 change
25: , x_old_Contract_rec OUT NOCOPY OE_Pricing_Cont_PUB.Contract_Rec_Type --file.sql.39 change

Line 29: l_control_rec OE_GLOBALS.Control_Rec_Type;

25: , x_old_Contract_rec OUT NOCOPY OE_Pricing_Cont_PUB.Contract_Rec_Type --file.sql.39 change
26: )
27: IS
28: l_return_status VARCHAR2(1);
29: l_control_rec OE_GLOBALS.Control_Rec_Type;
30: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_Contract_rec;
31: l_old_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_old_Contract_rec;
32: l_p_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type; --[prarasto]
33: BEGIN

Line 40: l_control_rec := OE_GLOBALS.Init_Control_Rec

36: oe_debug_pub.add('Entering Contract');
37:
38: -- Load API control record
39:
40: l_control_rec := OE_GLOBALS.Init_Control_Rec
41: ( p_operation => l_Contract_rec.operation
42: , p_control_rec => p_control_rec
43: );
44:

Line 51: IF l_Contract_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

47: l_Contract_rec.return_status := FND_API.G_RET_STS_SUCCESS;
48:
49: -- Prepare record.
50:
51: IF l_Contract_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
52:
53: l_Contract_rec.db_flag := FND_API.G_FALSE;
54:
55: -- Set missing old record elements to NULL.

Line 60: ELSIF (l_Contract_rec.operation = OE_GLOBALS.G_OPR_UPDATE

56:
57: l_old_Contract_rec :=
58: OE_Contract_Util.Convert_Miss_To_Null (l_old_Contract_rec);
59:
60: ELSIF (l_Contract_rec.operation = OE_GLOBALS.G_OPR_UPDATE
61: OR l_Contract_rec.operation = OE_GLOBALS.G_OPR_DELETE )
62: THEN
63:
64: l_Contract_rec.db_flag := FND_API.G_TRUE;

Line 61: OR l_Contract_rec.operation = OE_GLOBALS.G_OPR_DELETE )

57: l_old_Contract_rec :=
58: OE_Contract_Util.Convert_Miss_To_Null (l_old_Contract_rec);
59:
60: ELSIF (l_Contract_rec.operation = OE_GLOBALS.G_OPR_UPDATE
61: OR l_Contract_rec.operation = OE_GLOBALS.G_OPR_DELETE )
62: THEN
63:
64: l_Contract_rec.db_flag := FND_API.G_TRUE;
65:

Line 93: IF ( l_contract_rec.operation = OE_GLOBALS.G_OPR_UPDATE

89: );
90:
91: END IF;
92:
93: IF ( l_contract_rec.operation = OE_GLOBALS.G_OPR_UPDATE
94: OR l_contract_rec.operation = OE_GLOBALS.G_OPR_CREATE
95: OR l_contract_rec.operation = OE_GLOBALS.G_OPR_DELETE) THEN
96:
97: -- Attribute level validation.

Line 94: OR l_contract_rec.operation = OE_GLOBALS.G_OPR_CREATE

90:
91: END IF;
92:
93: IF ( l_contract_rec.operation = OE_GLOBALS.G_OPR_UPDATE
94: OR l_contract_rec.operation = OE_GLOBALS.G_OPR_CREATE
95: OR l_contract_rec.operation = OE_GLOBALS.G_OPR_DELETE) THEN
96:
97: -- Attribute level validation.
98:

Line 95: OR l_contract_rec.operation = OE_GLOBALS.G_OPR_DELETE) THEN

91: END IF;
92:
93: IF ( l_contract_rec.operation = OE_GLOBALS.G_OPR_UPDATE
94: OR l_contract_rec.operation = OE_GLOBALS.G_OPR_CREATE
95: OR l_contract_rec.operation = OE_GLOBALS.G_OPR_DELETE) THEN
96:
97: -- Attribute level validation.
98:
99: IF l_control_rec.default_attributes

Line 172: IF l_Contract_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

168: -- Entity level validation.
169:
170: IF l_control_rec.validate_entity THEN
171:
172: IF l_Contract_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
173:
174: OE_Validate_Contract.Entity_Delete
175: ( x_return_status => l_return_status
176: , p_Contract_rec => l_Contract_rec

Line 201: IF l_Contract_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

197: -- Step 4. Write to DB
198:
199: IF l_control_rec.write_to_db THEN
200:
201: IF l_Contract_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
202:
203: OE_Contract_Util.Delete_Row
204: ( p_pricing_contract_id => l_Contract_rec.pricing_contract_id
205: );

Line 215: IF l_Contract_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

211: l_Contract_rec.last_update_date := SYSDATE;
212: l_Contract_rec.last_updated_by := FND_GLOBAL.USER_ID;
213: l_Contract_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
214:
215: IF l_Contract_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
216:
217: OE_Contract_Util.Update_Row (l_Contract_rec);
218:
219: ELSIF l_Contract_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

Line 219: ELSIF l_Contract_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

215: IF l_Contract_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
216:
217: OE_Contract_Util.Update_Row (l_Contract_rec);
218:
219: ELSIF l_Contract_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
220:
221: l_Contract_rec.creation_date := SYSDATE;
222: l_Contract_rec.created_by := FND_GLOBAL.USER_ID;
223:

Line 290: , p_control_rec IN OE_GLOBALS.Control_Rec_Type

286: -- Agreement
287:
288: PROCEDURE Agreement
289: ( p_validation_level IN NUMBER
290: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
291: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
292: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
293: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
294: , x_old_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type

Line 301: l_control_rec OE_GLOBALS.Control_Rec_Type;

297: l_return_status VARCHAR2(1);
298: l_Agreement_Delete_Flag BOOLEAN;
299: l_Agreement_Lines_Delete_Flag BOOLEAN;
300: l_Price_List_Exists_Flag BOOLEAN;
301: l_control_rec OE_GLOBALS.Control_Rec_Type;
302: --l_control_rec QP_GLOBALS.Control_Rec_Type;
303: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_Agreement_rec;
304: l_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_old_Agreement_rec;
305: l_old_price_list_id QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE;

Line 334: l_control_rec := OE_GLOBALS.Init_Control_Rec

330: oe_debug_pub.add('Entering Agreement');
331:
332: -- Load API control record
333:
334: l_control_rec := OE_GLOBALS.Init_Control_Rec
335: ( p_operation => l_Agreement_rec.operation
336: , p_control_rec => p_control_rec
337: );
338:

Line 345: IF l_Agreement_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

341: l_Agreement_rec.return_status := FND_API.G_RET_STS_SUCCESS;
342:
343: -- Prepare record.
344:
345: IF l_Agreement_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
346:
347: l_Agreement_rec.db_flag := FND_API.G_FALSE;
348:
349: -- Set missing old record elements to NULL.

Line 354: ELSIF l_Agreement_rec.operation = OE_GLOBALS.G_OPR_UPDATE

350:
351: l_old_Agreement_rec :=
352: OE_Agreement_Util.Convert_Miss_To_Null (l_old_Agreement_rec);
353:
354: ELSIF l_Agreement_rec.operation = OE_GLOBALS.G_OPR_UPDATE
355: OR l_Agreement_rec.operation = OE_GLOBALS.G_OPR_DELETE
356: THEN
357:
358: l_Agreement_rec.db_flag := FND_API.G_TRUE;

Line 355: OR l_Agreement_rec.operation = OE_GLOBALS.G_OPR_DELETE

351: l_old_Agreement_rec :=
352: OE_Agreement_Util.Convert_Miss_To_Null (l_old_Agreement_rec);
353:
354: ELSIF l_Agreement_rec.operation = OE_GLOBALS.G_OPR_UPDATE
355: OR l_Agreement_rec.operation = OE_GLOBALS.G_OPR_DELETE
356: THEN
357:
358: l_Agreement_rec.db_flag := FND_API.G_TRUE;
359:

Line 390: IF ( l_agreement_rec.operation = OE_GLOBALS.G_OPR_UPDATE

386: );
387:
388: END IF;
389:
390: IF ( l_agreement_rec.operation = OE_GLOBALS.G_OPR_UPDATE
391: OR l_agreement_rec.operation = OE_GLOBALS.G_OPR_CREATE
392: OR l_agreement_rec.operation = OE_GLOBALS.G_OPR_DELETE) THEN
393:
394: -- Attribute level validation.

Line 391: OR l_agreement_rec.operation = OE_GLOBALS.G_OPR_CREATE

387:
388: END IF;
389:
390: IF ( l_agreement_rec.operation = OE_GLOBALS.G_OPR_UPDATE
391: OR l_agreement_rec.operation = OE_GLOBALS.G_OPR_CREATE
392: OR l_agreement_rec.operation = OE_GLOBALS.G_OPR_DELETE) THEN
393:
394: -- Attribute level validation.
395:

Line 392: OR l_agreement_rec.operation = OE_GLOBALS.G_OPR_DELETE) THEN

388: END IF;
389:
390: IF ( l_agreement_rec.operation = OE_GLOBALS.G_OPR_UPDATE
391: OR l_agreement_rec.operation = OE_GLOBALS.G_OPR_CREATE
392: OR l_agreement_rec.operation = OE_GLOBALS.G_OPR_DELETE) THEN
393:
394: -- Attribute level validation.
395:
396: IF l_control_rec.default_attributes

Line 474: IF l_Agreement_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

470: -- Entity level validation.
471:
472: IF l_control_rec.validate_entity THEN
473:
474: IF l_Agreement_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
475:
476: OE_Validate_Agreement.Entity_Delete
477: ( x_return_status => l_return_status
478: , p_Agreement_rec => l_Agreement_rec

Line 483: IF l_Agreement_rec.operation = OE_GLOBALS.G_OPR_CREATE then

479: );
480:
481: ELSE
482:
483: IF l_Agreement_rec.operation = OE_GLOBALS.G_OPR_CREATE then
484:
485: OE_Validate_Agreement.Entity
486: ( x_return_status => l_return_status
487: , p_Agreement_rec => l_Agreement_rec

Line 506: IF l_Agreement_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

502: -- Step 4. Write to DB
503:
504: IF l_control_rec.write_to_db THEN
505:
506: IF l_Agreement_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
507:
508:
509: /* Check the price List associated with an agreement */
510: /* Bug 2321498 Commented following code as price List should not be deleted */

Line 563: IF l_Agreement_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

559: l_Agreement_rec.last_update_date := SYSDATE;
560: l_Agreement_rec.last_updated_by := FND_GLOBAL.USER_ID;
561: l_Agreement_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
562:
563: IF l_Agreement_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
564:
565: OE_Agreement_Util.Update_Row (l_Agreement_rec);
566: -- update agreement qualifier
567:

Line 605: ELSIF l_Agreement_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

601: END IF;
602:
603: --END IF;
604:
605: ELSIF l_Agreement_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
606:
607: l_Agreement_rec.creation_date := SYSDATE;
608: l_Agreement_rec.created_by := FND_GLOBAL.USER_ID;
609:

Line 674: l_qualifiers_rec.operation := OE_GLOBALS.G_OPR_CREATE;

670: l_qualifiers_rec.list_header_id := l_Agreement_rec.price_list_id ;
671: l_qualifiers_rec.qualifier_attr_value := l_Agreement_rec.agreement_id;
672: l_qualifiers_rec.qualifier_context := 'CUSTOMER';
673: l_qualifiers_rec.qualifier_attribute := 'QUALIFIER_ATTRIBUTE7';
674: l_qualifiers_rec.operation := OE_GLOBALS.G_OPR_CREATE;
675:
676: l_qualifiers_rec.qualifier_grouping_no := l_Agreement_rec.agreement_id;
677:
678:

Line 679: l_qualifiers_rec.operation := OE_GLOBALS.G_OPR_CREATE;

675:
676: l_qualifiers_rec.qualifier_grouping_no := l_Agreement_rec.agreement_id;
677:
678:
679: l_qualifiers_rec.operation := OE_GLOBALS.G_OPR_CREATE;
680: l_qualifiers_tbl(1) := l_qualifiers_rec;
681:
682: QP_Qualifier_Rules_PVT.Process_Qualifier_Rules
683: ( p_api_version_number => 1.0

Line 764: , p_control_rec IN OE_GLOBALS.Control_Rec_Type

760: -- Price_Lheader
761:
762: PROCEDURE Price_Lheader
763: ( p_validation_level IN NUMBER
764: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
765: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type
766: , p_old_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type
767: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
768: , x_old_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type

Line 772: l_control_rec OE_GLOBALS.Control_Rec_Type;

768: , x_old_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
769: )
770: IS
771: l_return_status VARCHAR2(1);
772: l_control_rec OE_GLOBALS.Control_Rec_Type;
773: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type := p_Price_LHeader_rec;
774: l_old_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_Price_LHeader_rec;
775:
776: l_p_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type; --[prarasto]

Line 784: l_control_rec := OE_GLOBALS.Init_Control_Rec

780: oe_debug_pub.add('------------------------------------------------');
781: oe_debug_pub.add('Entering Price_LHeader');
782: -- Load API control record
783:
784: l_control_rec := OE_GLOBALS.Init_Control_Rec
785: ( p_operation => l_Price_LHeader_rec.operation
786: , p_control_rec => p_control_rec
787: );
788: l_Price_LHeader_rec.return_status := FND_API.G_RET_STS_SUCCESS;

Line 795: IF l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

791:
792:
793: -- Prepare record.
794:
795: IF l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
796:
797: l_Price_LHeader_rec.db_flag := FND_API.G_FALSE;
798:
799: -- Set missing old record elements to NULL.

Line 804: ELSIF l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_UPDATE

800:
801: l_old_Price_LHeader_rec :=
802: OE_Price_List_Util.Convert_Miss_To_Null (l_old_Price_LHeader_rec);
803:
804: ELSIF l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_UPDATE
805: OR l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_DELETE
806: THEN
807:
808: l_Price_LHeader_rec.db_flag := FND_API.G_TRUE;

Line 805: OR l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_DELETE

801: l_old_Price_LHeader_rec :=
802: OE_Price_List_Util.Convert_Miss_To_Null (l_old_Price_LHeader_rec);
803:
804: ELSIF l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_UPDATE
805: OR l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_DELETE
806: THEN
807:
808: l_Price_LHeader_rec.db_flag := FND_API.G_TRUE;
809:

Line 840: IF ( l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_UPDATE

836:
837: END IF;
838:
839:
840: IF ( l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_UPDATE
841: OR l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_CREATE
842: OR l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_DELETE) THEN
843: -- Attribute level validation.
844:

Line 841: OR l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_CREATE

837: END IF;
838:
839:
840: IF ( l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_UPDATE
841: OR l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_CREATE
842: OR l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_DELETE) THEN
843: -- Attribute level validation.
844:
845: IF l_control_rec.default_attributes

Line 842: OR l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_DELETE) THEN

838:
839:
840: IF ( l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_UPDATE
841: OR l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_CREATE
842: OR l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_DELETE) THEN
843: -- Attribute level validation.
844:
845: IF l_control_rec.default_attributes
846: OR l_control_rec.change_attributes

Line 915: IF l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

911: -- Entity level validation.
912:
913: IF l_control_rec.validate_entity THEN
914:
915: IF l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
916:
917: OE_Validate_Price_List.Entity_Delete
918: ( x_return_status => l_return_status
919: , p_Price_list_rec => l_Price_LHeader_rec

Line 944: IF l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

940: -- Step 4. Write to DB
941:
942: IF l_control_rec.write_to_db THEN
943:
944: IF l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
945:
946: OE_Price_List_Util.Delete_Row
947: ( p_name => l_Price_LHeader_rec.name,
948: p_price_list_id => l_Price_LHeader_rec.price_list_id

Line 959: IF l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

955: l_Price_LHeader_rec.last_update_date := SYSDATE;
956: l_Price_LHeader_rec.last_updated_by := FND_GLOBAL.USER_ID;
957: l_Price_LHeader_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
958:
959: IF l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
960:
961: OE_Price_List_Util.Update_Row (l_Price_LHeader_rec);
962:
963: ELSIF l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

Line 963: ELSIF l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

959: IF l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
960:
961: OE_Price_List_Util.Update_Row (l_Price_LHeader_rec);
962:
963: ELSIF l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
964:
965: l_Price_LHeader_rec.creation_date := SYSDATE;
966: l_Price_LHeader_rec.created_by := FND_GLOBAL.USER_ID;
967:

Line 1025: , p_control_rec IN OE_GLOBALS.Control_Rec_Type

1021: -- Price_Llines
1022:
1023: PROCEDURE Price_Llines
1024: ( p_validation_level IN NUMBER
1025: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
1026: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type
1027: , p_old_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type
1028: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
1029: , x_old_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type

Line 1033: l_control_rec OE_GLOBALS.Control_Rec_Type;

1029: , x_old_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
1030: )
1031: IS
1032: l_return_status VARCHAR2(1);
1033: l_control_rec OE_GLOBALS.Control_Rec_Type;
1034: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1035: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1036: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1037: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 1068: l_control_rec := OE_GLOBALS.Init_Control_Rec

1064: END IF;
1065:
1066: -- Load API control record
1067:
1068: l_control_rec := OE_GLOBALS.Init_Control_Rec
1069: ( p_operation => l_Price_LLine_rec.operation
1070: , p_control_rec => p_control_rec
1071: );
1072:

Line 1079: IF l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

1075: l_Price_LLine_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1076:
1077: -- Prepare record.
1078:
1079: IF l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1080:
1081: l_Price_LLine_rec.db_flag := FND_API.G_FALSE;
1082:
1083: -- Set missing old record elements to NULL.

Line 1088: ELSIF l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_UPDATE

1084:
1085: l_old_Price_LLine_rec :=
1086: OE_Price_List_Line_Util.Convert_Miss_To_Null (l_old_Price_LLine_rec);
1087:
1088: ELSIF l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_UPDATE
1089: OR l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_DELETE
1090: THEN
1091:
1092: l_Price_LLine_rec.db_flag := FND_API.G_TRUE;

Line 1089: OR l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_DELETE

1085: l_old_Price_LLine_rec :=
1086: OE_Price_List_Line_Util.Convert_Miss_To_Null (l_old_Price_LLine_rec);
1087:
1088: ELSIF l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_UPDATE
1089: OR l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_DELETE
1090: THEN
1091:
1092: l_Price_LLine_rec.db_flag := FND_API.G_TRUE;
1093:

Line 1122: IF ( l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_UPDATE

1118: );
1119:
1120: END IF;
1121:
1122: IF ( l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_UPDATE
1123: OR l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_CREATE
1124: OR l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_DELETE) THEN
1125: -- Attribute level validation.
1126:

Line 1123: OR l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_CREATE

1119:
1120: END IF;
1121:
1122: IF ( l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_UPDATE
1123: OR l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_CREATE
1124: OR l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_DELETE) THEN
1125: -- Attribute level validation.
1126:
1127: IF l_control_rec.default_attributes

Line 1124: OR l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_DELETE) THEN

1120: END IF;
1121:
1122: IF ( l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_UPDATE
1123: OR l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_CREATE
1124: OR l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_DELETE) THEN
1125: -- Attribute level validation.
1126:
1127: IF l_control_rec.default_attributes
1128: OR l_control_rec.change_attributes

Line 1198: IF l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

1194: -- Entity level validation.
1195:
1196: IF l_control_rec.validate_entity THEN
1197:
1198: IF l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
1199:
1200: OE_Validate_Price_List_Line.Entity_Delete
1201: ( x_return_status => l_return_status
1202: , p_PRICE_LIST_LINE_rec => l_Price_LLine_rec

Line 1227: IF l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

1223: -- Step 4. Write to DB
1224:
1225: IF l_control_rec.write_to_db THEN
1226:
1227: IF l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
1228:
1229: OE_Price_List_Line_Util.Delete_Row
1230: ( p_price_list_line_id => l_Price_LLine_rec.price_list_line_id
1231: );

Line 1241: IF l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

1237: l_Price_LLine_rec.last_update_date := SYSDATE;
1238: l_Price_LLine_rec.last_updated_by := FND_GLOBAL.USER_ID;
1239: l_Price_LLine_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1240:
1241: IF l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1242:
1243: OE_Price_List_Line_Util.Update_Row (l_Price_LLine_rec);
1244:
1245: ELSIF l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

Line 1245: ELSIF l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

1241: IF l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1242:
1243: OE_Price_List_Line_Util.Update_Row (l_Price_LLine_rec);
1244:
1245: ELSIF l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1246:
1247: l_Price_LLine_rec.creation_date := SYSDATE;
1248: l_Price_LLine_rec.created_by := FND_GLOBAL.USER_ID;
1249:

Line 1340: , p_control_rec IN OE_GLOBALS.Control_Rec_Type

1336: -- Price_Breaks
1337:
1338: PROCEDURE Price_Breaks
1339: ( p_validation_level IN NUMBER
1340: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
1341: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
1342: , p_old_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
1343: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
1344: , x_old_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type

Line 1348: l_control_rec OE_GLOBALS.Control_Rec_Type;

1344: , x_old_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
1345: )
1346: IS
1347: l_return_status VARCHAR2(1);
1348: l_control_rec OE_GLOBALS.Control_Rec_Type;
1349: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1350: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1351: l_old_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1352: l_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

Line 1381: l_control_rec := OE_GLOBALS.Init_Control_Rec

1377: END IF;
1378:
1379: -- Load API control record
1380:
1381: l_control_rec := OE_GLOBALS.Init_Control_Rec
1382: ( p_operation => l_Price_Break_rec.operation
1383: , p_control_rec => p_control_rec
1384: );
1385:

Line 1392: IF l_Price_Break_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

1388: l_Price_Break_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1389:
1390: -- Prepare record.
1391:
1392: IF l_Price_Break_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1393:
1394: l_Price_Break_rec.db_flag := FND_API.G_FALSE;
1395:
1396: -- Set missing old record elements to NULL.

Line 1401: ELSIF l_Price_Break_rec.operation = OE_GLOBALS.G_OPR_UPDATE

1397:
1398: l_old_Price_Break_rec :=
1399: OE_Price_Break_Util.Convert_Miss_To_Null (l_old_Price_Break_rec);
1400:
1401: ELSIF l_Price_Break_rec.operation = OE_GLOBALS.G_OPR_UPDATE
1402: OR l_Price_Break_rec.operation = OE_GLOBALS.G_OPR_DELETE
1403: THEN
1404:
1405: l_Price_Break_rec.db_flag := FND_API.G_TRUE;

Line 1402: OR l_Price_Break_rec.operation = OE_GLOBALS.G_OPR_DELETE

1398: l_old_Price_Break_rec :=
1399: OE_Price_Break_Util.Convert_Miss_To_Null (l_old_Price_Break_rec);
1400:
1401: ELSIF l_Price_Break_rec.operation = OE_GLOBALS.G_OPR_UPDATE
1402: OR l_Price_Break_rec.operation = OE_GLOBALS.G_OPR_DELETE
1403: THEN
1404:
1405: l_Price_Break_rec.db_flag := FND_API.G_TRUE;
1406:

Line 1519: IF l_Price_Break_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

1515: -- Entity level validation.
1516:
1517: IF l_control_rec.validate_entity THEN
1518:
1519: IF l_Price_Break_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
1520: /*
1521: OE_Validate_Price_Break.Entity_Delete
1522: ( x_return_status => l_return_status
1523: , p_Price_Break_rec => l_Price_Break_rec

Line 1552: IF l_Price_Break_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

1548: -- Step 4. Write to DB
1549:
1550: IF l_control_rec.write_to_db THEN
1551:
1552: IF l_Price_Break_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
1553:
1554: NULL;
1555: /* OE_Price_Break_Util.Delete_Row
1556: ( p_discount_line_id => l_Price_Break_rec.discount_line_id

Line 1573: IF l_Price_Break_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

1569: l_Price_Break_rec.last_update_date := SYSDATE;
1570: l_Price_Break_rec.last_updated_by := FND_GLOBAL.USER_ID;
1571: l_Price_Break_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1572:
1573: IF l_Price_Break_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1574:
1575: NULL;
1576: /*
1577: OE_Price_Break_Util.Update_Row (l_Price_Break_rec);

Line 1579: ELSIF l_Price_Break_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

1575: NULL;
1576: /*
1577: OE_Price_Break_Util.Update_Row (l_Price_Break_rec);
1578: */
1579: ELSIF l_Price_Break_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1580:
1581: l_Price_Break_rec.creation_date := SYSDATE;
1582: l_Price_Break_rec.created_by := FND_GLOBAL.USER_ID;
1583: /*

Line 1690: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=

1686: ( p_api_version_number IN NUMBER
1687: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1688: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1689: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1690: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
1691: OE_GLOBALS.G_MISS_CONTROL_REC
1692: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1693: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1694: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1691: OE_GLOBALS.G_MISS_CONTROL_REC

1687: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1688: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1689: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1690: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
1691: OE_GLOBALS.G_MISS_CONTROL_REC
1692: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1693: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1694: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1695: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=

Line 1740: l_control_rec OE_GLOBALS.Control_Rec_Type;

1736: IS
1737: l_api_version_number CONSTANT NUMBER := 1.0;
1738: l_api_name CONSTANT VARCHAR2(30):= 'Process_Pricing_Cont';
1739: l_return_status VARCHAR2(1);
1740: l_control_rec OE_GLOBALS.Control_Rec_Type;
1741: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_Contract_rec;
1742: l_old_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_old_Contract_rec;
1743: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_Agreement_rec;
1744: l_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_old_Agreement_rec;

Line 1873: (p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL OR

1869:
1870: -- Perform Contract group requests.
1871:
1872: IF p_control_rec.process AND
1873: (p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL OR
1874: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_CONTRACT)
1875: THEN
1876:
1877: NULL;

Line 1874: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_CONTRACT)

1870: -- Perform Contract group requests.
1871:
1872: IF p_control_rec.process AND
1873: (p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL OR
1874: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_CONTRACT)
1875: THEN
1876:
1877: NULL;
1878:

Line 1886: IF l_Agreement_rec.operation = OE_GLOBALS.G_OPR_CREATE

1882: */
1883:
1884: -- Load parent key if missing and operation is create.
1885:
1886: IF l_Agreement_rec.operation = OE_GLOBALS.G_OPR_CREATE
1887: AND (l_Agreement_rec.pricing_contract_id IS NULL OR
1888: l_Agreement_rec.pricing_contract_id = FND_API.G_MISS_NUM)
1889: THEN
1890:

Line 1919: (p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL OR

1915:
1916: -- Perform Agreement group requests.
1917:
1918: IF p_control_rec.process AND
1919: (p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL OR
1920: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_AGREEMENT)
1921: THEN
1922:
1923: NULL;

Line 1920: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_AGREEMENT)

1916: -- Perform Agreement group requests.
1917:
1918: IF p_control_rec.process AND
1919: (p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL OR
1920: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_AGREEMENT)
1921: THEN
1922:
1923: NULL;
1924:

Line 1937: IF l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_CREATE

1933:
1934:
1935: -- Load parent key if missing and operation is create.
1936:
1937: IF l_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_CREATE
1938: AND (l_Price_LHeader_rec.pricing_contract_id IS NULL OR
1939: l_Price_LHeader_rec.pricing_contract_id = FND_API.G_MISS_NUM)
1940: THEN
1941:

Line 1965: (p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL OR

1961:
1962: -- Perform Price_LHeader group requests.
1963:
1964: IF p_control_rec.process AND
1965: (p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL OR
1966: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_PRICE_LHEADER)
1967: THEN
1968:
1969: NULL;

Line 1966: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_PRICE_LHEADER)

1962: -- Perform Price_LHeader group requests.
1963:
1964: IF p_control_rec.process AND
1965: (p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL OR
1966: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_PRICE_LHEADER)
1967: THEN
1968:
1969: NULL;
1970:

Line 1975: IF l_Discount_Header_rec.operation = OE_GLOBALS.G_OPR_CREATE

1971: END IF;
1972:
1973: -- Load parent key if missing and operation is create.
1974:
1975: IF l_Discount_Header_rec.operation = OE_GLOBALS.G_OPR_CREATE
1976: AND (l_Discount_Header_rec.pricing_contract_id IS NULL OR
1977: l_Discount_Header_rec.pricing_contract_id = FND_API.G_MISS_NUM)
1978: THEN
1979:

Line 2010: (p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL OR

2006:
2007: -- Perform Discount_Header group requests.
2008:
2009: IF p_control_rec.process AND
2010: (p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL OR
2011: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_DISCOUNT_HEADER)
2012: THEN
2013:
2014: NULL;

Line 2011: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_DISCOUNT_HEADER)

2007: -- Perform Discount_Header group requests.
2008:
2009: IF p_control_rec.process AND
2010: (p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL OR
2011: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_DISCOUNT_HEADER)
2012: THEN
2013:
2014: NULL;
2015:

Line 2024: IF l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_CREATE

2020: FOR I IN 1..l_Price_LLine_tbl.COUNT LOOP
2021:
2022: l_Price_LLine_rec := l_Price_LLine_tbl(I);
2023:
2024: IF l_Price_LLine_rec.operation = OE_GLOBALS.G_OPR_CREATE
2025: AND (l_Price_LLine_rec.price_list_id IS NULL OR
2026: l_Price_LLine_rec.price_list_id = FND_API.G_MISS_NUM)
2027: THEN
2028:

Line 2052: (p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL OR

2048:
2049: -- Perform Price_LLine group requests.
2050:
2051: IF p_control_rec.process AND
2052: (p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL OR
2053: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_PRICE_LLINE)
2054: THEN
2055:
2056: NULL;

Line 2053: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_PRICE_LLINE)

2049: -- Perform Price_LLine group requests.
2050:
2051: IF p_control_rec.process AND
2052: (p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL OR
2053: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_PRICE_LLINE)
2054: THEN
2055:
2056: NULL;
2057:

Line 2066: IF l_Discount_Cust_rec.operation = OE_GLOBALS.G_OPR_CREATE

2062: FOR I IN 1..l_Discount_Cust_tbl.COUNT LOOP
2063:
2064: l_Discount_Cust_rec := l_Discount_Cust_tbl(I);
2065:
2066: IF l_Discount_Cust_rec.operation = OE_GLOBALS.G_OPR_CREATE
2067: AND (l_Discount_Cust_rec.discount_id IS NULL OR
2068: l_Discount_Cust_rec.discount_id = FND_API.G_MISS_NUM)
2069: THEN
2070:

Line 2095: (p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL OR

2091:
2092: -- Perform Discount_Cust group requests.
2093:
2094: IF p_control_rec.process AND
2095: (p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL OR
2096: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_DISCOUNT_CUST)
2097: THEN
2098:
2099: NULL;

Line 2096: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_DISCOUNT_CUST)

2092: -- Perform Discount_Cust group requests.
2093:
2094: IF p_control_rec.process AND
2095: (p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL OR
2096: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_DISCOUNT_CUST)
2097: THEN
2098:
2099: NULL;
2100:

Line 2109: IF l_Discount_Line_rec.operation = OE_GLOBALS.G_OPR_CREATE

2105: FOR I IN 1..l_Discount_Line_tbl.COUNT LOOP
2106:
2107: l_Discount_Line_rec := l_Discount_Line_tbl(I);
2108:
2109: IF l_Discount_Line_rec.operation = OE_GLOBALS.G_OPR_CREATE
2110: AND (l_Discount_Line_rec.discount_id IS NULL OR
2111: l_Discount_Line_rec.discount_id = FND_API.G_MISS_NUM)
2112: THEN
2113:

Line 2138: (p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL OR

2134:
2135: -- Perform Discount_Line group requests.
2136:
2137: IF p_control_rec.process AND
2138: (p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL OR
2139: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_DISCOUNT_LINE)
2140: THEN
2141:
2142: NULL;

Line 2139: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_DISCOUNT_LINE)

2135: -- Perform Discount_Line group requests.
2136:
2137: IF p_control_rec.process AND
2138: (p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL OR
2139: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_DISCOUNT_LINE)
2140: THEN
2141:
2142: NULL;
2143:

Line 2152: IF l_Price_Break_rec.operation = OE_GLOBALS.G_OPR_CREATE

2148: FOR I IN 1..l_Price_Break_tbl.COUNT LOOP
2149:
2150: l_Price_Break_rec := l_Price_Break_tbl(I);
2151:
2152: IF l_Price_Break_rec.operation = OE_GLOBALS.G_OPR_CREATE
2153: AND (l_Price_Break_rec.discount_line_id IS NULL OR
2154: l_Price_Break_rec.discount_line_id = FND_API.G_MISS_NUM)
2155: THEN
2156:

Line 2198: (p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL OR

2194:
2195: -- Perform Price_Break group requests.
2196:
2197: IF p_control_rec.process AND
2198: (p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL OR
2199: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_PRICE_BREAK)
2200: THEN
2201:
2202: NULL;

Line 2199: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_PRICE_BREAK)

2195: -- Perform Price_Break group requests.
2196:
2197: IF p_control_rec.process AND
2198: (p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL OR
2199: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_PRICE_BREAK)
2200: THEN
2201:
2202: NULL;
2203:

Line 2209: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL

2205:
2206: -- Step 6. Perform Object group logic
2207:
2208: IF p_control_rec.process AND
2209: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL
2210: THEN
2211:
2212: NULL;
2213:

Line 2444: IF p_Contract_rec.operation = OE_GLOBALS.G_OPR_LOCK THEN

2440: SAVEPOINT Lock_Pricing_Cont_PVT;
2441:
2442: -- Lock Contract
2443:
2444: IF p_Contract_rec.operation = OE_GLOBALS.G_OPR_LOCK THEN
2445:
2446: OE_Contract_Util.Lock_Row
2447: ( p_Contract_rec => p_Contract_rec
2448: , x_Contract_rec => x_Contract_rec

Line 2463: IF p_Agreement_rec.operation = OE_GLOBALS.G_OPR_LOCK THEN

2459: END IF;
2460:
2461: -- Lock Agreement
2462:
2463: IF p_Agreement_rec.operation = OE_GLOBALS.G_OPR_LOCK THEN
2464:
2465: OE_Agreement_Util.Lock_Row
2466: ( p_Agreement_rec => p_Agreement_rec
2467: , x_Agreement_rec => x_Agreement_rec

Line 2482: IF p_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_LOCK THEN

2478: END IF;
2479:
2480: -- Lock Price_LHeader
2481:
2482: IF p_Price_LHeader_rec.operation = OE_GLOBALS.G_OPR_LOCK THEN
2483:
2484: OE_Price_List_Util.Lock_Row
2485: ( p_Price_LIST_rec => p_Price_LHeader_rec
2486: , x_Price_LIST_rec => x_Price_LHeader_rec

Line 2501: IF p_Discount_Header_rec.operation = OE_GLOBALS.G_OPR_LOCK THEN

2497: END IF;
2498: /*
2499: -- Lock Discount_Header
2500:
2501: IF p_Discount_Header_rec.operation = OE_GLOBALS.G_OPR_LOCK THEN
2502:
2503: OE_Discount_Header_Util.Lock_Row
2504: ( p_Discount_Header_rec => p_Discount_Header_rec
2505: , x_Discount_Header_rec => x_Discount_Header_rec

Line 2522: IF p_Price_LLine_tbl(I).operation = OE_GLOBALS.G_OPR_LOCK THEN

2518: -- Lock Price_LLine
2519:
2520: FOR I IN 1..p_Price_LLine_tbl.COUNT LOOP
2521:
2522: IF p_Price_LLine_tbl(I).operation = OE_GLOBALS.G_OPR_LOCK THEN
2523:
2524: OE_Price_List_Line_Util.Lock_Row
2525: ( p_PRICE_LIST_LINE_rec => p_Price_LLine_tbl(I)
2526: , x_PRICE_LIST_LINE_rec => l_Price_LLine_rec

Line 2546: IF p_Discount_Cust_tbl(I).operation = OE_GLOBALS.G_OPR_LOCK THEN

2542: -- Lock Discount_Cust
2543:
2544: FOR I IN 1..p_Discount_Cust_tbl.COUNT LOOP
2545:
2546: IF p_Discount_Cust_tbl(I).operation = OE_GLOBALS.G_OPR_LOCK THEN
2547:
2548: OE_Discount_Cust_Util.Lock_Row
2549: ( p_Discount_Cust_rec => p_Discount_Cust_tbl(I)
2550: , x_Discount_Cust_rec => l_Discount_Cust_rec

Line 2570: IF p_Discount_Line_tbl(I).operation = OE_GLOBALS.G_OPR_LOCK THEN

2566: -- Lock Discount_Line
2567:
2568: FOR I IN 1..p_Discount_Line_tbl.COUNT LOOP
2569:
2570: IF p_Discount_Line_tbl(I).operation = OE_GLOBALS.G_OPR_LOCK THEN
2571:
2572: OE_Discount_Line_Util.Lock_Row
2573: ( p_Discount_Line_rec => p_Discount_Line_tbl(I)
2574: , x_Discount_Line_rec => l_Discount_Line_rec

Line 2596: IF p_Price_Break_tbl(I).operation = OE_GLOBALS.G_OPR_LOCK THEN

2592: -- Lock Price_Break
2593:
2594: FOR I IN 1..p_Price_Break_tbl.COUNT LOOP
2595:
2596: IF p_Price_Break_tbl(I).operation = OE_GLOBALS.G_OPR_LOCK THEN
2597:
2598: OE_Price_Break_Util.Lock_Row
2599: ( p_Price_Break_rec => p_Price_Break_tbl(I)
2600: , x_Price_Break_rec => l_Price_Break_rec

Line 3096: if p_operation = OE_GLOBALS.G_OPR_CREATE then

3092: IF p_list_header_id IS NOT NULL OR
3093: p_list_header_id <> FND_API.G_MISS_NUM THEN
3094:
3095:
3096: if p_operation = OE_GLOBALS.G_OPR_CREATE then
3097:
3098: oe_debug_pub.add('in if create'||p_operation);
3099:
3100: l_qualifiers_rec.list_header_id := p_list_header_id;

Line 3107: l_qualifiers_rec.operation := OE_GLOBALS.G_OPR_CREATE;

3103: l_qualifiers_rec.qualifier_attribute := 'QUALIFIER_ATTRIBUTE7';
3104: l_qualifiers_rec.qualifier_grouping_no := p_agreement_id;
3105:
3106:
3107: l_qualifiers_rec.operation := OE_GLOBALS.G_OPR_CREATE;
3108: l_qualifiers_tbl(1) := l_qualifiers_rec;
3109: --nguha 2041504
3110: -- set the called_from_ui indicator to 'Y', as
3111: -- QP_Qualifier_Rules_PVT.Process_Qualifier_Rules is being called from UI

Line 3133: elsif p_operation = OE_GLOBALS.G_OPR_UPDATE then

3129: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
3130: );
3131:
3132:
3133: elsif p_operation = OE_GLOBALS.G_OPR_UPDATE then
3134: oe_debug_pub.add('in if update'||p_operation);
3135:
3136:
3137: if p_old_list_header_id <> p_list_header_id then

Line 3174: l_qualifiers_rec.operation := OE_GLOBALS.G_OPR_CREATE;

3170: l_qualifiers_rec.qualifier_attribute := 'QUALIFIER_ATTRIBUTE7';
3171: l_qualifiers_rec.qualifier_grouping_no := p_agreement_id;
3172:
3173:
3174: l_qualifiers_rec.operation := OE_GLOBALS.G_OPR_CREATE;
3175: l_qualifiers_tbl(1) := l_qualifiers_rec;
3176:
3177: else
3178: