DBA Data[Home] [Help]

APPS.OE_BLANKET_FORM_CONTROL dependencies on OE_BLANKET_PUB

Line 8: TYPE HEADER_CACHE IS TABLE OF oe_blanket_pub.header_rec_type INDEX BY BINARY_INTEGER;

4: -----------------------------------------------------------
5: -- Package Globals
6: -----------------------------------------------------------
7:
8: TYPE HEADER_CACHE IS TABLE OF oe_blanket_pub.header_rec_type INDEX BY BINARY_INTEGER;
9: TYPE LINE_CACHE IS TABLE OF oe_blanket_pub.line_rec_type INDEX BY BINARY_INTEGER;
10:
11: G_Header_Cache_Rec Header_Cache;
12: G_Line_Cache_Rec Line_Cache;

Line 9: TYPE LINE_CACHE IS TABLE OF oe_blanket_pub.line_rec_type INDEX BY BINARY_INTEGER;

5: -- Package Globals
6: -----------------------------------------------------------
7:
8: TYPE HEADER_CACHE IS TABLE OF oe_blanket_pub.header_rec_type INDEX BY BINARY_INTEGER;
9: TYPE LINE_CACHE IS TABLE OF oe_blanket_pub.line_rec_type INDEX BY BINARY_INTEGER;
10:
11: G_Header_Cache_Rec Header_Cache;
12: G_Line_Cache_Rec Line_Cache;
13: G_Blanket_Line_Number Number;

Line 15: G_Header_Security_Cache oe_blanket_pub.header_rec_type;

11: G_Header_Cache_Rec Header_Cache;
12: G_Line_Cache_Rec Line_Cache;
13: G_Blanket_Line_Number Number;
14:
15: G_Header_Security_Cache oe_blanket_pub.header_rec_type;
16: G_Line_Security_Cache oe_blanket_pub.line_rec_type;
17:
18:
19:

Line 16: G_Line_Security_Cache oe_blanket_pub.line_rec_type;

12: G_Line_Cache_Rec Line_Cache;
13: G_Blanket_Line_Number Number;
14:
15: G_Header_Security_Cache oe_blanket_pub.header_rec_type;
16: G_Line_Security_Cache oe_blanket_pub.line_rec_type;
17:
18:
19:
20: ----------------------------------------------------------

