DBA Data[Home] [Help]

APPS.OE_HEADER_UTIL dependencies on OE_AK_ORDER_HEADERS_V

Line 31: ,p_initial_header_rec IN OE_AK_ORDER_HEADERS_V%ROWTYPE

27: -- Clear_Dependents
28:
29: PROCEDURE Clear_Dependents
30: (p_src_attr_tbl IN OE_GLOBALS.NUMBER_Tbl_Type
31: ,p_initial_header_rec IN OE_AK_ORDER_HEADERS_V%ROWTYPE
32: ,p_old_header_rec IN OE_AK_ORDER_HEADERS_V%ROWTYPE
33: ,p_x_header_rec IN OUT NOCOPY OE_AK_ORDER_HEADERS_V%ROWTYPE
34: ,p_x_instrument_id IN NUMBER DEFAULT NULL
35: ,p_old_instrument_id IN NUMBER DEFAULT NULL)

Line 32: ,p_old_header_rec IN OE_AK_ORDER_HEADERS_V%ROWTYPE

28:
29: PROCEDURE Clear_Dependents
30: (p_src_attr_tbl IN OE_GLOBALS.NUMBER_Tbl_Type
31: ,p_initial_header_rec IN OE_AK_ORDER_HEADERS_V%ROWTYPE
32: ,p_old_header_rec IN OE_AK_ORDER_HEADERS_V%ROWTYPE
33: ,p_x_header_rec IN OUT NOCOPY OE_AK_ORDER_HEADERS_V%ROWTYPE
34: ,p_x_instrument_id IN NUMBER DEFAULT NULL
35: ,p_old_instrument_id IN NUMBER DEFAULT NULL)
36: IS

Line 33: ,p_x_header_rec IN OUT NOCOPY OE_AK_ORDER_HEADERS_V%ROWTYPE

29: PROCEDURE Clear_Dependents
30: (p_src_attr_tbl IN OE_GLOBALS.NUMBER_Tbl_Type
31: ,p_initial_header_rec IN OE_AK_ORDER_HEADERS_V%ROWTYPE
32: ,p_old_header_rec IN OE_AK_ORDER_HEADERS_V%ROWTYPE
33: ,p_x_header_rec IN OUT NOCOPY OE_AK_ORDER_HEADERS_V%ROWTYPE
34: ,p_x_instrument_id IN NUMBER DEFAULT NULL
35: ,p_old_instrument_id IN NUMBER DEFAULT NULL)
36: IS
37: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;

Line 957: RETURN OE_AK_ORDER_HEADERS_V%ROWTYPE IS

953:
954: END Clear_Dependents;
955:
956: FUNCTION G_MISS_OE_AK_HEADER_REC
957: RETURN OE_AK_ORDER_HEADERS_V%ROWTYPE IS
958: l_rowtype_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;
959: BEGIN
960:
961: l_rowtype_rec.ACCOUNTING_RULE_ID := FND_API.G_MISS_NUM;

Line 958: l_rowtype_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;

954: END Clear_Dependents;
955:
956: FUNCTION G_MISS_OE_AK_HEADER_REC
957: RETURN OE_AK_ORDER_HEADERS_V%ROWTYPE IS
958: l_rowtype_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;
959: BEGIN
960:
961: l_rowtype_rec.ACCOUNTING_RULE_ID := FND_API.G_MISS_NUM;
962: l_rowtype_rec.ACCOUNTING_RULE_DURATION := FND_API.G_MISS_NUM;

Line 1145: , x_rowtype_rec IN OUT NOCOPY OE_AK_ORDER_HEADERS_V%ROWTYPE

1141: END G_MISS_OE_AK_HEADER_REC;
1142:
1143: PROCEDURE API_Rec_To_Rowtype_Rec
1144: ( p_HEADER_rec IN OE_Order_PUB.HEADER_Rec_Type
1145: , x_rowtype_rec IN OUT NOCOPY OE_AK_ORDER_HEADERS_V%ROWTYPE
1146: ) IS
1147: BEGIN
1148:
1149: x_rowtype_rec.ACCOUNTING_RULE_ID := p_header_rec.ACCOUNTING_RULE_ID;

Line 1340: ( p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1337: END API_Rec_To_RowType_Rec;
1338:
1339: PROCEDURE Rowtype_Rec_To_API_Rec
1340: ( p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1341: , x_api_rec IN OUT NOCOPY OE_Order_PUB.HEADER_Rec_Type
1342: ) IS
1343: BEGIN
1344:

Line 1539: , p_initial_header_rec IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1535: -- Procedure Clear_Dependent_Attr: Overloaded for view%rowtype PARAMETERS
1536:
1537: PROCEDURE Clear_Dependent_Attr
1538: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
1539: , p_initial_header_rec IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1540: , p_old_header_rec IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1541: , p_x_header_rec IN OUT NOCOPY OE_AK_ORDER_HEADERS_V%ROWTYPE
1542: , p_x_instrument_id IN NUMBER DEFAULT NULL --R12 CC Encryption
1543: , p_old_instrument_id IN NUMBER DEFAULT NULL

Line 1540: , p_old_header_rec IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1536:
1537: PROCEDURE Clear_Dependent_Attr
1538: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
1539: , p_initial_header_rec IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1540: , p_old_header_rec IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1541: , p_x_header_rec IN OUT NOCOPY OE_AK_ORDER_HEADERS_V%ROWTYPE
1542: , p_x_instrument_id IN NUMBER DEFAULT NULL --R12 CC Encryption
1543: , p_old_instrument_id IN NUMBER DEFAULT NULL
1544: )

Line 1541: , p_x_header_rec IN OUT NOCOPY OE_AK_ORDER_HEADERS_V%ROWTYPE

1537: PROCEDURE Clear_Dependent_Attr
1538: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
1539: , p_initial_header_rec IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1540: , p_old_header_rec IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1541: , p_x_header_rec IN OUT NOCOPY OE_AK_ORDER_HEADERS_V%ROWTYPE
1542: , p_x_instrument_id IN NUMBER DEFAULT NULL --R12 CC Encryption
1543: , p_old_instrument_id IN NUMBER DEFAULT NULL
1544: )
1545: IS

Line 1735: l_header_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;

1731: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
1732: OE_Order_PUB.G_MISS_HEADER_REC
1733: )
1734: IS
1735: l_header_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;
1736: l_old_header_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;
1737: l_initial_header_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;
1738: BEGIN
1739: oe_debug_pub.add('Security code in Clear_dep_attr....'||p_x_header_rec.instrument_security_code);

Line 1736: l_old_header_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;

1732: OE_Order_PUB.G_MISS_HEADER_REC
1733: )
1734: IS
1735: l_header_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;
1736: l_old_header_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;
1737: l_initial_header_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;
1738: BEGIN
1739: oe_debug_pub.add('Security code in Clear_dep_attr....'||p_x_header_rec.instrument_security_code);
1740: API_Rec_To_Rowtype_Rec(p_x_header_rec, l_header_rec);

Line 1737: l_initial_header_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;

1733: )
1734: IS
1735: l_header_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;
1736: l_old_header_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;
1737: l_initial_header_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;
1738: BEGIN
1739: oe_debug_pub.add('Security code in Clear_dep_attr....'||p_x_header_rec.instrument_security_code);
1740: API_Rec_To_Rowtype_Rec(p_x_header_rec, l_header_rec);
1741: API_Rec_To_Rowtype_Rec(p_old_header_rec, l_old_header_rec);

Line 8102: AND oar.DATABASE_OBJECT_NAME='OE_AK_ORDER_HEADERS_V'

8098: CURSOR header_attributes IS
8099: SELECT oare.ATTRIBUTE_CODE attribute_code,Count(1) attachment_count
8100: FROM oe_attachment_rule_elements oare, oe_attachment_rules oar
8101: WHERE oare.rule_id=oar.rule_id
8102: AND oar.DATABASE_OBJECT_NAME='OE_AK_ORDER_HEADERS_V'
8103: GROUP BY oare.ATTRIBUTE_CODE;
8104:
8105: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
8106: