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.

[Home] [Help]

APPS.OE_BLANKET_UTIL dependencies on OE_BLANKET_PUB

Line 6: (p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_Rec_Type

2: /* $Header: OEXUBSOB.pls 120.31.12020000.5 2013/01/08 10:22:09 sipillut ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Blanket_Util';
4:
5: PROCEDURE Insert_History_Records
6: (p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_Rec_Type
7: ,p_line_tbl IN OUT NOCOPY OE_Blanket_PUB.Line_Tbl_Type
8: ,p_version_flag in varchar2 := null
9: ,p_phase_change_flag in varchar2 := null
10: ,x_return_status IN OUT NOCOPY VARCHAR2

Line 7: ,p_line_tbl IN OUT NOCOPY OE_Blanket_PUB.Line_Tbl_Type

3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Blanket_Util';
4:
5: PROCEDURE Insert_History_Records
6: (p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_Rec_Type
7: ,p_line_tbl IN OUT NOCOPY OE_Blanket_PUB.Line_Tbl_Type
8: ,p_version_flag in varchar2 := null
9: ,p_phase_change_flag in varchar2 := null
10: ,x_return_status IN OUT NOCOPY VARCHAR2
11: );

Line 25: ( p_line_rec IN OE_Blanket_PUB.line_rec_type,

21:
22: -- ER 5743580
23: --Added for Bug 9027699
24: FUNCTION is_end_date_operation
25: ( p_line_rec IN OE_Blanket_PUB.line_rec_type,
26: p_old_line_rec IN OE_Blanket_PUB.line_rec_type)
27: RETURN BOOLEAN
28: IS
29: l_dummy VARCHAR2(10);

Line 26: p_old_line_rec IN OE_Blanket_PUB.line_rec_type)

22: -- ER 5743580
23: --Added for Bug 9027699
24: FUNCTION is_end_date_operation
25: ( p_line_rec IN OE_Blanket_PUB.line_rec_type,
26: p_old_line_rec IN OE_Blanket_PUB.line_rec_type)
27: RETURN BOOLEAN
28: IS
29: l_dummy VARCHAR2(10);
30: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 88: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE ,

84: --validate item uniqueness
85: -- This is called just to make sure that a delayed request is logged..else validate_entity was being called again
86: -- from process_object
87: OE_Delayed_Requests_Pvt.Log_Request(p_Entity_Code =>
88: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE ,
89: p_Entity_Id => p_line_rec.line_id,
90: p_requesting_entity_code =>
91: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
92: p_requesting_entity_id => p_line_rec.line_id,

Line 91: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

87: OE_Delayed_Requests_Pvt.Log_Request(p_Entity_Code =>
88: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE ,
89: p_Entity_Id => p_line_rec.line_id,
90: p_requesting_entity_code =>
91: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
92: p_requesting_entity_id => p_line_rec.line_id,
93: p_request_type => 'VALIDATE_BLANKET_INV_ITEM',
94: p_param1 => p_line_rec.inventory_item_id,
95: p_param2 => p_line_rec.header_id,

Line 456: oe_blanket_pub.g_entity_blanket_LINE THEN

452: LOOP
453: IF oe_delayed_requests_pvt.g_delayed_requests(I).request_type = 'CREATE_BLANKET_PRICE_LIST'
454: AND
455: oe_delayed_requests_pvt.g_delayed_requests(I).entity_code =
456: oe_blanket_pub.g_entity_blanket_LINE THEN
457: if l_debug_level > 0 then
458: oe_debug_pub.add('Blanket In create price list - line');
459: end if;
460: IF oe_delayed_requests_pvt.g_delayed_requests(I).param1 IS NULL THEN

Line 1055: ( p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type

1051: END IF;
1052: END Clear_price_list_line;
1053:
1054: PROCEDURE Validate_Attributes
1055: ( p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
1056: , p_old_header_rec IN OE_Blanket_PUB.Header_rec_type
1057: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1058: , x_return_status OUT NOCOPY VARCHAR2
1059: ) IS

Line 1056: , p_old_header_rec IN OE_Blanket_PUB.Header_rec_type

1052: END Clear_price_list_line;
1053:
1054: PROCEDURE Validate_Attributes
1055: ( p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
1056: , p_old_header_rec IN OE_Blanket_PUB.Header_rec_type
1057: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1058: , x_return_status OUT NOCOPY VARCHAR2
1059: ) IS
1060: l_dummy VARCHAR2(10);

Line 1630: ( p_x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type

1626:
1627: END Validate_Attributes;
1628:
1629: PROCEDURE Validate_Attributes
1630: ( p_x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type
1631: , p_old_line_rec IN OE_Blanket_PUB.line_rec_type
1632: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1633: , x_return_status OUT NOCOPY VARCHAR2
1634: ) IS

Line 1631: , p_old_line_rec IN OE_Blanket_PUB.line_rec_type

1627: END Validate_Attributes;
1628:
1629: PROCEDURE Validate_Attributes
1630: ( p_x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type
1631: , p_old_line_rec IN OE_Blanket_PUB.line_rec_type
1632: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1633: , x_return_status OUT NOCOPY VARCHAR2
1634: ) IS
1635: --{ Bug # 5562785

Line 2355: ( p_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type

2351: --bug 4893057
2352:
2353:
2354: PROCEDURE Validate_Entity
2355: ( p_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type
2356: , p_old_line_rec IN OE_Blanket_PUB.Line_rec_type := OE_Blanket_PUB.G_MISS_BLANKET_LINE_REC
2357: , x_return_status OUT NOCOPY VARCHAR2
2358: )IS
2359:

Line 2356: , p_old_line_rec IN OE_Blanket_PUB.Line_rec_type := OE_Blanket_PUB.G_MISS_BLANKET_LINE_REC

2352:
2353:
2354: PROCEDURE Validate_Entity
2355: ( p_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type
2356: , p_old_line_rec IN OE_Blanket_PUB.Line_rec_type := OE_Blanket_PUB.G_MISS_BLANKET_LINE_REC
2357: , x_return_status OUT NOCOPY VARCHAR2
2358: )IS
2359:
2360: l_dummy varchar2(30);

Line 2362: l_old_line_rec OE_Blanket_PUB.Line_rec_type := p_old_line_rec;

2358: )IS
2359:
2360: l_dummy varchar2(30);
2361: l_valid_line_number varchar2(1);
2362: l_old_line_rec OE_Blanket_PUB.Line_rec_type := p_old_line_rec;
2363: l_site_use_code VARCHAR2(30);
2364: l_return_status varchar2(1);
2365:
2366: --

Line 2543: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

2539: OE_Order_UTIL.Get_Attribute_Name('LINE_NUMBER'));
2540: OE_MSG_PUB.Add;
2541: ELSE
2542: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
2543: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
2544: p_Entity_Id => p_line_rec.line_id,
2545: p_requesting_entity_code =>
2546: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
2547: p_requesting_entity_id => p_line_rec.line_id,

Line 2546: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

2542: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
2543: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
2544: p_Entity_Id => p_line_rec.line_id,
2545: p_requesting_entity_code =>
2546: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
2547: p_requesting_entity_id => p_line_rec.line_id,
2548: p_request_type => 'VALIDATE_BLANKET_LINE_NUMBER',
2549: p_param1 => p_line_rec.header_id,
2550: p_param2 => p_line_rec.line_number,

Line 2624: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE ,

2620: end if;
2621:
2622: --validate item uniqueness
2623: OE_Delayed_Requests_Pvt.Log_Request(p_Entity_Code =>
2624: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE ,
2625: p_Entity_Id => p_line_rec.line_id,
2626: p_requesting_entity_code =>
2627: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
2628: p_requesting_entity_id => p_line_rec.line_id,

Line 2627: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

2623: OE_Delayed_Requests_Pvt.Log_Request(p_Entity_Code =>
2624: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE ,
2625: p_Entity_Id => p_line_rec.line_id,
2626: p_requesting_entity_code =>
2627: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
2628: p_requesting_entity_id => p_line_rec.line_id,
2629: p_request_type => 'VALIDATE_BLANKET_INV_ITEM',
2630: p_param1 => p_line_rec.inventory_item_id,
2631: p_param2 => p_line_rec.header_id,

Line 2917: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE ,

2913:
2914: /* IF NOT OE_GLOBALS.EQUAL (p_line_rec.end_date_active, l_old_line_rec.end_date_active) THEN
2915: --validate item uniqueness
2916: OE_Delayed_Requests_Pvt.Log_Request(p_Entity_Code =>
2917: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE ,
2918: p_Entity_Id => p_line_rec.line_id,
2919: p_requesting_entity_code =>
2920: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
2921: p_requesting_entity_id => p_line_rec.line_id,

Line 2920: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

2916: OE_Delayed_Requests_Pvt.Log_Request(p_Entity_Code =>
2917: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE ,
2918: p_Entity_Id => p_line_rec.line_id,
2919: p_requesting_entity_code =>
2920: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
2921: p_requesting_entity_id => p_line_rec.line_id,
2922: p_request_type => 'VALIDATE_BLANKET_INV_ITEM',
2923: p_param1 => p_line_rec.inventory_item_id,
2924: p_param2 => p_line_rec.header_id,

Line 3109: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

3105: -- IF p_line_rec.unit_list_price IS NOT NULL
3106: IF NOT OE_GLOBALS.EQUAL(p_line_rec.unit_list_price,p_old_line_rec.unit_list_price)
3107: THEN
3108: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
3109: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3110: p_Entity_Id => p_line_rec.line_id,
3111: p_requesting_entity_code =>
3112: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3113: p_requesting_entity_id => p_line_rec.line_id,

Line 3112: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

3108: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
3109: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3110: p_Entity_Id => p_line_rec.line_id,
3111: p_requesting_entity_code =>
3112: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3113: p_requesting_entity_id => p_line_rec.line_id,
3114: p_request_type => 'CREATE_BLANKET_PRICE_LIST',
3115: p_param1=> p_line_rec.unit_list_price,
3116: p_param2 => nvl(p_line_rec.pricing_uom,

Line 3187: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

3183: oe_debug_pub.add('log ADD_BLANKET_PRICE_LIST_LINE');
3184: end if;
3185:
3186: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
3187: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3188: p_Entity_Id => p_line_rec.line_id,
3189: p_requesting_entity_code =>
3190: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3191: p_requesting_entity_id => p_line_rec.line_id,

Line 3190: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

3186: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
3187: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3188: p_Entity_Id => p_line_rec.line_id,
3189: p_requesting_entity_code =>
3190: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3191: p_requesting_entity_id => p_line_rec.line_id,
3192: p_request_type => 'ADD_BLANKET_PRICE_LIST_LINE',
3193: p_param1=> p_line_rec.unit_list_price,
3194: p_param2 => nvl(p_line_rec.pricing_uom,

Line 3236: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

3232: oe_debug_pub.add('Log delayed request: CLEAR_BLANKET_PRICE_LIST_LINE');
3233: end if;
3234:
3235: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
3236: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3237: p_Entity_Id => p_line_rec.line_id,
3238: p_requesting_entity_code =>
3239: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3240: p_requesting_entity_id => p_line_rec.line_id,

Line 3239: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

3235: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
3236: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3237: p_Entity_Id => p_line_rec.line_id,
3238: p_requesting_entity_code =>
3239: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3240: p_requesting_entity_id => p_line_rec.line_id,
3241: p_request_type => OE_GLOBALS.G_CLEAR_BLKT_PRICE_LIST_LINE,
3242: p_param1=> p_line_rec.qp_list_line_id,
3243: p_param2 => g_header_rec.new_price_list_id,

Line 3281: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

3277: x_return_status := FND_API.G_RET_STS_ERROR;
3278: ELSE
3279: -- Log delayed request to create new modifier list line
3280: oe_delayed_requests_pvt.Log_request
3281: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3282: p_Entity_Id => p_line_rec.line_id,
3283: p_requesting_entity_code =>
3284: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3285: p_requesting_entity_id => p_line_rec.line_id,

Line 3284: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

3280: oe_delayed_requests_pvt.Log_request
3281: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3282: p_Entity_Id => p_line_rec.line_id,
3283: p_requesting_entity_code =>
3284: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3285: p_requesting_entity_id => p_line_rec.line_id,
3286: p_request_type => 'ADD_MODIFIER_LIST_LINE',
3287: p_param1 => p_line_rec.discount_percent,
3288: p_param2 => p_line_rec.discount_amount,

Line 3333: ( p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type

3329:
3330: END Validate_Entity;
3331:
3332: PROCEDURE Validate_Entity
3333: ( p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
3334: , p_old_header_rec IN OE_Blanket_PUB.Header_rec_type := OE_Blanket_PUB.g_miss_header_rec
3335: , x_return_status OUT NOCOPY VARCHAR2
3336: )IS
3337: l_return_status varchar2(1);

Line 3334: , p_old_header_rec IN OE_Blanket_PUB.Header_rec_type := OE_Blanket_PUB.g_miss_header_rec

3330: END Validate_Entity;
3331:
3332: PROCEDURE Validate_Entity
3333: ( p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
3334: , p_old_header_rec IN OE_Blanket_PUB.Header_rec_type := OE_Blanket_PUB.g_miss_header_rec
3335: , x_return_status OUT NOCOPY VARCHAR2
3336: )IS
3337: l_return_status varchar2(1);
3338: l_dummy varchar2(30);

Line 3339: l_old_header_rec OE_Blanket_PUB.Header_rec_type := p_old_header_rec;

3335: , x_return_status OUT NOCOPY VARCHAR2
3336: )IS
3337: l_return_status varchar2(1);
3338: l_dummy varchar2(30);
3339: l_old_header_rec OE_Blanket_PUB.Header_rec_type := p_old_header_rec;
3340: l_db_version_number NUMBER;
3341: -- 11i10 Pricing Changes
3342: l_list_header_id NUMBER;
3343: l_new_pl_name VARCHAR2(240);

Line 4108: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER

4104: END IF;
4105:
4106: IF NOT OE_GLOBALS.Equal(x_return_status, FND_API.G_RET_STS_ERROR) THEN
4107: OE_Delayed_Requests_PVT.Log_Request
4108: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
4109: ,p_Entity_Id => p_header_rec.header_id
4110: ,p_requesting_entity_code =>
4111: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
4112: ,p_requesting_entity_id => p_header_rec.header_id

Line 4111: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER

4107: OE_Delayed_Requests_PVT.Log_Request
4108: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
4109: ,p_Entity_Id => p_header_rec.header_id
4110: ,p_requesting_entity_code =>
4111: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
4112: ,p_requesting_entity_id => p_header_rec.header_id
4113: ,p_request_type => 'RECORD_BLANKET_HISTORY'
4114: ,p_param1=> p_header_rec.revision_change_reason_code
4115: ,p_long_param1 => p_header_rec.revision_change_comments

Line 4138: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER

4134: if (NOT OE_GLOBALS.Equal(p_header_rec.start_date_active,l_old_header_rec.start_date_active) OR
4135: NOT OE_GLOBALS.Equal(p_header_rec.end_date_active,l_old_header_rec.end_date_active))
4136: THEN
4137: OE_Delayed_Requests_PVT.Log_Request
4138: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
4139: ,p_Entity_Id => p_header_rec.header_id
4140: ,p_requesting_entity_code =>
4141: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
4142: ,p_requesting_entity_id => p_header_rec.header_id

Line 4141: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER

4137: OE_Delayed_Requests_PVT.Log_Request
4138: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
4139: ,p_Entity_Id => p_header_rec.header_id
4140: ,p_requesting_entity_code =>
4141: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
4142: ,p_requesting_entity_id => p_header_rec.header_id
4143: ,p_request_type => 'BLANKET_DATE_CHANGE'
4144: ,x_return_status => l_return_status);
4145: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 4160: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER

4156: THEN
4157: if (NOT OE_GLOBALS.Equal(p_header_rec.sold_to_org_id,l_old_header_rec.sold_to_org_id) and
4158: p_header_rec.operation = oe_globals.g_opr_update) THEN
4159: OE_Delayed_Requests_PVT.Log_Request
4160: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
4161: ,p_Entity_Id => p_header_rec.header_id
4162: ,p_param1 => p_header_rec.sold_to_org_id
4163: ,p_requesting_entity_code =>
4164: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER

Line 4164: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER

4160: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
4161: ,p_Entity_Id => p_header_rec.header_id
4162: ,p_param1 => p_header_rec.sold_to_org_id
4163: ,p_requesting_entity_code =>
4164: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
4165: ,p_requesting_entity_id => p_header_rec.header_id
4166: ,p_request_type => 'VALIDATE_BLANKET_SOLD_TO'
4167: ,x_return_status => l_return_status);
4168: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 4184: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER,

4180: else
4181: l_new_pl_name := p_header_rec.price_list_name;
4182: end if;
4183: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
4184: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER,
4185: p_Entity_Id => p_header_rec.header_id,
4186: p_requesting_entity_code =>
4187: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER,
4188: p_requesting_entity_id => p_header_rec.header_id,

Line 4187: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER,

4183: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
4184: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER,
4185: p_Entity_Id => p_header_rec.header_id,
4186: p_requesting_entity_code =>
4187: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER,
4188: p_requesting_entity_id => p_header_rec.header_id,
4189: p_request_type => 'CREATE_BLANKET_PRICE_LIST',
4190: -- 11i10 Pricing Changes
4191: p_param1 => l_new_pl_name,

Line 4210: (p_entity_code => oe_blanket_pub.g_entity_blanket_header,

4206: -- 11i10 Pricing Changes
4207: -- Log request to create new modifier
4208: IF g_new_modifier_list THEN
4209: oe_delayed_requests_pvt.Log_request
4210: (p_entity_code => oe_blanket_pub.g_entity_blanket_header,
4211: p_Entity_Id => p_header_rec.header_id,
4212: p_requesting_entity_code =>
4213: oe_blanket_pub.g_entity_blanket_header,
4214: p_requesting_entity_id => p_header_rec.header_id,

Line 4213: oe_blanket_pub.g_entity_blanket_header,

4209: oe_delayed_requests_pvt.Log_request
4210: (p_entity_code => oe_blanket_pub.g_entity_blanket_header,
4211: p_Entity_Id => p_header_rec.header_id,
4212: p_requesting_entity_code =>
4213: oe_blanket_pub.g_entity_blanket_header,
4214: p_requesting_entity_id => p_header_rec.header_id,
4215: p_request_type => 'CREATE_MODIFIER_LIST',
4216: p_param1 => p_header_rec.new_modifier_list_name,
4217: p_param2 => p_header_rec.transactional_curr_code,

Line 4240: (p_header_rec IN OE_Blanket_PUB.Header_rec_type

4236: END IF;
4237: END Validate_Entity;
4238:
4239: PROCEDURE Insert_Row
4240: (p_header_rec IN OE_Blanket_PUB.Header_rec_type
4241: ,x_return_status OUT NOCOPY VARCHAR2)
4242: IS
4243: l_org_id NUMBER;
4244: l_upgraded_flag varchar2(1) ;

Line 4492: ( p_header_rec IN OE_Blanket_PUB.Header_rec_type

4488:
4489: End Insert_Row;
4490:
4491: PROCEDURE Update_Row
4492: ( p_header_rec IN OE_Blanket_PUB.Header_rec_type
4493: , x_return_status OUT NOCOPY VARCHAR2
4494: )
4495: IS
4496: l_return_status VARCHAR2(1);

Line 4797: ( p_line_rec IN OE_Blanket_PUB.Line_rec_type

4793:
4794: End Delete_Row;
4795:
4796: PROCEDURE Insert_Row
4797: ( p_line_rec IN OE_Blanket_PUB.Line_rec_type
4798: , x_return_status OUT NOCOPY VARCHAR2)
4799: IS
4800: l_org_id NUMBER ;
4801: l_sold_from_org NUMBER;

Line 5060: ( p_line_rec IN OE_Blanket_PUB.Line_rec_type

5056:
5057: End Insert_Row;
5058:
5059: PROCEDURE Update_Row
5060: ( p_line_rec IN OE_Blanket_PUB.Line_rec_type
5061: , x_return_status OUT NOCOPY VARCHAR2)
5062: IS
5063: l_return_status VARCHAR2(1);
5064: --

Line 5311: , x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type

5307: PROCEDURE Query_Header
5308: ( p_header_id IN NUMBER
5309: , p_version_number IN NUMBER := NULL
5310: , p_phase_change_flag IN VARCHAR2 := NULL
5311: , x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
5312: , x_return_status OUT NOCOPY VARCHAR2
5313: )IS
5314:
5315: CURSOR l_hdr_csr IS

Line 5778: ,x_line_tbl IN OUT NOCOPY OE_Blanket_PUB.line_tbl_type

5774: (p_line_id IN NUMBER := NULL
5775: ,p_header_id IN NUMBER := NULL
5776: ,p_version_number IN NUMBER := NULL
5777: ,p_phase_change_flag IN VARCHAR2 := NULL
5778: ,x_line_tbl IN OUT NOCOPY OE_Blanket_PUB.line_tbl_type
5779: ,x_return_status OUT NOCOPY VARCHAR2
5780: )IS
5781:
5782: l_org_id NUMBER;

Line 6335: ,p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type

6331: PROCEDURE Query_blanket
6332: (p_header_id IN NUMBER
6333: ,p_version_number IN NUMBER := NULL
6334: ,p_phase_change_flag IN VARCHAR2 := NULL
6335: ,p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
6336: ,p_x_line_tbl IN OUT NOCOPY OE_Blanket_PUB.line_tbl_type
6337: ,x_return_status OUT NOCOPY VARCHAR2
6338: )IS
6339: l_return_status varchar2(1);

Line 6336: ,p_x_line_tbl IN OUT NOCOPY OE_Blanket_PUB.line_tbl_type

6332: (p_header_id IN NUMBER
6333: ,p_version_number IN NUMBER := NULL
6334: ,p_phase_change_flag IN VARCHAR2 := NULL
6335: ,p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
6336: ,p_x_line_tbl IN OUT NOCOPY OE_Blanket_PUB.line_tbl_type
6337: ,x_return_status OUT NOCOPY VARCHAR2
6338: )IS
6339: l_return_status varchar2(1);
6340: l_version_number NUMBER := p_version_number;

Line 6392: ) RETURN OE_Blanket_PUB.Line_Rec_Type

6388: FUNCTION Query_Row
6389: ( p_line_id NUMBER
6390: ,p_version_number NUMBER := NULL
6391: ,p_phase_change_flag VARCHAR2 := NULL
6392: ) RETURN OE_Blanket_PUB.Line_Rec_Type
6393: IS
6394: l_return_status varchar2(1);
6395: l_line_tbl OE_Blanket_PUB.Line_Tbl_Type;
6396: --

Line 6395: l_line_tbl OE_Blanket_PUB.Line_Tbl_Type;

6391: ,p_phase_change_flag VARCHAR2 := NULL
6392: ) RETURN OE_Blanket_PUB.Line_Rec_Type
6393: IS
6394: l_return_status varchar2(1);
6395: l_line_tbl OE_Blanket_PUB.Line_Tbl_Type;
6396: --
6397: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6398: --
6399: BEGIN

Line 6718: (p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type

6714: END Lock_Blanket;
6715:
6716:
6717: PROCEDURE Default_Attributes
6718: (p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
6719: ,x_return_status OUT NOCOPY VARCHAR2
6720: ) IS
6721: --
6722: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 6895: (p_x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type

6891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6892: END Default_Attributes;
6893:
6894: PROCEDURE Default_Attributes
6895: (p_x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type
6896: ,p_default_from_header IN BOOLEAN
6897: ,x_return_status OUT NOCOPY VARCHAR2
6898: ) IS
6899: l_return_status varchar2(1);

Line 7146: p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,

7142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7143: END Load_Header;
7144:
7145: PROCEDURE GET_ORDER_NUMBER(
7146: p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,
7147: x_return_status OUT NOCOPY varchar2)
7148: IS
7149:
7150: l_order_number VARCHAR2(30):= NULL;

Line 7327: (p_entity_code => OE_BLANKET_PUB.G_ENTITY_BLANKET_HEADER

7323:
7324: -- Process Header requests
7325:
7326: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
7327: (p_entity_code => OE_BLANKET_PUB.G_ENTITY_BLANKET_HEADER
7328: ,p_delete => FND_API.G_TRUE
7329: ,x_return_status => l_return_status
7330: );
7331: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 7340: (p_entity_code => OE_BLANKET_PUB.G_ENTITY_BLANKET_LINE

7336:
7337: -- Process Line Level Request
7338:
7339: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
7340: (p_entity_code => OE_BLANKET_PUB.G_ENTITY_BLANKET_LINE
7341: ,p_delete => FND_API.G_TRUE
7342: ,x_return_status => l_return_status
7343: );
7344: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 7816: l_header_rec OE_Blanket_Pub.header_rec_type;

7812: x_msg_count OUT NOCOPY NUMBER,
7813: x_msg_data OUT NOCOPY VARCHAR2)
7814: IS
7815:
7816: l_header_rec OE_Blanket_Pub.header_rec_type;
7817: l_line_tbl OE_Blanket_Pub.line_tbl_type;
7818: l_control_rec OE_Blanket_Pub.control_rec_type;
7819: x_header_rec OE_Blanket_Pub.header_rec_type;
7820: x_line_tbl OE_Blanket_Pub.line_tbl_type;

Line 7817: l_line_tbl OE_Blanket_Pub.line_tbl_type;

7813: x_msg_data OUT NOCOPY VARCHAR2)
7814: IS
7815:
7816: l_header_rec OE_Blanket_Pub.header_rec_type;
7817: l_line_tbl OE_Blanket_Pub.line_tbl_type;
7818: l_control_rec OE_Blanket_Pub.control_rec_type;
7819: x_header_rec OE_Blanket_Pub.header_rec_type;
7820: x_line_tbl OE_Blanket_Pub.line_tbl_type;
7821: l_return_status VARCHAR2(1);

Line 7818: l_control_rec OE_Blanket_Pub.control_rec_type;

7814: IS
7815:
7816: l_header_rec OE_Blanket_Pub.header_rec_type;
7817: l_line_tbl OE_Blanket_Pub.line_tbl_type;
7818: l_control_rec OE_Blanket_Pub.control_rec_type;
7819: x_header_rec OE_Blanket_Pub.header_rec_type;
7820: x_line_tbl OE_Blanket_Pub.line_tbl_type;
7821: l_return_status VARCHAR2(1);
7822: l_header_id NUMBER;

Line 7819: x_header_rec OE_Blanket_Pub.header_rec_type;

7815:
7816: l_header_rec OE_Blanket_Pub.header_rec_type;
7817: l_line_tbl OE_Blanket_Pub.line_tbl_type;
7818: l_control_rec OE_Blanket_Pub.control_rec_type;
7819: x_header_rec OE_Blanket_Pub.header_rec_type;
7820: x_line_tbl OE_Blanket_Pub.line_tbl_type;
7821: l_return_status VARCHAR2(1);
7822: l_header_id NUMBER;
7823: l_count NUMBER;

Line 7820: x_line_tbl OE_Blanket_Pub.line_tbl_type;

7816: l_header_rec OE_Blanket_Pub.header_rec_type;
7817: l_line_tbl OE_Blanket_Pub.line_tbl_type;
7818: l_control_rec OE_Blanket_Pub.control_rec_type;
7819: x_header_rec OE_Blanket_Pub.header_rec_type;
7820: x_line_tbl OE_Blanket_Pub.line_tbl_type;
7821: l_return_status VARCHAR2(1);
7822: l_header_id NUMBER;
7823: l_count NUMBER;
7824: --

Line 8095: (p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_Rec_Type

8091: END Validate_Min_Max_Range;
8092:
8093:
8094: PROCEDURE Insert_History_Records
8095: (p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_Rec_Type
8096: ,p_line_tbl IN OUT NOCOPY OE_Blanket_PUB.Line_Tbl_Type
8097: ,p_version_flag in varchar2 := null
8098: ,p_phase_change_flag in varchar2 := null
8099: ,x_return_status IN OUT NOCOPY VARCHAR2

Line 8096: ,p_line_tbl IN OUT NOCOPY OE_Blanket_PUB.Line_Tbl_Type

8092:
8093:
8094: PROCEDURE Insert_History_Records
8095: (p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_Rec_Type
8096: ,p_line_tbl IN OUT NOCOPY OE_Blanket_PUB.Line_Tbl_Type
8097: ,p_version_flag in varchar2 := null
8098: ,p_phase_change_flag in varchar2 := null
8099: ,x_return_status IN OUT NOCOPY VARCHAR2
8100: )

Line 8909: ( p_HEADER_rec IN OE_Blanket_PUB.HEADER_Rec_Type

8905:
8906: END G_MISS_OE_AK_BLKT_HEADER_REC;
8907:
8908: PROCEDURE API_Rec_To_Rowtype_Rec
8909: ( p_HEADER_rec IN OE_Blanket_PUB.HEADER_Rec_Type
8910: , x_rowtype_rec IN OUT NOCOPY OE_AK_BLANKET_HEADERS_V%ROWTYPE
8911: ) IS
8912: BEGIN
8913:

Line 9025: , x_api_rec IN OUT NOCOPY OE_Blanket_PUB.HEADER_Rec_Type

9021: END API_Rec_To_RowType_Rec;
9022:
9023: PROCEDURE Rowtype_Rec_To_API_Rec
9024: ( p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
9025: , x_api_rec IN OUT NOCOPY OE_Blanket_PUB.HEADER_Rec_Type
9026: ) IS
9027: BEGIN
9028:
9029: x_api_rec.ACCOUNTING_RULE_ID := p_record.ACCOUNTING_RULE_ID;

Line 9208: ( p_LINE_rec IN OE_Blanket_PUB.LINE_Rec_Type

9204:
9205: END G_MISS_OE_AK_BLKT_LINE_REC;
9206:
9207: PROCEDURE Line_API_Rec_To_Rowtype_Rec
9208: ( p_LINE_rec IN OE_Blanket_PUB.LINE_Rec_Type
9209: , x_rowtype_rec IN OUT NOCOPY OE_AK_BLANKET_LINES_V%ROWTYPE
9210: ) IS
9211: BEGIN
9212:

Line 9305: , x_api_rec IN OUT NOCOPY OE_Blanket_PUB.LINE_Rec_Type

9301: END Line_API_Rec_To_RowType_Rec;
9302:
9303: PROCEDURE Line_Rowtype_Rec_To_API_Rec
9304: ( p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
9305: , x_api_rec IN OUT NOCOPY OE_Blanket_PUB.LINE_Rec_Type
9306: ) IS
9307: BEGIN
9308:
9309: x_api_rec.ACCOUNTING_RULE_ID := p_record.ACCOUNTING_RULE_ID;

Line 9401: (p_x_line_rec IN OUT NOCOPY OE_Blanket_Pub.Line_Rec_Type

9397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9398: END Line_Rowtype_Rec_To_API_Rec;
9399:
9400: PROCEDURE Get_Inventory_Item
9401: (p_x_line_rec IN OUT NOCOPY OE_Blanket_Pub.Line_Rec_Type
9402: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
9403: )
9404: IS
9405: l_attribute_value VARCHAR2(2000);

Line 9642: l_header_rec OE_Blanket_Pub.header_rec_type;

9638:
9639: IS
9640:
9641: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
9642: l_header_rec OE_Blanket_Pub.header_rec_type;
9643: l_line_tbl OE_Blanket_Pub.line_tbl_type;
9644: K NUMBER :=1;
9645: BEGIN
9646: --bug#5528507

Line 9643: l_line_tbl OE_Blanket_Pub.line_tbl_type;

9639: IS
9640:
9641: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
9642: l_header_rec OE_Blanket_Pub.header_rec_type;
9643: l_line_tbl OE_Blanket_Pub.line_tbl_type;
9644: K NUMBER :=1;
9645: BEGIN
9646: --bug#5528507
9647: x_return_status := FND_API.G_RET_STS_SUCCESS;