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_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.19.12010000.5 2008/11/18 01:51:05 smusanna 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 346: oe_blanket_pub.g_entity_blanket_LINE THEN

342: LOOP
343: IF oe_delayed_requests_pvt.g_delayed_requests(I).request_type = 'CREATE_BLANKET_PRICE_LIST'
344: AND
345: oe_delayed_requests_pvt.g_delayed_requests(I).entity_code =
346: oe_blanket_pub.g_entity_blanket_LINE THEN
347: if l_debug_level > 0 then
348: oe_debug_pub.add('Blanket In create price list - line');
349: end if;
350: IF oe_delayed_requests_pvt.g_delayed_requests(I).param1 IS NULL THEN

Line 913: ( p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type

909: END IF;
910: END Clear_price_list_line;
911:
912: PROCEDURE Validate_Attributes
913: ( p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
914: , p_old_header_rec IN OE_Blanket_PUB.Header_rec_type
915: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
916: , x_return_status OUT NOCOPY VARCHAR2
917: ) IS

Line 914: , p_old_header_rec IN OE_Blanket_PUB.Header_rec_type

910: END Clear_price_list_line;
911:
912: PROCEDURE Validate_Attributes
913: ( p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
914: , p_old_header_rec IN OE_Blanket_PUB.Header_rec_type
915: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
916: , x_return_status OUT NOCOPY VARCHAR2
917: ) IS
918: l_dummy VARCHAR2(10);

Line 1488: ( p_x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type

1484:
1485: END Validate_Attributes;
1486:
1487: PROCEDURE Validate_Attributes
1488: ( p_x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type
1489: , p_old_line_rec IN OE_Blanket_PUB.line_rec_type
1490: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1491: , x_return_status OUT NOCOPY VARCHAR2
1492: ) IS

Line 1489: , p_old_line_rec IN OE_Blanket_PUB.line_rec_type

1485: END Validate_Attributes;
1486:
1487: PROCEDURE Validate_Attributes
1488: ( p_x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type
1489: , p_old_line_rec IN OE_Blanket_PUB.line_rec_type
1490: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1491: , x_return_status OUT NOCOPY VARCHAR2
1492: ) IS
1493: --{ Bug # 5562785

Line 2213: ( p_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type

2209: --bug 4893057
2210:
2211:
2212: PROCEDURE Validate_Entity
2213: ( p_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type
2214: , p_old_line_rec IN OE_Blanket_PUB.Line_rec_type := OE_Blanket_PUB.G_MISS_BLANKET_LINE_REC
2215: , x_return_status OUT NOCOPY VARCHAR2
2216: )IS
2217:

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

2210:
2211:
2212: PROCEDURE Validate_Entity
2213: ( p_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type
2214: , p_old_line_rec IN OE_Blanket_PUB.Line_rec_type := OE_Blanket_PUB.G_MISS_BLANKET_LINE_REC
2215: , x_return_status OUT NOCOPY VARCHAR2
2216: )IS
2217:
2218: l_dummy varchar2(30);

Line 2220: l_old_line_rec OE_Blanket_PUB.Line_rec_type := p_old_line_rec;

2216: )IS
2217:
2218: l_dummy varchar2(30);
2219: l_valid_line_number varchar2(1);
2220: l_old_line_rec OE_Blanket_PUB.Line_rec_type := p_old_line_rec;
2221: l_site_use_code VARCHAR2(30);
2222: l_return_status varchar2(1);
2223:
2224: --

Line 2389: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

2385: OE_Order_UTIL.Get_Attribute_Name('LINE_NUMBER'));
2386: OE_MSG_PUB.Add;
2387: ELSE
2388: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
2389: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
2390: p_Entity_Id => p_line_rec.line_id,
2391: p_requesting_entity_code =>
2392: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
2393: p_requesting_entity_id => p_line_rec.line_id,

Line 2392: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

2388: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
2389: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
2390: p_Entity_Id => p_line_rec.line_id,
2391: p_requesting_entity_code =>
2392: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
2393: p_requesting_entity_id => p_line_rec.line_id,
2394: p_request_type => 'VALIDATE_BLANKET_LINE_NUMBER',
2395: p_param1 => p_line_rec.header_id,
2396: p_param2 => p_line_rec.line_number,

Line 2470: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE ,

2466: end if;
2467:
2468: --validate item uniqueness
2469: OE_Delayed_Requests_Pvt.Log_Request(p_Entity_Code =>
2470: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE ,
2471: p_Entity_Id => p_line_rec.line_id,
2472: p_requesting_entity_code =>
2473: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
2474: p_requesting_entity_id => p_line_rec.line_id,

Line 2473: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

2469: OE_Delayed_Requests_Pvt.Log_Request(p_Entity_Code =>
2470: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE ,
2471: p_Entity_Id => p_line_rec.line_id,
2472: p_requesting_entity_code =>
2473: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
2474: p_requesting_entity_id => p_line_rec.line_id,
2475: p_request_type => 'VALIDATE_BLANKET_INV_ITEM',
2476: p_param1 => p_line_rec.inventory_item_id,
2477: p_param2 => p_line_rec.header_id,

Line 2729: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE ,

2725:
2726: IF NOT OE_GLOBALS.EQUAL (p_line_rec.end_date_active, l_old_line_rec.end_date_active) THEN
2727: --validate item uniqueness
2728: OE_Delayed_Requests_Pvt.Log_Request(p_Entity_Code =>
2729: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE ,
2730: p_Entity_Id => p_line_rec.line_id,
2731: p_requesting_entity_code =>
2732: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
2733: p_requesting_entity_id => p_line_rec.line_id,

Line 2732: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

2728: OE_Delayed_Requests_Pvt.Log_Request(p_Entity_Code =>
2729: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE ,
2730: p_Entity_Id => p_line_rec.line_id,
2731: p_requesting_entity_code =>
2732: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
2733: p_requesting_entity_id => p_line_rec.line_id,
2734: p_request_type => 'VALIDATE_BLANKET_INV_ITEM',
2735: p_param1 => p_line_rec.inventory_item_id,
2736: p_param2 => p_line_rec.header_id,

Line 2918: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

2914: -- IF p_line_rec.unit_list_price IS NOT NULL
2915: IF NOT OE_GLOBALS.EQUAL(p_line_rec.unit_list_price,p_old_line_rec.unit_list_price)
2916: THEN
2917: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
2918: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
2919: p_Entity_Id => p_line_rec.line_id,
2920: p_requesting_entity_code =>
2921: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
2922: p_requesting_entity_id => p_line_rec.line_id,

Line 2921: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

2917: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
2918: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
2919: p_Entity_Id => p_line_rec.line_id,
2920: p_requesting_entity_code =>
2921: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
2922: p_requesting_entity_id => p_line_rec.line_id,
2923: p_request_type => 'CREATE_BLANKET_PRICE_LIST',
2924: p_param1=> p_line_rec.unit_list_price,
2925: p_param2 => nvl(p_line_rec.pricing_uom,

Line 2996: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

2992: oe_debug_pub.add('log ADD_BLANKET_PRICE_LIST_LINE');
2993: end if;
2994:
2995: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
2996: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
2997: p_Entity_Id => p_line_rec.line_id,
2998: p_requesting_entity_code =>
2999: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3000: p_requesting_entity_id => p_line_rec.line_id,

Line 2999: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

2995: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
2996: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
2997: p_Entity_Id => p_line_rec.line_id,
2998: p_requesting_entity_code =>
2999: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3000: p_requesting_entity_id => p_line_rec.line_id,
3001: p_request_type => 'ADD_BLANKET_PRICE_LIST_LINE',
3002: p_param1=> p_line_rec.unit_list_price,
3003: p_param2 => nvl(p_line_rec.pricing_uom,

Line 3045: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

3041: oe_debug_pub.add('Log delayed request: CLEAR_BLANKET_PRICE_LIST_LINE');
3042: end if;
3043:
3044: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
3045: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3046: p_Entity_Id => p_line_rec.line_id,
3047: p_requesting_entity_code =>
3048: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3049: p_requesting_entity_id => p_line_rec.line_id,

Line 3048: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

3044: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
3045: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3046: p_Entity_Id => p_line_rec.line_id,
3047: p_requesting_entity_code =>
3048: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3049: p_requesting_entity_id => p_line_rec.line_id,
3050: p_request_type => OE_GLOBALS.G_CLEAR_BLKT_PRICE_LIST_LINE,
3051: p_param1=> p_line_rec.qp_list_line_id,
3052: p_param2 => g_header_rec.new_price_list_id,

Line 3090: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

3086: x_return_status := FND_API.G_RET_STS_ERROR;
3087: ELSE
3088: -- Log delayed request to create new modifier list line
3089: oe_delayed_requests_pvt.Log_request
3090: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3091: p_Entity_Id => p_line_rec.line_id,
3092: p_requesting_entity_code =>
3093: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3094: p_requesting_entity_id => p_line_rec.line_id,

Line 3093: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

3089: oe_delayed_requests_pvt.Log_request
3090: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3091: p_Entity_Id => p_line_rec.line_id,
3092: p_requesting_entity_code =>
3093: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3094: p_requesting_entity_id => p_line_rec.line_id,
3095: p_request_type => 'ADD_MODIFIER_LIST_LINE',
3096: p_param1 => p_line_rec.discount_percent,
3097: p_param2 => p_line_rec.discount_amount,

Line 3142: ( p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type

3138:
3139: END Validate_Entity;
3140:
3141: PROCEDURE Validate_Entity
3142: ( p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
3143: , p_old_header_rec IN OE_Blanket_PUB.Header_rec_type := OE_Blanket_PUB.g_miss_header_rec
3144: , x_return_status OUT NOCOPY VARCHAR2
3145: )IS
3146: l_return_status varchar2(1);

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

3139: END Validate_Entity;
3140:
3141: PROCEDURE Validate_Entity
3142: ( p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
3143: , p_old_header_rec IN OE_Blanket_PUB.Header_rec_type := OE_Blanket_PUB.g_miss_header_rec
3144: , x_return_status OUT NOCOPY VARCHAR2
3145: )IS
3146: l_return_status varchar2(1);
3147: l_dummy varchar2(30);

Line 3148: l_old_header_rec OE_Blanket_PUB.Header_rec_type := p_old_header_rec;

3144: , x_return_status OUT NOCOPY VARCHAR2
3145: )IS
3146: l_return_status varchar2(1);
3147: l_dummy varchar2(30);
3148: l_old_header_rec OE_Blanket_PUB.Header_rec_type := p_old_header_rec;
3149: l_db_version_number NUMBER;
3150: -- 11i10 Pricing Changes
3151: l_list_header_id NUMBER;
3152: l_new_pl_name VARCHAR2(240);

Line 3914: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER

3910: END IF;
3911:
3912: IF NOT OE_GLOBALS.Equal(x_return_status, FND_API.G_RET_STS_ERROR) THEN
3913: OE_Delayed_Requests_PVT.Log_Request
3914: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
3915: ,p_Entity_Id => p_header_rec.header_id
3916: ,p_requesting_entity_code =>
3917: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
3918: ,p_requesting_entity_id => p_header_rec.header_id

Line 3917: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER

3913: OE_Delayed_Requests_PVT.Log_Request
3914: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
3915: ,p_Entity_Id => p_header_rec.header_id
3916: ,p_requesting_entity_code =>
3917: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
3918: ,p_requesting_entity_id => p_header_rec.header_id
3919: ,p_request_type => 'RECORD_BLANKET_HISTORY'
3920: ,p_param1=> p_header_rec.revision_change_reason_code
3921: ,p_long_param1 => p_header_rec.revision_change_comments

Line 3944: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER

3940: if (NOT OE_GLOBALS.Equal(p_header_rec.start_date_active,l_old_header_rec.start_date_active) OR
3941: NOT OE_GLOBALS.Equal(p_header_rec.end_date_active,l_old_header_rec.end_date_active))
3942: THEN
3943: OE_Delayed_Requests_PVT.Log_Request
3944: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
3945: ,p_Entity_Id => p_header_rec.header_id
3946: ,p_requesting_entity_code =>
3947: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
3948: ,p_requesting_entity_id => p_header_rec.header_id

Line 3947: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER

3943: OE_Delayed_Requests_PVT.Log_Request
3944: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
3945: ,p_Entity_Id => p_header_rec.header_id
3946: ,p_requesting_entity_code =>
3947: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
3948: ,p_requesting_entity_id => p_header_rec.header_id
3949: ,p_request_type => 'BLANKET_DATE_CHANGE'
3950: ,x_return_status => l_return_status);
3951: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 3966: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER

3962: THEN
3963: if (NOT OE_GLOBALS.Equal(p_header_rec.sold_to_org_id,l_old_header_rec.sold_to_org_id) and
3964: p_header_rec.operation = oe_globals.g_opr_update) THEN
3965: OE_Delayed_Requests_PVT.Log_Request
3966: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
3967: ,p_Entity_Id => p_header_rec.header_id
3968: ,p_param1 => p_header_rec.sold_to_org_id
3969: ,p_requesting_entity_code =>
3970: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER

Line 3970: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER

3966: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
3967: ,p_Entity_Id => p_header_rec.header_id
3968: ,p_param1 => p_header_rec.sold_to_org_id
3969: ,p_requesting_entity_code =>
3970: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
3971: ,p_requesting_entity_id => p_header_rec.header_id
3972: ,p_request_type => 'VALIDATE_BLANKET_SOLD_TO'
3973: ,x_return_status => l_return_status);
3974: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 3990: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER,

3986: else
3987: l_new_pl_name := p_header_rec.price_list_name;
3988: end if;
3989: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
3990: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER,
3991: p_Entity_Id => p_header_rec.header_id,
3992: p_requesting_entity_code =>
3993: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER,
3994: p_requesting_entity_id => p_header_rec.header_id,

Line 3993: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER,

3989: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
3990: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER,
3991: p_Entity_Id => p_header_rec.header_id,
3992: p_requesting_entity_code =>
3993: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER,
3994: p_requesting_entity_id => p_header_rec.header_id,
3995: p_request_type => 'CREATE_BLANKET_PRICE_LIST',
3996: -- 11i10 Pricing Changes
3997: p_param1 => l_new_pl_name,

Line 4016: (p_entity_code => oe_blanket_pub.g_entity_blanket_header,

4012: -- 11i10 Pricing Changes
4013: -- Log request to create new modifier
4014: IF g_new_modifier_list THEN
4015: oe_delayed_requests_pvt.Log_request
4016: (p_entity_code => oe_blanket_pub.g_entity_blanket_header,
4017: p_Entity_Id => p_header_rec.header_id,
4018: p_requesting_entity_code =>
4019: oe_blanket_pub.g_entity_blanket_header,
4020: p_requesting_entity_id => p_header_rec.header_id,

Line 4019: oe_blanket_pub.g_entity_blanket_header,

4015: oe_delayed_requests_pvt.Log_request
4016: (p_entity_code => oe_blanket_pub.g_entity_blanket_header,
4017: p_Entity_Id => p_header_rec.header_id,
4018: p_requesting_entity_code =>
4019: oe_blanket_pub.g_entity_blanket_header,
4020: p_requesting_entity_id => p_header_rec.header_id,
4021: p_request_type => 'CREATE_MODIFIER_LIST',
4022: p_param1 => p_header_rec.new_modifier_list_name,
4023: p_param2 => p_header_rec.transactional_curr_code,

Line 4046: (p_header_rec IN OE_Blanket_PUB.Header_rec_type

4042: END IF;
4043: END Validate_Entity;
4044:
4045: PROCEDURE Insert_Row
4046: (p_header_rec IN OE_Blanket_PUB.Header_rec_type
4047: ,x_return_status OUT NOCOPY VARCHAR2)
4048: IS
4049: l_org_id NUMBER;
4050: l_upgraded_flag varchar2(1) ;

Line 4298: ( p_header_rec IN OE_Blanket_PUB.Header_rec_type

4294:
4295: End Insert_Row;
4296:
4297: PROCEDURE Update_Row
4298: ( p_header_rec IN OE_Blanket_PUB.Header_rec_type
4299: , x_return_status OUT NOCOPY VARCHAR2
4300: )
4301: IS
4302: l_return_status VARCHAR2(1);

Line 4603: ( p_line_rec IN OE_Blanket_PUB.Line_rec_type

4599:
4600: End Delete_Row;
4601:
4602: PROCEDURE Insert_Row
4603: ( p_line_rec IN OE_Blanket_PUB.Line_rec_type
4604: , x_return_status OUT NOCOPY VARCHAR2)
4605: IS
4606: l_org_id NUMBER ;
4607: l_sold_from_org NUMBER;

Line 4866: ( p_line_rec IN OE_Blanket_PUB.Line_rec_type

4862:
4863: End Insert_Row;
4864:
4865: PROCEDURE Update_Row
4866: ( p_line_rec IN OE_Blanket_PUB.Line_rec_type
4867: , x_return_status OUT NOCOPY VARCHAR2)
4868: IS
4869: l_return_status VARCHAR2(1);
4870: --

Line 5117: , x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type

5113: PROCEDURE Query_Header
5114: ( p_header_id IN NUMBER
5115: , p_version_number IN NUMBER := NULL
5116: , p_phase_change_flag IN VARCHAR2 := NULL
5117: , x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
5118: , x_return_status OUT NOCOPY VARCHAR2
5119: )IS
5120:
5121: CURSOR l_hdr_csr IS

Line 5584: ,x_line_tbl IN OUT NOCOPY OE_Blanket_PUB.line_tbl_type

5580: (p_line_id IN NUMBER := NULL
5581: ,p_header_id IN NUMBER := NULL
5582: ,p_version_number IN NUMBER := NULL
5583: ,p_phase_change_flag IN VARCHAR2 := NULL
5584: ,x_line_tbl IN OUT NOCOPY OE_Blanket_PUB.line_tbl_type
5585: ,x_return_status OUT NOCOPY VARCHAR2
5586: )IS
5587:
5588: l_org_id NUMBER;

Line 6141: ,p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type

6137: PROCEDURE Query_blanket
6138: (p_header_id IN NUMBER
6139: ,p_version_number IN NUMBER := NULL
6140: ,p_phase_change_flag IN VARCHAR2 := NULL
6141: ,p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
6142: ,p_x_line_tbl IN OUT NOCOPY OE_Blanket_PUB.line_tbl_type
6143: ,x_return_status OUT NOCOPY VARCHAR2
6144: )IS
6145: l_return_status varchar2(1);

Line 6142: ,p_x_line_tbl IN OUT NOCOPY OE_Blanket_PUB.line_tbl_type

6138: (p_header_id IN NUMBER
6139: ,p_version_number IN NUMBER := NULL
6140: ,p_phase_change_flag IN VARCHAR2 := NULL
6141: ,p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
6142: ,p_x_line_tbl IN OUT NOCOPY OE_Blanket_PUB.line_tbl_type
6143: ,x_return_status OUT NOCOPY VARCHAR2
6144: )IS
6145: l_return_status varchar2(1);
6146: l_version_number NUMBER := p_version_number;

Line 6198: ) RETURN OE_Blanket_PUB.Line_Rec_Type

6194: FUNCTION Query_Row
6195: ( p_line_id NUMBER
6196: ,p_version_number NUMBER := NULL
6197: ,p_phase_change_flag VARCHAR2 := NULL
6198: ) RETURN OE_Blanket_PUB.Line_Rec_Type
6199: IS
6200: l_return_status varchar2(1);
6201: l_line_tbl OE_Blanket_PUB.Line_Tbl_Type;
6202: --

Line 6201: l_line_tbl OE_Blanket_PUB.Line_Tbl_Type;

6197: ,p_phase_change_flag VARCHAR2 := NULL
6198: ) RETURN OE_Blanket_PUB.Line_Rec_Type
6199: IS
6200: l_return_status varchar2(1);
6201: l_line_tbl OE_Blanket_PUB.Line_Tbl_Type;
6202: --
6203: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6204: --
6205: BEGIN

Line 6524: (p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type

6520: END Lock_Blanket;
6521:
6522:
6523: PROCEDURE Default_Attributes
6524: (p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
6525: ,x_return_status OUT NOCOPY VARCHAR2
6526: ) IS
6527: --
6528: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 6701: (p_x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type

6697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6698: END Default_Attributes;
6699:
6700: PROCEDURE Default_Attributes
6701: (p_x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type
6702: ,p_default_from_header IN BOOLEAN
6703: ,x_return_status OUT NOCOPY VARCHAR2
6704: ) IS
6705: l_return_status varchar2(1);

Line 6952: p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,

6948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6949: END Load_Header;
6950:
6951: PROCEDURE GET_ORDER_NUMBER(
6952: p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,
6953: x_return_status OUT NOCOPY varchar2)
6954: IS
6955:
6956: l_order_number VARCHAR2(30):= NULL;

Line 7133: (p_entity_code => OE_BLANKET_PUB.G_ENTITY_BLANKET_HEADER

7129:
7130: -- Process Header requests
7131:
7132: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
7133: (p_entity_code => OE_BLANKET_PUB.G_ENTITY_BLANKET_HEADER
7134: ,p_delete => FND_API.G_TRUE
7135: ,x_return_status => l_return_status
7136: );
7137: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 7146: (p_entity_code => OE_BLANKET_PUB.G_ENTITY_BLANKET_LINE

7142:
7143: -- Process Line Level Request
7144:
7145: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
7146: (p_entity_code => OE_BLANKET_PUB.G_ENTITY_BLANKET_LINE
7147: ,p_delete => FND_API.G_TRUE
7148: ,x_return_status => l_return_status
7149: );
7150: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 7619: l_header_rec OE_Blanket_Pub.header_rec_type;

7615: x_msg_count OUT NOCOPY NUMBER,
7616: x_msg_data OUT NOCOPY VARCHAR2)
7617: IS
7618:
7619: l_header_rec OE_Blanket_Pub.header_rec_type;
7620: l_line_tbl OE_Blanket_Pub.line_tbl_type;
7621: l_control_rec OE_Blanket_Pub.control_rec_type;
7622: x_header_rec OE_Blanket_Pub.header_rec_type;
7623: x_line_tbl OE_Blanket_Pub.line_tbl_type;

Line 7620: l_line_tbl OE_Blanket_Pub.line_tbl_type;

7616: x_msg_data OUT NOCOPY VARCHAR2)
7617: IS
7618:
7619: l_header_rec OE_Blanket_Pub.header_rec_type;
7620: l_line_tbl OE_Blanket_Pub.line_tbl_type;
7621: l_control_rec OE_Blanket_Pub.control_rec_type;
7622: x_header_rec OE_Blanket_Pub.header_rec_type;
7623: x_line_tbl OE_Blanket_Pub.line_tbl_type;
7624: l_return_status VARCHAR2(1);

Line 7621: l_control_rec OE_Blanket_Pub.control_rec_type;

7617: IS
7618:
7619: l_header_rec OE_Blanket_Pub.header_rec_type;
7620: l_line_tbl OE_Blanket_Pub.line_tbl_type;
7621: l_control_rec OE_Blanket_Pub.control_rec_type;
7622: x_header_rec OE_Blanket_Pub.header_rec_type;
7623: x_line_tbl OE_Blanket_Pub.line_tbl_type;
7624: l_return_status VARCHAR2(1);
7625: l_header_id NUMBER;

Line 7622: x_header_rec OE_Blanket_Pub.header_rec_type;

7618:
7619: l_header_rec OE_Blanket_Pub.header_rec_type;
7620: l_line_tbl OE_Blanket_Pub.line_tbl_type;
7621: l_control_rec OE_Blanket_Pub.control_rec_type;
7622: x_header_rec OE_Blanket_Pub.header_rec_type;
7623: x_line_tbl OE_Blanket_Pub.line_tbl_type;
7624: l_return_status VARCHAR2(1);
7625: l_header_id NUMBER;
7626: l_count NUMBER;

Line 7623: x_line_tbl OE_Blanket_Pub.line_tbl_type;

7619: l_header_rec OE_Blanket_Pub.header_rec_type;
7620: l_line_tbl OE_Blanket_Pub.line_tbl_type;
7621: l_control_rec OE_Blanket_Pub.control_rec_type;
7622: x_header_rec OE_Blanket_Pub.header_rec_type;
7623: x_line_tbl OE_Blanket_Pub.line_tbl_type;
7624: l_return_status VARCHAR2(1);
7625: l_header_id NUMBER;
7626: l_count NUMBER;
7627: --

Line 7898: (p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_Rec_Type

7894: END Validate_Min_Max_Range;
7895:
7896:
7897: PROCEDURE Insert_History_Records
7898: (p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_Rec_Type
7899: ,p_line_tbl IN OUT NOCOPY OE_Blanket_PUB.Line_Tbl_Type
7900: ,p_version_flag in varchar2 := null
7901: ,p_phase_change_flag in varchar2 := null
7902: ,x_return_status IN OUT NOCOPY VARCHAR2

Line 7899: ,p_line_tbl IN OUT NOCOPY OE_Blanket_PUB.Line_Tbl_Type

7895:
7896:
7897: PROCEDURE Insert_History_Records
7898: (p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_Rec_Type
7899: ,p_line_tbl IN OUT NOCOPY OE_Blanket_PUB.Line_Tbl_Type
7900: ,p_version_flag in varchar2 := null
7901: ,p_phase_change_flag in varchar2 := null
7902: ,x_return_status IN OUT NOCOPY VARCHAR2
7903: )

Line 8712: ( p_HEADER_rec IN OE_Blanket_PUB.HEADER_Rec_Type

8708:
8709: END G_MISS_OE_AK_BLKT_HEADER_REC;
8710:
8711: PROCEDURE API_Rec_To_Rowtype_Rec
8712: ( p_HEADER_rec IN OE_Blanket_PUB.HEADER_Rec_Type
8713: , x_rowtype_rec IN OUT NOCOPY OE_AK_BLANKET_HEADERS_V%ROWTYPE
8714: ) IS
8715: BEGIN
8716:

Line 8828: , x_api_rec IN OUT NOCOPY OE_Blanket_PUB.HEADER_Rec_Type

8824: END API_Rec_To_RowType_Rec;
8825:
8826: PROCEDURE Rowtype_Rec_To_API_Rec
8827: ( p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
8828: , x_api_rec IN OUT NOCOPY OE_Blanket_PUB.HEADER_Rec_Type
8829: ) IS
8830: BEGIN
8831:
8832: x_api_rec.ACCOUNTING_RULE_ID := p_record.ACCOUNTING_RULE_ID;

Line 9011: ( p_LINE_rec IN OE_Blanket_PUB.LINE_Rec_Type

9007:
9008: END G_MISS_OE_AK_BLKT_LINE_REC;
9009:
9010: PROCEDURE Line_API_Rec_To_Rowtype_Rec
9011: ( p_LINE_rec IN OE_Blanket_PUB.LINE_Rec_Type
9012: , x_rowtype_rec IN OUT NOCOPY OE_AK_BLANKET_LINES_V%ROWTYPE
9013: ) IS
9014: BEGIN
9015:

Line 9108: , x_api_rec IN OUT NOCOPY OE_Blanket_PUB.LINE_Rec_Type

9104: END Line_API_Rec_To_RowType_Rec;
9105:
9106: PROCEDURE Line_Rowtype_Rec_To_API_Rec
9107: ( p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
9108: , x_api_rec IN OUT NOCOPY OE_Blanket_PUB.LINE_Rec_Type
9109: ) IS
9110: BEGIN
9111:
9112: x_api_rec.ACCOUNTING_RULE_ID := p_record.ACCOUNTING_RULE_ID;

Line 9204: (p_x_line_rec IN OUT NOCOPY OE_Blanket_Pub.Line_Rec_Type

9200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9201: END Line_Rowtype_Rec_To_API_Rec;
9202:
9203: PROCEDURE Get_Inventory_Item
9204: (p_x_line_rec IN OUT NOCOPY OE_Blanket_Pub.Line_Rec_Type
9205: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
9206: )
9207: IS
9208: l_attribute_value VARCHAR2(2000);

Line 9445: l_header_rec OE_Blanket_Pub.header_rec_type;

9441:
9442: IS
9443:
9444: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
9445: l_header_rec OE_Blanket_Pub.header_rec_type;
9446: l_line_tbl OE_Blanket_Pub.line_tbl_type;
9447: K NUMBER :=1;
9448: BEGIN
9449: --bug#5528507

Line 9446: l_line_tbl OE_Blanket_Pub.line_tbl_type;

9442: IS
9443:
9444: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
9445: l_header_rec OE_Blanket_Pub.header_rec_type;
9446: l_line_tbl OE_Blanket_Pub.line_tbl_type;
9447: K NUMBER :=1;
9448: BEGIN
9449: --bug#5528507
9450: x_return_status := FND_API.G_RET_STS_SUCCESS;