DBA Data[Home] [Help]

APPS.QP_CON_UTIL dependencies on QP_ATTRIBUTES_PUB

Line 12: , p_CON_rec IN QP_Attributes_PUB.Con_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_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
13: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
14: QP_Attributes_PUB.G_MISS_CON_REC
15: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
16: )

Line 13: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=

9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
13: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
14: QP_Attributes_PUB.G_MISS_CON_REC
15: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
16: )
17: IS

Line 14: QP_Attributes_PUB.G_MISS_CON_REC

10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
13: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
14: QP_Attributes_PUB.G_MISS_CON_REC
15: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;

Line 15: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type

11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
13: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
14: QP_Attributes_PUB.G_MISS_CON_REC
15: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

Line 336: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type

332:
333: -- Procedure Apply_Attribute_Changes
334:
335: PROCEDURE Apply_Attribute_Changes
336: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
337: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
338: QP_Attributes_PUB.G_MISS_CON_REC
339: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
340: )

Line 337: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=

333: -- Procedure Apply_Attribute_Changes
334:
335: PROCEDURE Apply_Attribute_Changes
336: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
337: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
338: QP_Attributes_PUB.G_MISS_CON_REC
339: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
340: )
341: IS

Line 338: QP_Attributes_PUB.G_MISS_CON_REC

334:
335: PROCEDURE Apply_Attribute_Changes
336: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
337: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
338: QP_Attributes_PUB.G_MISS_CON_REC
339: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
340: )
341: IS
342: BEGIN

Line 339: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type

335: PROCEDURE Apply_Attribute_Changes
336: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
337: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
338: QP_Attributes_PUB.G_MISS_CON_REC
339: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
340: )
341: IS
342: BEGIN
343:

Line 518: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type

514:
515: -- Function Complete_Record
516:
517: FUNCTION Complete_Record
518: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
519: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
520: ) RETURN QP_Attributes_PUB.Con_Rec_Type
521: IS
522: l_CON_rec QP_Attributes_PUB.Con_Rec_Type := p_CON_rec;

Line 519: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type

515: -- Function Complete_Record
516:
517: FUNCTION Complete_Record
518: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
519: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
520: ) RETURN QP_Attributes_PUB.Con_Rec_Type
521: IS
522: l_CON_rec QP_Attributes_PUB.Con_Rec_Type := p_CON_rec;
523: BEGIN

Line 520: ) RETURN QP_Attributes_PUB.Con_Rec_Type

516:
517: FUNCTION Complete_Record
518: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
519: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
520: ) RETURN QP_Attributes_PUB.Con_Rec_Type
521: IS
522: l_CON_rec QP_Attributes_PUB.Con_Rec_Type := p_CON_rec;
523: BEGIN
524:

Line 522: l_CON_rec QP_Attributes_PUB.Con_Rec_Type := p_CON_rec;

518: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
519: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
520: ) RETURN QP_Attributes_PUB.Con_Rec_Type
521: IS
522: l_CON_rec QP_Attributes_PUB.Con_Rec_Type := p_CON_rec;
523: BEGIN
524:
525: IF l_CON_rec.attribute1 = FND_API.G_MISS_CHAR THEN
526: l_CON_rec.attribute1 := p_old_CON_rec.attribute1;

Line 664: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type

660:
661: -- Function Convert_Miss_To_Null
662:
663: FUNCTION Convert_Miss_To_Null
664: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
665: ) RETURN QP_Attributes_PUB.Con_Rec_Type
666: IS
667: l_CON_rec QP_Attributes_PUB.Con_Rec_Type := p_CON_rec;
668: BEGIN

Line 665: ) RETURN QP_Attributes_PUB.Con_Rec_Type

661: -- Function Convert_Miss_To_Null
662:
663: FUNCTION Convert_Miss_To_Null
664: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
665: ) RETURN QP_Attributes_PUB.Con_Rec_Type
666: IS
667: l_CON_rec QP_Attributes_PUB.Con_Rec_Type := p_CON_rec;
668: BEGIN
669:

Line 667: l_CON_rec QP_Attributes_PUB.Con_Rec_Type := p_CON_rec;

663: FUNCTION Convert_Miss_To_Null
664: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
665: ) RETURN QP_Attributes_PUB.Con_Rec_Type
666: IS
667: l_CON_rec QP_Attributes_PUB.Con_Rec_Type := p_CON_rec;
668: BEGIN
669:
670: IF l_CON_rec.attribute1 = FND_API.G_MISS_CHAR THEN
671: l_CON_rec.attribute1 := NULL;

Line 809: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type

805:
806: -- Procedure Update_Row
807:
808: PROCEDURE Update_Row
809: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
810: )
811: IS
812: BEGIN
813:

Line 895: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type

891:
892: -- Procedure Insert_Row
893:
894: PROCEDURE Insert_Row
895: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
896: )
897: IS
898: l_row_id varchar2(25);
899: BEGIN

Line 1099: ) RETURN QP_Attributes_PUB.Con_Rec_Type

1095: -- Function Query_Row
1096:
1097: FUNCTION Query_Row
1098: ( p_prc_context_id IN NUMBER
1099: ) RETURN QP_Attributes_PUB.Con_Rec_Type
1100: IS
1101: l_CON_rec QP_Attributes_PUB.Con_Rec_Type;
1102: BEGIN
1103:

