DBA Data[Home] [Help]

APPS.QP_MODIFIER_LIST_UTIL dependencies on QP_MODIFIERS_PUB

Line 12: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type

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: )

Line 13: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=

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

Line 14: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC

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;

Line 15: , x_MODIFIER_LIST_rec OUT NOCOPY QP_Modifiers_PUB.Modifier_List_Rec_Type

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;

Line 561: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_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: )

Line 562: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=

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

Line 563: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC

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';

Line 564: , x_MODIFIER_LIST_rec OUT NOCOPY QP_Modifiers_PUB.Modifier_List_Rec_Type

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

Line 1319: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type

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;

Line 1320: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type

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

Line 1321: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type

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:

Line 1323: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;

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:

Line 1572: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type

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

Line 1573: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type

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:

Line 1575: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;

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:

Line 1802: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type

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;

Line 1956: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type

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);

Line 2325: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type

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:

Line 2327: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

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:

Line 2486: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type

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;

Line 2487: , x_MODIFIER_LIST_rec OUT NOCOPY 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

Line 2490: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

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:

Line 2862: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type

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

Line 2863: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=

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;

Line 2864: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC

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

Line 2865: ) RETURN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type

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:

Line 2867: l_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_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:
2870: oe_debug_pub.add('BEGIN get_values in QPXUMLHB');
2871: IF p_MODIFIER_LIST_rec.automatic_flag IS NOT NULL AND

Line 2969: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type

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;

Line 2970: , p_MODIFIER_LIST_val_rec IN QP_Modifiers_PUB.Modifier_List_Val_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

Line 2971: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type

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:

Line 2973: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

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.