8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
13: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
14: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
15: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.Modifiers_Rec_Type
16: )
9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
13: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
14: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
15: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.Modifiers_Rec_Type
16: )
17: IS
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
13: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
14: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
15: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.Modifiers_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
13: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
14: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
15: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.Modifiers_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
860:
861: -- Procedure Apply_Attribute_Changes
862:
863: PROCEDURE Apply_Attribute_Changes
864: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
865: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
866: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
867: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.Modifiers_Rec_Type
868: )
861: -- Procedure Apply_Attribute_Changes
862:
863: PROCEDURE Apply_Attribute_Changes
864: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
865: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
866: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
867: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.Modifiers_Rec_Type
868: )
869: IS
862:
863: PROCEDURE Apply_Attribute_Changes
864: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
865: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
866: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
867: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.Modifiers_Rec_Type
868: )
869: IS
870:
863: PROCEDURE Apply_Attribute_Changes
864: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
865: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
866: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
867: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.Modifiers_Rec_Type
868: )
869: IS
870:
871: --added by svdeshmu
1534:
1535: -- Function Complete_Record
1536:
1537: FUNCTION Complete_Record
1538: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
1539: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
1540: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type
1541: IS
1542: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type := p_MODIFIERS_rec;
1535: -- Function Complete_Record
1536:
1537: FUNCTION Complete_Record
1538: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
1539: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
1540: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type
1541: IS
1542: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type := p_MODIFIERS_rec;
1543: BEGIN
1536:
1537: FUNCTION Complete_Record
1538: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
1539: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
1540: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type
1541: IS
1542: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type := p_MODIFIERS_rec;
1543: BEGIN
1544:
1538: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
1539: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
1540: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type
1541: IS
1542: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type := p_MODIFIERS_rec;
1543: BEGIN
1544:
1545: oe_debug_pub.add('BEGIN Complete_Record in QPXUMLLB');
1546:
1920:
1921: -- Function Convert_Miss_To_Null
1922:
1923: FUNCTION Convert_Miss_To_Null
1924: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
1925: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type
1926: IS
1927: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type := p_MODIFIERS_rec;
1928: BEGIN
1921: -- Function Convert_Miss_To_Null
1922:
1923: FUNCTION Convert_Miss_To_Null
1924: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
1925: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type
1926: IS
1927: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type := p_MODIFIERS_rec;
1928: BEGIN
1929:
1923: FUNCTION Convert_Miss_To_Null
1924: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
1925: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type
1926: IS
1927: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type := p_MODIFIERS_rec;
1928: BEGIN
1929:
1930: oe_debug_pub.add('BEGIN Convert_Miss_To_Null in QPXUMLLB');
1931:
2306:
2307: ---------------------------------------------------------------------------
2308:
2309: PROCEDURE UPDATE_CHILD_LINES(p_MODIFIERS_rec IN
2310: QP_MODIFIERS_PUB.Modifiers_rec_type) IS
2311:
2312: l_status NUMBER;
2313: l_modifier_grp_type varchar2(30) := 'NOVAL';
2314: l_list_line_id NUMBER;
2450:
2451: -- Procedure Update_Row
2452:
2453: PROCEDURE Update_Row
2454: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
2455: )
2456: IS
2457: v_accum_context VARCHAR2(30) := NULL;
2458: v_accum_flag VARCHAR2(1) := NULL;
2655:
2656: -- Procedure Insert_Row
2657:
2658: PROCEDURE Insert_Row
2659: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
2660: )
2661: IS
2662: l_return_status VARCHAR2(30);
2663: l_gsa_indicator VARCHAR2(1);
3022: -- Function Query_Row
3023:
3024: FUNCTION Query_Row
3025: ( p_list_line_id IN NUMBER
3026: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type
3027: IS
3028: BEGIN
3029:
3030: RETURN Query_Rows
3041: ( p_list_line_id IN NUMBER :=
3042: FND_API.G_MISS_NUM
3043: , p_list_header_id IN NUMBER :=
3044: FND_API.G_MISS_NUM
3045: ) RETURN QP_Modifiers_PUB.Modifiers_Tbl_Type
3046: IS
3047: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
3048: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
3049:
3043: , p_list_header_id IN NUMBER :=
3044: FND_API.G_MISS_NUM
3045: ) RETURN QP_Modifiers_PUB.Modifiers_Tbl_Type
3046: IS
3047: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
3048: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
3049:
3050: CURSOR l_MODIFIERS_csr IS
3051: SELECT ARITHMETIC_OPERATOR
3044: FND_API.G_MISS_NUM
3045: ) RETURN QP_Modifiers_PUB.Modifiers_Tbl_Type
3046: IS
3047: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
3048: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
3049:
3050: CURSOR l_MODIFIERS_csr IS
3051: SELECT ARITHMETIC_OPERATOR
3052: , ATTRIBUTE1
3427: --
3428:
3429: PROCEDURE Lock_Row
3430: ( x_return_status OUT NOCOPY VARCHAR2
3431: , p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
3432: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.Modifiers_Rec_Type
3433: )
3434: IS
3435: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
3428:
3429: PROCEDURE Lock_Row
3430: ( x_return_status OUT NOCOPY VARCHAR2
3431: , p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
3432: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.Modifiers_Rec_Type
3433: )
3434: IS
3435: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
3436: BEGIN
3431: , p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
3432: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.Modifiers_Rec_Type
3433: )
3434: IS
3435: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
3436: BEGIN
3437:
3438: oe_debug_pub.add('BEGIN Lock_Row in QPXUMLLB');
3439:
4025:
4026: -- Function Get_Values
4027:
4028: FUNCTION Get_Values
4029: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
4030: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
4031: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
4032: ) RETURN QP_Modifiers_PUB.Modifiers_Val_Rec_Type
4033: IS
4026: -- Function Get_Values
4027:
4028: FUNCTION Get_Values
4029: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
4030: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
4031: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
4032: ) RETURN QP_Modifiers_PUB.Modifiers_Val_Rec_Type
4033: IS
4034: l_MODIFIERS_val_rec QP_Modifiers_PUB.Modifiers_Val_Rec_Type;
4027:
4028: FUNCTION Get_Values
4029: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
4030: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
4031: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
4032: ) RETURN QP_Modifiers_PUB.Modifiers_Val_Rec_Type
4033: IS
4034: l_MODIFIERS_val_rec QP_Modifiers_PUB.Modifiers_Val_Rec_Type;
4035: BEGIN
4028: FUNCTION Get_Values
4029: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
4030: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
4031: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
4032: ) RETURN QP_Modifiers_PUB.Modifiers_Val_Rec_Type
4033: IS
4034: l_MODIFIERS_val_rec QP_Modifiers_PUB.Modifiers_Val_Rec_Type;
4035: BEGIN
4036:
4030: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
4031: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
4032: ) RETURN QP_Modifiers_PUB.Modifiers_Val_Rec_Type
4033: IS
4034: l_MODIFIERS_val_rec QP_Modifiers_PUB.Modifiers_Val_Rec_Type;
4035: BEGIN
4036:
4037: oe_debug_pub.add('BEGIN Get_Values in QPXUMLLB');
4038:
4234:
4235: -- Function Get_Ids
4236:
4237: FUNCTION Get_Ids
4238: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
4239: , p_MODIFIERS_val_rec IN QP_Modifiers_PUB.Modifiers_Val_Rec_Type
4240: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type
4241: IS
4242: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
4235: -- Function Get_Ids
4236:
4237: FUNCTION Get_Ids
4238: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
4239: , p_MODIFIERS_val_rec IN QP_Modifiers_PUB.Modifiers_Val_Rec_Type
4240: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type
4241: IS
4242: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
4243: BEGIN
4236:
4237: FUNCTION Get_Ids
4238: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
4239: , p_MODIFIERS_val_rec IN QP_Modifiers_PUB.Modifiers_Val_Rec_Type
4240: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type
4241: IS
4242: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
4243: BEGIN
4244:
4238: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
4239: , p_MODIFIERS_val_rec IN QP_Modifiers_PUB.Modifiers_Val_Rec_Type
4240: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type
4241: IS
4242: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
4243: BEGIN
4244:
4245: oe_debug_pub.add('BEGIN Get_Ids in QPXUMLLB');
4246:
4831: END Get_Ids;
4832:
4833:
4834: Procedure Pre_Write_Process
4835: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type
4836: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type
4837: := QP_Modifiers_PUB.G_MISS_MODIFIERS_rec
4838: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.MODIFIERS_rec_Type
4839: ) IS
4832:
4833:
4834: Procedure Pre_Write_Process
4835: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type
4836: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type
4837: := QP_Modifiers_PUB.G_MISS_MODIFIERS_rec
4838: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.MODIFIERS_rec_Type
4839: ) IS
4840: l_Modifiers_rec QP_MODIFIERS_PUB.MODIFIERS_rec_Type := p_MODIFIERS_rec;
4833:
4834: Procedure Pre_Write_Process
4835: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type
4836: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type
4837: := QP_Modifiers_PUB.G_MISS_MODIFIERS_rec
4838: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.MODIFIERS_rec_Type
4839: ) IS
4840: l_Modifiers_rec QP_MODIFIERS_PUB.MODIFIERS_rec_Type := p_MODIFIERS_rec;
4841: l_return_status varchar2(30);
4834: Procedure Pre_Write_Process
4835: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type
4836: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type
4837: := QP_Modifiers_PUB.G_MISS_MODIFIERS_rec
4838: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.MODIFIERS_rec_Type
4839: ) IS
4840: l_Modifiers_rec QP_MODIFIERS_PUB.MODIFIERS_rec_Type := p_MODIFIERS_rec;
4841: l_return_status varchar2(30);
4842: l_parent_line_type QP_LIST_LINES.LIST_LINE_TYPE_CODE%TYPE := 'NONE';
4836: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type
4837: := QP_Modifiers_PUB.G_MISS_MODIFIERS_rec
4838: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.MODIFIERS_rec_Type
4839: ) IS
4840: l_Modifiers_rec QP_MODIFIERS_PUB.MODIFIERS_rec_Type := p_MODIFIERS_rec;
4841: l_return_status varchar2(30);
4842: l_parent_line_type QP_LIST_LINES.LIST_LINE_TYPE_CODE%TYPE := 'NONE';
4843: l_count NUMBER ;
4844: l_active_flag VARCHAR2(1) ;
4993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4994: END Pre_Write_Process;
4995:
4996: ------------------------------fix for bug 3756625
4997: Procedure Log_Update_Phases_DL(p_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type,
4998: x_return_status OUT NOCOPY VARCHAR2)
4999: IS
5000: l_active_flag varchar2(1);
5001: l_manual_modifier_flag varchar2(1);