Line 23: ( p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_Rec_type

19:
20: ----------------------------------------------------------
21: PROCEDURE Header_Value_Conversion
22: ----------------------------------------------------------
23: ( p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_Rec_type
24: , p_header_val_rec IN OUT NOCOPY OE_Order_PUB.Header_Val_Rec_Type
25: )IS
26: l_header_rec OE_Order_PUB.Header_Rec_Type;
27: l_order_type varchar2(240);

Line 84: ( p_line_rec IN OUT NOCOPY OE_Blanket_PUB.Line_Rec_Type

80:
81: ----------------------------------------------------------
82: PROCEDURE Line_Value_Conversion
83: ----------------------------------------------------------
84: ( p_line_rec IN OUT NOCOPY OE_Blanket_PUB.Line_Rec_Type
85: , p_line_val_rec IN OUT NOCOPY OE_Order_PUB.Line_Val_Rec_Type
86: )IS
87: l_line_rec OE_Order_PUB.Line_Rec_Type;
88: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 147: ( p_Header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_Rec_Type

143:
144: ----------------------------------------------------------
145: PROCEDURE Populate_Header_Values_ID
146: ----------------------------------------------------------
147: ( p_Header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_Rec_Type
148: , p_Header_val_rec IN OUT NOCOPY OE_Order_PUB.Header_Val_Rec_Type
149: )IS
150: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
151:

Line 290: ( p_Line_rec IN OUT NOCOPY OE_Blanket_PUB.Line_Rec_Type

286:
287: ----------------------------------------------------------
288: PROCEDURE Populate_Line_Values_ID
289: ----------------------------------------------------------
290: ( p_Line_rec IN OUT NOCOPY OE_Blanket_PUB.Line_Rec_Type
291: , p_line_val_rec IN OUT NOCOPY OE_Order_PUB.Line_Val_Rec_Type
292: )IS
293: BEGIN
294: oe_debug_pub.add('enter Populate_Line_Values_ID');

Line 411: (p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,

407:
408: ----------------------------------------------------------
409: PROCEDURE Validate_Entity
410: ----------------------------------------------------------
411: (p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,
412: x_return_status OUT NOCOPY VARCHAR2,
413: x_msg_count OUT NOCOPY NUMBER,
414: x_msg_data OUT NOCOPY VARCHAR2
415: )IS

Line 416: l_old_header_rec oe_blanket_pub.header_rec_type;

412: x_return_status OUT NOCOPY VARCHAR2,
413: x_msg_count OUT NOCOPY NUMBER,
414: x_msg_data OUT NOCOPY VARCHAR2
415: )IS
416: l_old_header_rec oe_blanket_pub.header_rec_type;
417: l_old_blanket_number number;
418: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Entity';
419: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
420: BEGIN

Line 546: (p_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type,

542:
543: ----------------------------------------------------------
544: PROCEDURE Validate_Entity
545: ----------------------------------------------------------
546: (p_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type,
547: x_return_status IN OUT NOCOPY VARCHAR2,
548: x_msg_count OUT NOCOPY NUMBER,
549: x_msg_data OUT NOCOPY VARCHAR2
550:

Line 552: l_old_line_rec oe_blanket_pub.line_rec_type;

548: x_msg_count OUT NOCOPY NUMBER,
549: x_msg_data OUT NOCOPY VARCHAR2
550:
551: ) IS
552: l_old_line_rec oe_blanket_pub.line_rec_type;
553: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Entity';
554: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
555: BEGIN
556:

Line 643: (p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,

639:
640: ----------------------------------------------------------
641: PROCEDURE Insert_Row
642: ----------------------------------------------------------
643: (p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,
644: x_return_status OUT NOCOPY VARCHAR2,
645: x_msg_count OUT NOCOPY NUMBER,
646: x_msg_data OUT NOCOPY VARCHAR2
647: )

Line 714: (p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,

710:
711: ----------------------------------------------------------
712: PROCEDURE Update_Row
713: ----------------------------------------------------------
714: (p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,
715: x_return_status OUT NOCOPY VARCHAR2,
716: x_msg_count OUT NOCOPY NUMBER,
717: x_msg_data OUT NOCOPY VARCHAR2
718: )

Line 860: (p_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type,

856:
857: ----------------------------------------------------------
858: PROCEDURE Insert_Row
859: ----------------------------------------------------------
860: (p_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type,
861: x_return_status OUT NOCOPY VARCHAR2,
862: x_msg_count OUT NOCOPY NUMBER,
863: x_msg_data OUT NOCOPY VARCHAR2
864: )

Line 931: ( p_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type,

927:
928: ----------------------------------------------------------
929: PROCEDURE Update_Row
930: ----------------------------------------------------------
931: ( p_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type,
932: x_return_status OUT NOCOPY VARCHAR2,
933: x_msg_count OUT NOCOPY NUMBER,
934: x_msg_data OUT NOCOPY VARCHAR2
935: )

Line 1073: (p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,

1069:
1070: ----------------------------------------------------------
1071: PROCEDURE Default_Attributes
1072: ----------------------------------------------------------
1073: (p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,
1074: x_msg_count OUT NOCOPY NUMBER,
1075: x_msg_data OUT NOCOPY VARCHAR2,
1076: x_return_status OUT NOCOPY VARCHAR2
1077: )

Line 1156: (p_x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type,

1152:
1153: ----------------------------------------------------------
1154: PROCEDURE Default_Attributes
1155: ----------------------------------------------------------
1156: (p_x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type,
1157: x_msg_count OUT NOCOPY NUMBER,
1158: x_msg_data OUT NOCOPY VARCHAR2,
1159: x_return_status OUT NOCOPY VARCHAR2
1160: )

Line 1240: l_dummy_header_rec oe_blanket_pub.header_rec_type;

1236: l_api_name CONSTANT VARCHAR2(30) := 'Process_Object';
1237: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1238: --bug#4691643
1239: I number := 1;
1240: l_dummy_header_rec oe_blanket_pub.header_rec_type;
1241: l_dummy_line_rec oe_blanket_pub.line_rec_type;
1242: l_request_rec OE_Order_PUB.Request_Rec_Type;
1243: l_return_status varchar2(30);
1244: BEGIN

Line 1241: l_dummy_line_rec oe_blanket_pub.line_rec_type;

1237: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1238: --bug#4691643
1239: I number := 1;
1240: l_dummy_header_rec oe_blanket_pub.header_rec_type;
1241: l_dummy_line_rec oe_blanket_pub.line_rec_type;
1242: l_request_rec OE_Order_PUB.Request_Rec_Type;
1243: l_return_status varchar2(30);
1244: BEGIN
1245:

Line 1502: p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,

1498: ----------------------------------------------------------
1499: PROCEDURE Check_Sec_Header_Attr
1500: ----------------------------------------------------------
1501: (x_return_status IN OUT NOCOPY varchar2,
1502: p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,
1503: p_old_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,
1504: -- 11i10 Pricing Changes
1505: p_column_name IN VARCHAR2 DEFAULT NULL,
1506: x_msg_count IN OUT NOCOPY NUMBER,

Line 1503: p_old_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,

1499: PROCEDURE Check_Sec_Header_Attr
1500: ----------------------------------------------------------
1501: (x_return_status IN OUT NOCOPY varchar2,
1502: p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,
1503: p_old_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,
1504: -- 11i10 Pricing Changes
1505: p_column_name IN VARCHAR2 DEFAULT NULL,
1506: x_msg_count IN OUT NOCOPY NUMBER,
1507: x_msg_data IN OUT NOCOPY VARCHAR2)

Line 1612: p_line_rec IN OUT NOCOPY OE_Blanket_PUB.Line_rec_type,

1608: ----------------------------------------------------------
1609: PROCEDURE Check_Sec_Line_Attr
1610: ----------------------------------------------------------
1611: (x_return_status IN OUT NOCOPY varchar2,
1612: p_line_rec IN OUT NOCOPY OE_Blanket_PUB.Line_rec_type,
1613: p_old_line_rec IN OUT NOCOPY OE_Blanket_PUB.Line_rec_type,
1614: x_msg_count IN OUT NOCOPY NUMBER,
1615: x_msg_data IN OUT NOCOPY VARCHAR2)
1616: IS

Line 1613: p_old_line_rec IN OUT NOCOPY OE_Blanket_PUB.Line_rec_type,

1609: PROCEDURE Check_Sec_Line_Attr
1610: ----------------------------------------------------------
1611: (x_return_status IN OUT NOCOPY varchar2,
1612: p_line_rec IN OUT NOCOPY OE_Blanket_PUB.Line_rec_type,
1613: p_old_line_rec IN OUT NOCOPY OE_Blanket_PUB.Line_rec_type,
1614: x_msg_count IN OUT NOCOPY NUMBER,
1615: x_msg_data IN OUT NOCOPY VARCHAR2)
1616: IS
1617: l_result NUMBER;

Line 1683: p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,

1679: ----------------------------------------------------------
1680: PROCEDURE Check_Sec_Header_Entity
1681: ----------------------------------------------------------
1682: (x_return_status IN OUT NOCOPY varchar2,
1683: p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,
1684: x_msg_count IN OUT NOCOPY NUMBER,
1685: x_msg_data IN OUT NOCOPY VARCHAR2)
1686: IS
1687: l_result NUMBER;

Line 1755: p_line_rec IN OUT NOCOPY OE_Blanket_PUB.Line_rec_type,

1751: ----------------------------------------------------------
1752: PROCEDURE Check_Sec_Line_Entity
1753: ----------------------------------------------------------
1754: (x_return_status IN OUT NOCOPY varchar2,
1755: p_line_rec IN OUT NOCOPY OE_Blanket_PUB.Line_rec_type,
1756: x_msg_count IN OUT NOCOPY NUMBER,
1757: x_msg_data IN OUT NOCOPY VARCHAR2)
1758: IS
1759: l_result NUMBER;

Line 1824: (p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.header_rec_type,

1820:
1821: ----------------------------------------------------------
1822: PROCEDURE Update_Header_Cache
1823: ----------------------------------------------------------
1824: (p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.header_rec_type,
1825: delete_flag IN Varchar2 )
1826: IS
1827: ctr number;
1828: found_flag varchar2(1);

Line 1870: p_entity_code => OE_BLANKET_PUB.G_ENTITY_BLANKET_HEADER

1866: If delete_flag = 'Y' then
1867: If found_flag = 'Y' then
1868: G_Header_Cache_Rec(ctr) := NULL;
1869: OE_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
1870: p_entity_code => OE_BLANKET_PUB.G_ENTITY_BLANKET_HEADER
1871: ,p_entity_id => p_x_header_rec.header_id
1872: , p_delete_against => FALSE
1873: ,x_return_status => l_return_status);
1874: End if;

Line 1888: (p_x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type,

1884:
1885: ----------------------------------------------------------
1886: PROCEDURE Update_Line_Cache
1887: ----------------------------------------------------------
1888: (p_x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type,
1889: delete_flag IN VARCHAR2 := NULL)
1890: IS
1891: ctr number;
1892: found_flag varchar2(1);

Line 1924: p_entity_code => OE_BLANKET_PUB.G_ENTITY_BLANKET_LINE

1920: If delete_flag = 'Y' then
1921:
1922: If found_flag = 'Y' then
1923: OE_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
1924: p_entity_code => OE_BLANKET_PUB.G_ENTITY_BLANKET_LINE
1925: ,p_entity_id => p_x_Line_rec.Line_id
1926: , p_delete_against => FALSE
1927: ,x_return_status => l_return_status);
1928:

Line 1988: (p_x_Header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type

1984:
1985: ----------------------------------------------------------
1986: PROCEDURE Load_Blanket_Header_Rec
1987: ----------------------------------------------------------
1988: (p_x_Header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
1989: ,p_x_old_Header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type)
1990: IS
1991: ctr number := 1;
1992: found_flag varchar2(1) := 'N';

Line 1989: ,p_x_old_Header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type)

1985: ----------------------------------------------------------
1986: PROCEDURE Load_Blanket_Header_Rec
1987: ----------------------------------------------------------
1988: (p_x_Header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
1989: ,p_x_old_Header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type)
1990: IS
1991: ctr number := 1;
1992: found_flag varchar2(1) := 'N';
1993: l_x_return_status varchar2(30);

Line 2038: (p_x_line_rec IN OE_Blanket_PUB.line_rec_type

2034:
2035: ----------------------------------------------------------
2036: PROCEDURE Load_Blanket_Line_Rec
2037: ----------------------------------------------------------
2038: (p_x_line_rec IN OE_Blanket_PUB.line_rec_type
2039: ,p_x_old_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type)
2040: IS
2041: ctr number := 1;
2042: found_flag varchar2(1) := 'N';

Line 2039: ,p_x_old_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type)

2035: ----------------------------------------------------------
2036: PROCEDURE Load_Blanket_Line_Rec
2037: ----------------------------------------------------------
2038: (p_x_line_rec IN OE_Blanket_PUB.line_rec_type
2039: ,p_x_old_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type)
2040: IS
2041: ctr number := 1;
2042: found_flag varchar2(1) := 'N';
2043: l_x_return_status varchar2(1);

Line 2044: l_line_tbl oe_blanket_pub.line_tbl_type;

2040: IS
2041: ctr number := 1;
2042: found_flag varchar2(1) := 'N';
2043: l_x_return_status varchar2(1);
2044: l_line_tbl oe_blanket_pub.line_tbl_type;
2045: BEGIN
2046:
2047: while ctr <= G_line_Cache_Rec.count loop
2048: