13: -- is set to 'Y' if at least one dependent attribute is set to missing
14: -- in this procedure.
15: PROCEDURE Clear_Dependents
16: (p_src_attr_tbl IN OE_GLOBALS.NUMBER_Tbl_Type
17: ,p_initial_line_rec IN OE_AK_ORDER_LINES_V%ROWTYPE
18: ,p_old_line_rec IN OE_AK_ORDER_LINES_V%ROWTYPE
19: ,p_x_line_rec IN OUT NOCOPY OE_AK_ORDER_LINES_V%ROWTYPE
20: ,x_dep_attr_exists OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
21: IS
14: -- in this procedure.
15: PROCEDURE Clear_Dependents
16: (p_src_attr_tbl IN OE_GLOBALS.NUMBER_Tbl_Type
17: ,p_initial_line_rec IN OE_AK_ORDER_LINES_V%ROWTYPE
18: ,p_old_line_rec IN OE_AK_ORDER_LINES_V%ROWTYPE
19: ,p_x_line_rec IN OUT NOCOPY OE_AK_ORDER_LINES_V%ROWTYPE
20: ,x_dep_attr_exists OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
21: IS
22: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
15: PROCEDURE Clear_Dependents
16: (p_src_attr_tbl IN OE_GLOBALS.NUMBER_Tbl_Type
17: ,p_initial_line_rec IN OE_AK_ORDER_LINES_V%ROWTYPE
18: ,p_old_line_rec IN OE_AK_ORDER_LINES_V%ROWTYPE
19: ,p_x_line_rec IN OUT NOCOPY OE_AK_ORDER_LINES_V%ROWTYPE
20: ,x_dep_attr_exists OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
21: IS
22: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
23:
1611: END IF;
1612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1613: END Clear_Dependents;
1614:
1615: -- Function to initialize a record of type OE_AK_ORDER_LINES_V%ROWTYPE
1616: FUNCTION G_MISS_OE_AK_LINE_REC
1617: RETURN OE_AK_ORDER_LINES_V%ROWTYPE IS
1618: l_rowtype_rec OE_AK_ORDER_LINES_V%ROWTYPE;
1619: BEGIN
1613: END Clear_Dependents;
1614:
1615: -- Function to initialize a record of type OE_AK_ORDER_LINES_V%ROWTYPE
1616: FUNCTION G_MISS_OE_AK_LINE_REC
1617: RETURN OE_AK_ORDER_LINES_V%ROWTYPE IS
1618: l_rowtype_rec OE_AK_ORDER_LINES_V%ROWTYPE;
1619: BEGIN
1620:
1621: -- OPM 02/JUN/00 - add process attributes
1614:
1615: -- Function to initialize a record of type OE_AK_ORDER_LINES_V%ROWTYPE
1616: FUNCTION G_MISS_OE_AK_LINE_REC
1617: RETURN OE_AK_ORDER_LINES_V%ROWTYPE IS
1618: l_rowtype_rec OE_AK_ORDER_LINES_V%ROWTYPE;
1619: BEGIN
1620:
1621: -- OPM 02/JUN/00 - add process attributes
1622: -- =========================================================================
1944: END G_MISS_OE_AK_LINE_REC;
1945:
1946: PROCEDURE API_Rec_To_Rowtype_Rec
1947: ( p_LINE_rec IN OE_Order_PUB.LINE_Rec_Type
1948: , x_rowtype_rec IN OUT NOCOPY OE_AK_ORDER_LINES_V%ROWTYPE
1949: ) IS
1950: BEGIN
1951:
1952: x_rowtype_rec.ACCOUNTING_RULE_ID := p_line_rec.ACCOUNTING_RULE_ID;
2313: END API_Rec_To_RowType_Rec;
2314:
2315:
2316: PROCEDURE Rowtype_Rec_To_API_Rec
2317: ( p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2318: , x_api_rec IN OUT NOCOPY OE_Order_PUB.LINE_Rec_Type
2319: ) IS
2320: BEGIN
2321:
2700: -- p_x_line_rec: the current record with the user-specified changes and
2701: -- attributes that may have defaulted prior to this call
2702: PROCEDURE Clear_Dependent_Attr
2703: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
2704: , p_initial_line_rec IN OE_AK_ORDER_LINES_V%ROWTYPE
2705: , p_old_line_rec IN OE_AK_ORDER_LINES_V%ROWTYPE
2706: , p_x_line_rec IN OUT NOCOPY OE_AK_ORDER_LINES_V%ROWTYPE
2707: )
2708: IS
2701: -- attributes that may have defaulted prior to this call
2702: PROCEDURE Clear_Dependent_Attr
2703: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
2704: , p_initial_line_rec IN OE_AK_ORDER_LINES_V%ROWTYPE
2705: , p_old_line_rec IN OE_AK_ORDER_LINES_V%ROWTYPE
2706: , p_x_line_rec IN OUT NOCOPY OE_AK_ORDER_LINES_V%ROWTYPE
2707: )
2708: IS
2709: l_index NUMBER :=0;
2702: PROCEDURE Clear_Dependent_Attr
2703: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
2704: , p_initial_line_rec IN OE_AK_ORDER_LINES_V%ROWTYPE
2705: , p_old_line_rec IN OE_AK_ORDER_LINES_V%ROWTYPE
2706: , p_x_line_rec IN OUT NOCOPY OE_AK_ORDER_LINES_V%ROWTYPE
2707: )
2708: IS
2709: l_index NUMBER :=0;
2710: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
2938: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
2939: OE_Order_PUB.G_MISS_LINE_REC
2940: )
2941: IS
2942: l_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2943: l_initial_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2944: l_old_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2945: BEGIN
2946:
2939: OE_Order_PUB.G_MISS_LINE_REC
2940: )
2941: IS
2942: l_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2943: l_initial_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2944: l_old_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2945: BEGIN
2946:
2947: API_Rec_To_RowType_Rec(p_x_line_rec, l_line_rec);
2940: )
2941: IS
2942: l_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2943: l_initial_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2944: l_old_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2945: BEGIN
2946:
2947: API_Rec_To_RowType_Rec(p_x_line_rec, l_line_rec);
2948: API_Rec_To_RowType_Rec(p_old_line_rec, l_old_line_rec);
2970: ( p_src_attr_tbl IN OE_GLOBALS.Number_Tbl_Type
2971: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
2972: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
2973: )IS
2974: l_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2975: l_initial_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2976: l_old_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2977: l_dep_attr_exists VARCHAR2(1);
2978: BEGIN
2971: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
2972: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
2973: )IS
2974: l_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2975: l_initial_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2976: l_old_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2977: l_dep_attr_exists VARCHAR2(1);
2978: BEGIN
2979:
2972: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
2973: )IS
2974: l_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2975: l_initial_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2976: l_old_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2977: l_dep_attr_exists VARCHAR2(1);
2978: BEGIN
2979:
2980: API_Rec_To_RowType_Rec(p_x_line_rec, l_line_rec);