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;
848:
849: -- Procedure Apply_Attribute_Changes
850:
851: PROCEDURE Apply_Attribute_Changes
852: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
853: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
854: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
855: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.Modifiers_Rec_Type
856: )
849: -- Procedure Apply_Attribute_Changes
850:
851: PROCEDURE Apply_Attribute_Changes
852: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
853: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
854: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
855: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.Modifiers_Rec_Type
856: )
857: IS
850:
851: PROCEDURE Apply_Attribute_Changes
852: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
853: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
854: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
855: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.Modifiers_Rec_Type
856: )
857: IS
858:
851: PROCEDURE Apply_Attribute_Changes
852: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
853: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
854: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
855: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.Modifiers_Rec_Type
856: )
857: IS
858:
859: --added by svdeshmu
1479:
1480: -- Function Complete_Record
1481:
1482: FUNCTION Complete_Record
1483: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
1484: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
1485: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type
1486: IS
1487: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type := p_MODIFIERS_rec;
1480: -- Function Complete_Record
1481:
1482: FUNCTION Complete_Record
1483: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
1484: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
1485: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type
1486: IS
1487: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type := p_MODIFIERS_rec;
1488: BEGIN
1481:
1482: FUNCTION Complete_Record
1483: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
1484: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
1485: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type
1486: IS
1487: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type := p_MODIFIERS_rec;
1488: BEGIN
1489:
1483: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
1484: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
1485: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type
1486: IS
1487: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type := p_MODIFIERS_rec;
1488: BEGIN
1489:
1490: oe_debug_pub.add('BEGIN Complete_Record in QPXUMLLB');
1491:
1857:
1858: -- Function Convert_Miss_To_Null
1859:
1860: FUNCTION Convert_Miss_To_Null
1861: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
1862: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type
1863: IS
1864: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type := p_MODIFIERS_rec;
1865: BEGIN
1858: -- Function Convert_Miss_To_Null
1859:
1860: FUNCTION Convert_Miss_To_Null
1861: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
1862: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type
1863: IS
1864: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type := p_MODIFIERS_rec;
1865: BEGIN
1866:
1860: FUNCTION Convert_Miss_To_Null
1861: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
1862: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type
1863: IS
1864: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type := p_MODIFIERS_rec;
1865: BEGIN
1866:
1867: oe_debug_pub.add('BEGIN Convert_Miss_To_Null in QPXUMLLB');
1868:
2235:
2236: ---------------------------------------------------------------------------
2237:
2238: PROCEDURE UPDATE_CHILD_LINES(p_MODIFIERS_rec IN
2239: QP_MODIFIERS_PUB.Modifiers_rec_type) IS
2240:
2241: l_status NUMBER;
2242: l_modifier_grp_type varchar2(30) := 'NOVAL';
2243: l_list_line_id NUMBER;
2379:
2380: -- Procedure Update_Row
2381:
2382: PROCEDURE Update_Row
2383: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
2384: )
2385: IS
2386: v_accum_context VARCHAR2(30) := NULL;
2387: v_accum_flag VARCHAR2(1) := NULL;
2582:
2583: -- Procedure Insert_Row
2584:
2585: PROCEDURE Insert_Row
2586: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
2587: )
2588: IS
2589: l_return_status VARCHAR2(30);
2590: l_gsa_indicator VARCHAR2(1);
2945: -- Function Query_Row
2946:
2947: FUNCTION Query_Row
2948: ( p_list_line_id IN NUMBER
2949: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type
2950: IS
2951: BEGIN
2952:
2953: RETURN Query_Rows
2964: ( p_list_line_id IN NUMBER :=
2965: FND_API.G_MISS_NUM
2966: , p_list_header_id IN NUMBER :=
2967: FND_API.G_MISS_NUM
2968: ) RETURN QP_Modifiers_PUB.Modifiers_Tbl_Type
2969: IS
2970: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2971: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2972:
2966: , p_list_header_id IN NUMBER :=
2967: FND_API.G_MISS_NUM
2968: ) RETURN QP_Modifiers_PUB.Modifiers_Tbl_Type
2969: IS
2970: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2971: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2972:
2973: CURSOR l_MODIFIERS_csr IS
2974: SELECT ARITHMETIC_OPERATOR
2967: FND_API.G_MISS_NUM
2968: ) RETURN QP_Modifiers_PUB.Modifiers_Tbl_Type
2969: IS
2970: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2971: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2972:
2973: CURSOR l_MODIFIERS_csr IS
2974: SELECT ARITHMETIC_OPERATOR
2975: , ATTRIBUTE1
3344: --
3345:
3346: PROCEDURE Lock_Row
3347: ( x_return_status OUT NOCOPY VARCHAR2
3348: , p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
3349: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.Modifiers_Rec_Type
3350: )
3351: IS
3352: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
3345:
3346: PROCEDURE Lock_Row
3347: ( x_return_status OUT NOCOPY VARCHAR2
3348: , p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
3349: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.Modifiers_Rec_Type
3350: )
3351: IS
3352: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
3353: BEGIN
3348: , p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
3349: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.Modifiers_Rec_Type
3350: )
3351: IS
3352: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
3353: BEGIN
3354:
3355: oe_debug_pub.add('BEGIN Lock_Row in QPXUMLLB');
3356:
3849:
3850: -- Function Get_Values
3851:
3852: FUNCTION Get_Values
3853: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
3854: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
3855: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
3856: ) RETURN QP_Modifiers_PUB.Modifiers_Val_Rec_Type
3857: IS
3850: -- Function Get_Values
3851:
3852: FUNCTION Get_Values
3853: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
3854: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
3855: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
3856: ) RETURN QP_Modifiers_PUB.Modifiers_Val_Rec_Type
3857: IS
3858: l_MODIFIERS_val_rec QP_Modifiers_PUB.Modifiers_Val_Rec_Type;
3851:
3852: FUNCTION Get_Values
3853: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
3854: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
3855: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
3856: ) RETURN QP_Modifiers_PUB.Modifiers_Val_Rec_Type
3857: IS
3858: l_MODIFIERS_val_rec QP_Modifiers_PUB.Modifiers_Val_Rec_Type;
3859: BEGIN
3852: FUNCTION Get_Values
3853: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
3854: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
3855: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
3856: ) RETURN QP_Modifiers_PUB.Modifiers_Val_Rec_Type
3857: IS
3858: l_MODIFIERS_val_rec QP_Modifiers_PUB.Modifiers_Val_Rec_Type;
3859: BEGIN
3860:
3854: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
3855: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
3856: ) RETURN QP_Modifiers_PUB.Modifiers_Val_Rec_Type
3857: IS
3858: l_MODIFIERS_val_rec QP_Modifiers_PUB.Modifiers_Val_Rec_Type;
3859: BEGIN
3860:
3861: oe_debug_pub.add('BEGIN Get_Values in QPXUMLLB');
3862:
4058:
4059: -- Function Get_Ids
4060:
4061: FUNCTION Get_Ids
4062: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
4063: , p_MODIFIERS_val_rec IN QP_Modifiers_PUB.Modifiers_Val_Rec_Type
4064: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type
4065: IS
4066: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
4059: -- Function Get_Ids
4060:
4061: FUNCTION Get_Ids
4062: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
4063: , p_MODIFIERS_val_rec IN QP_Modifiers_PUB.Modifiers_Val_Rec_Type
4064: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type
4065: IS
4066: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
4067: BEGIN
4060:
4061: FUNCTION Get_Ids
4062: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
4063: , p_MODIFIERS_val_rec IN QP_Modifiers_PUB.Modifiers_Val_Rec_Type
4064: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type
4065: IS
4066: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
4067: BEGIN
4068:
4062: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
4063: , p_MODIFIERS_val_rec IN QP_Modifiers_PUB.Modifiers_Val_Rec_Type
4064: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type
4065: IS
4066: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
4067: BEGIN
4068:
4069: oe_debug_pub.add('BEGIN Get_Ids in QPXUMLLB');
4070:
4654: END Get_Ids;
4655:
4656:
4657: Procedure Pre_Write_Process
4658: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type
4659: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type
4660: := QP_Modifiers_PUB.G_MISS_MODIFIERS_rec
4661: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.MODIFIERS_rec_Type
4662: ) IS
4655:
4656:
4657: Procedure Pre_Write_Process
4658: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type
4659: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type
4660: := QP_Modifiers_PUB.G_MISS_MODIFIERS_rec
4661: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.MODIFIERS_rec_Type
4662: ) IS
4663: l_Modifiers_rec QP_MODIFIERS_PUB.MODIFIERS_rec_Type := p_MODIFIERS_rec;
4656:
4657: Procedure Pre_Write_Process
4658: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type
4659: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type
4660: := QP_Modifiers_PUB.G_MISS_MODIFIERS_rec
4661: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.MODIFIERS_rec_Type
4662: ) IS
4663: l_Modifiers_rec QP_MODIFIERS_PUB.MODIFIERS_rec_Type := p_MODIFIERS_rec;
4664: l_return_status varchar2(30);
4657: Procedure Pre_Write_Process
4658: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type
4659: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type
4660: := QP_Modifiers_PUB.G_MISS_MODIFIERS_rec
4661: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.MODIFIERS_rec_Type
4662: ) IS
4663: l_Modifiers_rec QP_MODIFIERS_PUB.MODIFIERS_rec_Type := p_MODIFIERS_rec;
4664: l_return_status varchar2(30);
4665: l_parent_line_type QP_LIST_LINES.LIST_LINE_TYPE_CODE%TYPE := 'NONE';
4659: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type
4660: := QP_Modifiers_PUB.G_MISS_MODIFIERS_rec
4661: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.MODIFIERS_rec_Type
4662: ) IS
4663: l_Modifiers_rec QP_MODIFIERS_PUB.MODIFIERS_rec_Type := p_MODIFIERS_rec;
4664: l_return_status varchar2(30);
4665: l_parent_line_type QP_LIST_LINES.LIST_LINE_TYPE_CODE%TYPE := 'NONE';
4666: l_count NUMBER ;
4667: l_active_flag VARCHAR2(1) ;
4798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4799: END Pre_Write_Process;
4800:
4801: ------------------------------fix for bug 3756625
4802: Procedure Log_Update_Phases_DL(p_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type,
4803: x_return_status OUT NOCOPY VARCHAR2)
4804: IS
4805: l_active_flag varchar2(1);
4806: l_manual_modifier_flag varchar2(1);