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:
1464: END IF;
1465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1466: END Clear_Dependents;
1467:
1468: -- Function to initialize a record of type OE_AK_ORDER_LINES_V%ROWTYPE
1469: FUNCTION G_MISS_OE_AK_LINE_REC
1470: RETURN OE_AK_ORDER_LINES_V%ROWTYPE IS
1471: l_rowtype_rec OE_AK_ORDER_LINES_V%ROWTYPE;
1472: BEGIN
1466: END Clear_Dependents;
1467:
1468: -- Function to initialize a record of type OE_AK_ORDER_LINES_V%ROWTYPE
1469: FUNCTION G_MISS_OE_AK_LINE_REC
1470: RETURN OE_AK_ORDER_LINES_V%ROWTYPE IS
1471: l_rowtype_rec OE_AK_ORDER_LINES_V%ROWTYPE;
1472: BEGIN
1473:
1474: -- OPM 02/JUN/00 - add process attributes
1467:
1468: -- Function to initialize a record of type OE_AK_ORDER_LINES_V%ROWTYPE
1469: FUNCTION G_MISS_OE_AK_LINE_REC
1470: RETURN OE_AK_ORDER_LINES_V%ROWTYPE IS
1471: l_rowtype_rec OE_AK_ORDER_LINES_V%ROWTYPE;
1472: BEGIN
1473:
1474: -- OPM 02/JUN/00 - add process attributes
1475: -- =========================================================================
1791: END G_MISS_OE_AK_LINE_REC;
1792:
1793: PROCEDURE API_Rec_To_Rowtype_Rec
1794: ( p_LINE_rec IN OE_Order_PUB.LINE_Rec_Type
1795: , x_rowtype_rec IN OUT NOCOPY OE_AK_ORDER_LINES_V%ROWTYPE
1796: ) IS
1797: BEGIN
1798:
1799: x_rowtype_rec.ACCOUNTING_RULE_ID := p_line_rec.ACCOUNTING_RULE_ID;
2151: END API_Rec_To_RowType_Rec;
2152:
2153:
2154: PROCEDURE Rowtype_Rec_To_API_Rec
2155: ( p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2156: , x_api_rec IN OUT NOCOPY OE_Order_PUB.LINE_Rec_Type
2157: ) IS
2158: BEGIN
2159:
2529: -- p_x_line_rec: the current record with the user-specified changes and
2530: -- attributes that may have defaulted prior to this call
2531: PROCEDURE Clear_Dependent_Attr
2532: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
2533: , p_initial_line_rec IN OE_AK_ORDER_LINES_V%ROWTYPE
2534: , p_old_line_rec IN OE_AK_ORDER_LINES_V%ROWTYPE
2535: , p_x_line_rec IN OUT NOCOPY OE_AK_ORDER_LINES_V%ROWTYPE
2536: )
2537: IS
2530: -- attributes that may have defaulted prior to this call
2531: PROCEDURE Clear_Dependent_Attr
2532: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
2533: , p_initial_line_rec IN OE_AK_ORDER_LINES_V%ROWTYPE
2534: , p_old_line_rec IN OE_AK_ORDER_LINES_V%ROWTYPE
2535: , p_x_line_rec IN OUT NOCOPY OE_AK_ORDER_LINES_V%ROWTYPE
2536: )
2537: IS
2538: l_index NUMBER :=0;
2531: PROCEDURE Clear_Dependent_Attr
2532: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
2533: , p_initial_line_rec IN OE_AK_ORDER_LINES_V%ROWTYPE
2534: , p_old_line_rec IN OE_AK_ORDER_LINES_V%ROWTYPE
2535: , p_x_line_rec IN OUT NOCOPY OE_AK_ORDER_LINES_V%ROWTYPE
2536: )
2537: IS
2538: l_index NUMBER :=0;
2539: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
2753: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
2754: OE_Order_PUB.G_MISS_LINE_REC
2755: )
2756: IS
2757: l_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2758: l_initial_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2759: l_old_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2760: BEGIN
2761:
2754: OE_Order_PUB.G_MISS_LINE_REC
2755: )
2756: IS
2757: l_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2758: l_initial_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2759: l_old_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2760: BEGIN
2761:
2762: API_Rec_To_RowType_Rec(p_x_line_rec, l_line_rec);
2755: )
2756: IS
2757: l_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2758: l_initial_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2759: l_old_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2760: BEGIN
2761:
2762: API_Rec_To_RowType_Rec(p_x_line_rec, l_line_rec);
2763: API_Rec_To_RowType_Rec(p_old_line_rec, l_old_line_rec);
2785: ( p_src_attr_tbl IN OE_GLOBALS.Number_Tbl_Type
2786: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
2787: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
2788: )IS
2789: l_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2790: l_initial_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2791: l_old_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2792: l_dep_attr_exists VARCHAR2(1);
2793: BEGIN
2786: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
2787: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
2788: )IS
2789: l_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2790: l_initial_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2791: l_old_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2792: l_dep_attr_exists VARCHAR2(1);
2793: BEGIN
2794:
2787: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
2788: )IS
2789: l_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2790: l_initial_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2791: l_old_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2792: l_dep_attr_exists VARCHAR2(1);
2793: BEGIN
2794:
2795: API_Rec_To_RowType_Rec(p_x_line_rec, l_line_rec);