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 1088: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type

1084:
1085: -- Function Complete_Record
1086:
1087: FUNCTION Complete_Record
1088: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
1089: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
1090: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type
1091: IS
1092: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;

Line 1089: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type

1085: -- Function Complete_Record
1086:
1087: FUNCTION Complete_Record
1088: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
1089: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
1090: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type
1091: IS
1092: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
1093: BEGIN

Line 1090: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type

1086:
1087: FUNCTION Complete_Record
1088: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
1089: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
1090: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type
1091: IS
1092: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
1093: BEGIN
1094:

Line 1092: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;

1088: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
1089: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
1090: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type
1091: IS
1092: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
1093: BEGIN
1094:
1095: oe_debug_pub.add('BEGIN complete_record in QPXUMLHB');
1096:

Line 1341: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type

1337:
1338: -- Function Convert_Miss_To_Null
1339:
1340: FUNCTION Convert_Miss_To_Null
1341: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
1342: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type
1343: IS
1344: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
1345: BEGIN

Line 1342: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type

1338: -- Function Convert_Miss_To_Null
1339:
1340: FUNCTION Convert_Miss_To_Null
1341: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
1342: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type
1343: IS
1344: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
1345: BEGIN
1346:

Line 1344: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;

1340: FUNCTION Convert_Miss_To_Null
1341: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
1342: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type
1343: IS
1344: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
1345: BEGIN
1346:
1347: oe_debug_pub.add('BEGIN convert_miss_to_null in QPXUMLHB');
1348:

Line 1571: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type

1567:
1568: -- Procedure Update_Row
1569:
1570: PROCEDURE Update_Row
1571: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
1572: )
1573: IS
1574: l_active_date_first_type VARCHAR2(30);
1575: l_start_date_active_first DATE;

Line 1725: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type

1721:
1722: -- Procedure Insert_Row
1723:
1724: PROCEDURE Insert_Row
1725: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
1726: )
1727: IS
1728: l_return_status VARCHAR2(30);
1729: l_active_date_first_type VARCHAR2(30);

Line 2094: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type

2090: -- Function Query_Row
2091:
2092: FUNCTION Query_Row
2093: ( p_list_header_id IN NUMBER
2094: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type
2095: IS
2096: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2097: BEGIN
2098:

Line 2096: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

2092: FUNCTION Query_Row
2093: ( p_list_header_id IN NUMBER
2094: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type
2095: IS
2096: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2097: BEGIN
2098:
2099: oe_debug_pub.add('BEGIN query_row in QPXUMLHB');
2100:

Line 2255: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type

2251: --
2252:
2253: PROCEDURE Lock_Row
2254: ( x_return_status OUT NOCOPY VARCHAR2
2255: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
2256: , x_MODIFIER_LIST_rec OUT NOCOPY QP_Modifiers_PUB.Modifier_List_Rec_Type
2257: )
2258: IS
2259: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

Line 2256: , x_MODIFIER_LIST_rec OUT NOCOPY QP_Modifiers_PUB.Modifier_List_Rec_Type

2252:
2253: PROCEDURE Lock_Row
2254: ( x_return_status OUT NOCOPY VARCHAR2
2255: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
2256: , x_MODIFIER_LIST_rec OUT NOCOPY QP_Modifiers_PUB.Modifier_List_Rec_Type
2257: )
2258: IS
2259: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2260: BEGIN

Line 2259: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

2255: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
2256: , x_MODIFIER_LIST_rec OUT NOCOPY QP_Modifiers_PUB.Modifier_List_Rec_Type
2257: )
2258: IS
2259: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2260: BEGIN
2261:
2262: oe_debug_pub.add('BEGIN lock_row in QPXUMLHB');
2263:

Line 2574: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type

2570:
2571: -- Function Get_Values
2572:
2573: FUNCTION Get_Values
2574: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
2575: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
2576: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2577: ) RETURN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type
2578: IS

Line 2575: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=

2571: -- Function Get_Values
2572:
2573: FUNCTION Get_Values
2574: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
2575: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
2576: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2577: ) RETURN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type
2578: IS
2579: l_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;

Line 2576: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC

2572:
2573: FUNCTION Get_Values
2574: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
2575: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
2576: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2577: ) RETURN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type
2578: IS
2579: l_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
2580: BEGIN

Line 2577: ) RETURN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type

2573: FUNCTION Get_Values
2574: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
2575: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
2576: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2577: ) RETURN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type
2578: IS
2579: l_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
2580: BEGIN
2581:

Line 2579: l_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;

2575: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
2576: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2577: ) RETURN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type
2578: IS
2579: l_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
2580: BEGIN
2581:
2582: oe_debug_pub.add('BEGIN get_values in QPXUMLHB');
2583: IF p_MODIFIER_LIST_rec.automatic_flag IS NOT NULL AND

Line 2681: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type

2677:
2678: -- Function Get_Ids
2679:
2680: FUNCTION Get_Ids
2681: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
2682: , p_MODIFIER_LIST_val_rec IN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type
2683: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type
2684: IS
2685: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

Line 2682: , p_MODIFIER_LIST_val_rec IN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type

2678: -- Function Get_Ids
2679:
2680: FUNCTION Get_Ids
2681: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
2682: , p_MODIFIER_LIST_val_rec IN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type
2683: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type
2684: IS
2685: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2686: BEGIN

Line 2683: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type

2679:
2680: FUNCTION Get_Ids
2681: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
2682: , p_MODIFIER_LIST_val_rec IN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type
2683: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type
2684: IS
2685: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2686: BEGIN
2687:

Line 2685: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

2681: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
2682: , p_MODIFIER_LIST_val_rec IN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type
2683: ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type
2684: IS
2685: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2686: BEGIN
2687:
2688: oe_debug_pub.add('BEGIN get_ids in QPXUMLHB');
2689: -- initialize return_status.