8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
13: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
14: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
15: , x_MODIFIER_LIST_rec OUT NOCOPY QP_Modifiers_PUB.Modifier_List_Rec_Type
16: )
9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
13: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
14: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
15: , x_MODIFIER_LIST_rec OUT NOCOPY QP_Modifiers_PUB.Modifier_List_Rec_Type
16: )
17: IS
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
13: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
14: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
15: , x_MODIFIER_LIST_rec OUT NOCOPY QP_Modifiers_PUB.Modifier_List_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
13: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
14: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
15: , x_MODIFIER_LIST_rec OUT NOCOPY QP_Modifiers_PUB.Modifier_List_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
557:
558: -- Procedure Apply_Attribute_Changes
559:
560: PROCEDURE Apply_Attribute_Changes
561: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
562: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
563: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
564: , x_MODIFIER_LIST_rec OUT NOCOPY QP_Modifiers_PUB.Modifier_List_Rec_Type
565: )
558: -- Procedure Apply_Attribute_Changes
559:
560: PROCEDURE Apply_Attribute_Changes
561: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
562: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
563: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
564: , x_MODIFIER_LIST_rec OUT NOCOPY QP_Modifiers_PUB.Modifier_List_Rec_Type
565: )
566: IS
559:
560: PROCEDURE Apply_Attribute_Changes
561: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
562: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
563: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
564: , x_MODIFIER_LIST_rec OUT NOCOPY QP_Modifiers_PUB.Modifier_List_Rec_Type
565: )
566: IS
567: l_modifiers_exist VARCHAR2(1) := 'N';
560: PROCEDURE Apply_Attribute_Changes
561: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
562: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
563: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
564: , x_MODIFIER_LIST_rec OUT NOCOPY QP_Modifiers_PUB.Modifier_List_Rec_Type
565: )
566: IS
567: l_modifiers_exist VARCHAR2(1) := 'N';
568: ------------------------fix for bug 3756625
1315:
1316: -- Function Complete_Record
1317:
1318: FUNCTION Complete_Record
1319: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
1320: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
1321: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type
1322: IS
1323: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
1316: -- Function Complete_Record
1317:
1318: FUNCTION Complete_Record
1319: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
1320: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
1321: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type
1322: IS
1323: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
1324: BEGIN
1317:
1318: FUNCTION Complete_Record
1319: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
1320: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
1321: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type
1322: IS
1323: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
1324: BEGIN
1325:
1319: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
1320: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
1321: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type
1322: IS
1323: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
1324: BEGIN
1325:
1326: oe_debug_pub.add('BEGIN complete_record in QPXUMLHB');
1327:
1568:
1569: -- Function Convert_Miss_To_Null
1570:
1571: FUNCTION Convert_Miss_To_Null
1572: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
1573: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type
1574: IS
1575: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
1576: BEGIN
1569: -- Function Convert_Miss_To_Null
1570:
1571: FUNCTION Convert_Miss_To_Null
1572: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
1573: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type
1574: IS
1575: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
1576: BEGIN
1577:
1571: FUNCTION Convert_Miss_To_Null
1572: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
1573: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type
1574: IS
1575: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
1576: BEGIN
1577:
1578: oe_debug_pub.add('BEGIN convert_miss_to_null in QPXUMLHB');
1579:
1798:
1799: -- Procedure Update_Row
1800:
1801: PROCEDURE Update_Row
1802: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
1803: )
1804: IS
1805: l_active_date_first_type VARCHAR2(30);
1806: l_start_date_active_first DATE;
1952:
1953: -- Procedure Insert_Row
1954:
1955: PROCEDURE Insert_Row
1956: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
1957: )
1958: IS
1959: l_return_status VARCHAR2(30);
1960: l_active_date_first_type VARCHAR2(30);
2321: -- Function Query_Row
2322:
2323: FUNCTION Query_Row
2324: ( p_list_header_id IN NUMBER
2325: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type
2326: IS
2327: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2328: BEGIN
2329:
2323: FUNCTION Query_Row
2324: ( p_list_header_id IN NUMBER
2325: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type
2326: IS
2327: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2328: BEGIN
2329:
2330: oe_debug_pub.add('BEGIN query_row in QPXUMLHB');
2331:
2482: --
2483:
2484: PROCEDURE Lock_Row
2485: ( x_return_status OUT NOCOPY VARCHAR2
2486: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
2487: , x_MODIFIER_LIST_rec OUT NOCOPY QP_Modifiers_PUB.Modifier_List_Rec_Type
2488: )
2489: IS
2490: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2483:
2484: PROCEDURE Lock_Row
2485: ( x_return_status OUT NOCOPY VARCHAR2
2486: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
2487: , x_MODIFIER_LIST_rec OUT NOCOPY QP_Modifiers_PUB.Modifier_List_Rec_Type
2488: )
2489: IS
2490: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2491: BEGIN
2486: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
2487: , x_MODIFIER_LIST_rec OUT NOCOPY QP_Modifiers_PUB.Modifier_List_Rec_Type
2488: )
2489: IS
2490: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2491: BEGIN
2492:
2493: oe_debug_pub.add('BEGIN lock_row in QPXUMLHB');
2494:
2858:
2859: -- Function Get_Values
2860:
2861: FUNCTION Get_Values
2862: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
2863: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
2864: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2865: ) RETURN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type
2866: IS
2859: -- Function Get_Values
2860:
2861: FUNCTION Get_Values
2862: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
2863: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
2864: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2865: ) RETURN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type
2866: IS
2867: l_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
2860:
2861: FUNCTION Get_Values
2862: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
2863: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
2864: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2865: ) RETURN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type
2866: IS
2867: l_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
2868: BEGIN
2861: FUNCTION Get_Values
2862: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
2863: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
2864: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2865: ) RETURN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type
2866: IS
2867: l_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
2868: BEGIN
2869:
2863: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
2864: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2865: ) RETURN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type
2866: IS
2867: l_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
2868: BEGIN
2869:
2870: oe_debug_pub.add('BEGIN get_values in QPXUMLHB');
2871: IF p_MODIFIER_LIST_rec.automatic_flag IS NOT NULL AND
2965:
2966: -- Function Get_Ids
2967:
2968: FUNCTION Get_Ids
2969: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
2970: , p_MODIFIER_LIST_val_rec IN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type
2971: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type
2972: IS
2973: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2966: -- Function Get_Ids
2967:
2968: FUNCTION Get_Ids
2969: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
2970: , p_MODIFIER_LIST_val_rec IN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type
2971: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type
2972: IS
2973: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2974: BEGIN
2967:
2968: FUNCTION Get_Ids
2969: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
2970: , p_MODIFIER_LIST_val_rec IN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type
2971: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type
2972: IS
2973: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2974: BEGIN
2975:
2969: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
2970: , p_MODIFIER_LIST_val_rec IN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type
2971: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type
2972: IS
2973: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2974: BEGIN
2975:
2976: oe_debug_pub.add('BEGIN get_ids in QPXUMLHB');
2977: -- initialize return_status.