Line 1101: l_CON_rec QP_Attributes_PUB.Con_Rec_Type;

1097: FUNCTION Query_Row
1098: ( p_prc_context_id IN NUMBER
1099: ) RETURN QP_Attributes_PUB.Con_Rec_Type
1100: IS
1101: l_CON_rec QP_Attributes_PUB.Con_Rec_Type;
1102: BEGIN
1103:
1104: SELECT ATTRIBUTE1
1105: , ATTRIBUTE10

Line 1197: , p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type

1193: --
1194:
1195: PROCEDURE Lock_Row
1196: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1197: , p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
1198: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
1199: )
1200: IS
1201: l_CON_rec QP_Attributes_PUB.Con_Rec_Type;

Line 1198: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type

1194:
1195: PROCEDURE Lock_Row
1196: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1197: , p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
1198: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
1199: )
1200: IS
1201: l_CON_rec QP_Attributes_PUB.Con_Rec_Type;
1202: BEGIN

Line 1201: l_CON_rec QP_Attributes_PUB.Con_Rec_Type;

1197: , p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
1198: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
1199: )
1200: IS
1201: l_CON_rec QP_Attributes_PUB.Con_Rec_Type;
1202: BEGIN
1203:
1204: SELECT ATTRIBUTE1
1205: , ATTRIBUTE10

Line 1414: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type

1410:
1411: -- Function Get_Values
1412:
1413: FUNCTION Get_Values
1414: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
1415: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
1416: QP_Attributes_PUB.G_MISS_CON_REC
1417: ) RETURN QP_Attributes_PUB.Con_Val_Rec_Type
1418: IS

Line 1415: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=

1411: -- Function Get_Values
1412:
1413: FUNCTION Get_Values
1414: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
1415: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
1416: QP_Attributes_PUB.G_MISS_CON_REC
1417: ) RETURN QP_Attributes_PUB.Con_Val_Rec_Type
1418: IS
1419: l_CON_val_rec QP_Attributes_PUB.Con_Val_Rec_Type;

Line 1416: QP_Attributes_PUB.G_MISS_CON_REC

1412:
1413: FUNCTION Get_Values
1414: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
1415: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
1416: QP_Attributes_PUB.G_MISS_CON_REC
1417: ) RETURN QP_Attributes_PUB.Con_Val_Rec_Type
1418: IS
1419: l_CON_val_rec QP_Attributes_PUB.Con_Val_Rec_Type;
1420: BEGIN

Line 1417: ) RETURN QP_Attributes_PUB.Con_Val_Rec_Type

1413: FUNCTION Get_Values
1414: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
1415: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
1416: QP_Attributes_PUB.G_MISS_CON_REC
1417: ) RETURN QP_Attributes_PUB.Con_Val_Rec_Type
1418: IS
1419: l_CON_val_rec QP_Attributes_PUB.Con_Val_Rec_Type;
1420: BEGIN
1421:

Line 1419: l_CON_val_rec QP_Attributes_PUB.Con_Val_Rec_Type;

1415: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
1416: QP_Attributes_PUB.G_MISS_CON_REC
1417: ) RETURN QP_Attributes_PUB.Con_Val_Rec_Type
1418: IS
1419: l_CON_val_rec QP_Attributes_PUB.Con_Val_Rec_Type;
1420: BEGIN
1421:
1422: IF p_CON_rec.enabled_flag IS NOT NULL AND
1423: p_CON_rec.enabled_flag <> FND_API.G_MISS_CHAR AND

Line 1459: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type

1455:
1456: -- Function Get_Ids
1457:
1458: FUNCTION Get_Ids
1459: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
1460: , p_CON_val_rec IN QP_Attributes_PUB.Con_Val_Rec_Type
1461: ) RETURN QP_Attributes_PUB.Con_Rec_Type
1462: IS
1463: l_CON_rec QP_Attributes_PUB.Con_Rec_Type;

Line 1460: , p_CON_val_rec IN QP_Attributes_PUB.Con_Val_Rec_Type

1456: -- Function Get_Ids
1457:
1458: FUNCTION Get_Ids
1459: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
1460: , p_CON_val_rec IN QP_Attributes_PUB.Con_Val_Rec_Type
1461: ) RETURN QP_Attributes_PUB.Con_Rec_Type
1462: IS
1463: l_CON_rec QP_Attributes_PUB.Con_Rec_Type;
1464: BEGIN

Line 1461: ) RETURN QP_Attributes_PUB.Con_Rec_Type

1457:
1458: FUNCTION Get_Ids
1459: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
1460: , p_CON_val_rec IN QP_Attributes_PUB.Con_Val_Rec_Type
1461: ) RETURN QP_Attributes_PUB.Con_Rec_Type
1462: IS
1463: l_CON_rec QP_Attributes_PUB.Con_Rec_Type;
1464: BEGIN
1465:

Line 1463: l_CON_rec QP_Attributes_PUB.Con_Rec_Type;

1459: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
1460: , p_CON_val_rec IN QP_Attributes_PUB.Con_Val_Rec_Type
1461: ) RETURN QP_Attributes_PUB.Con_Rec_Type
1462: IS
1463: l_CON_rec QP_Attributes_PUB.Con_Rec_Type;
1464: BEGIN
1465:
1466: -- initialize return_status.
1467: