APPS.QP_FNA_UTIL dependencies on QP_ATTR_MAP_PUB

Line 12: , p_FNA_rec IN QP_Attr_Map_PUB.Fna_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_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
13: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=
14: QP_Attr_Map_PUB.G_MISS_FNA_REC
15: , x_FNA_rec OUT NOCOPY QP_Attr_Map_PUB.Fna_Rec_Type
16: )

Line 13: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=

9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
13: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=
14: QP_Attr_Map_PUB.G_MISS_FNA_REC
15: , x_FNA_rec OUT NOCOPY QP_Attr_Map_PUB.Fna_Rec_Type
16: )
17: IS

Line 14: QP_Attr_Map_PUB.G_MISS_FNA_REC

10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
13: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=
14: QP_Attr_Map_PUB.G_MISS_FNA_REC
15: , x_FNA_rec OUT NOCOPY QP_Attr_Map_PUB.Fna_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;

Line 15: , x_FNA_rec OUT NOCOPY QP_Attr_Map_PUB.Fna_Rec_Type

11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
13: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=
14: QP_Attr_Map_PUB.G_MISS_FNA_REC
15: , x_FNA_rec OUT NOCOPY QP_Attr_Map_PUB.Fna_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

Line 309: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type

305:
306: -- Procedure Apply_Attribute_Changes
307:
308: PROCEDURE Apply_Attribute_Changes
309: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
310: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=
311: QP_Attr_Map_PUB.G_MISS_FNA_REC
312: , p_called_from_ui IN VARCHAR2
313: , x_FNA_rec OUT NOCOPY QP_Attr_Map_PUB.Fna_Rec_Type

Line 310: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=

306: -- Procedure Apply_Attribute_Changes
307:
308: PROCEDURE Apply_Attribute_Changes
309: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
310: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=
311: QP_Attr_Map_PUB.G_MISS_FNA_REC
312: , p_called_from_ui IN VARCHAR2
313: , x_FNA_rec OUT NOCOPY QP_Attr_Map_PUB.Fna_Rec_Type
314: )

Line 311: QP_Attr_Map_PUB.G_MISS_FNA_REC

307:
308: PROCEDURE Apply_Attribute_Changes
309: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
310: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=
311: QP_Attr_Map_PUB.G_MISS_FNA_REC
312: , p_called_from_ui IN VARCHAR2
313: , x_FNA_rec OUT NOCOPY QP_Attr_Map_PUB.Fna_Rec_Type
314: )
315: IS

Line 313: , x_FNA_rec OUT NOCOPY QP_Attr_Map_PUB.Fna_Rec_Type

309: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
310: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=
311: QP_Attr_Map_PUB.G_MISS_FNA_REC
312: , p_called_from_ui IN VARCHAR2
313: , x_FNA_rec OUT NOCOPY QP_Attr_Map_PUB.Fna_Rec_Type
314: )
315: IS
316: l_dummy_ret_status VARCHAR2(1);
317: BEGIN

Line 499: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type

495:
496: -- Function Complete_Record
497:
498: FUNCTION Complete_Record
499: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
500: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
501: ) RETURN QP_Attr_Map_PUB.Fna_Rec_Type
502: IS
503: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type := p_FNA_rec;

Line 500: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type

496: -- Function Complete_Record
497:
498: FUNCTION Complete_Record
499: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
500: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
501: ) RETURN QP_Attr_Map_PUB.Fna_Rec_Type
502: IS
503: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type := p_FNA_rec;
504: BEGIN

Line 501: ) RETURN QP_Attr_Map_PUB.Fna_Rec_Type

497:
498: FUNCTION Complete_Record
499: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
500: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
501: ) RETURN QP_Attr_Map_PUB.Fna_Rec_Type
502: IS
503: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type := p_FNA_rec;
504: BEGIN
505:

Line 503: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type := p_FNA_rec;

499: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
500: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
501: ) RETURN QP_Attr_Map_PUB.Fna_Rec_Type
502: IS
503: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type := p_FNA_rec;
504: BEGIN
505:
506: IF l_FNA_rec.attribute1 = FND_API.G_MISS_CHAR THEN
507: l_FNA_rec.attribute1 := p_old_FNA_rec.attribute1;

Line 633: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type

629:
630: -- Function Convert_Miss_To_Null
631:
632: FUNCTION Convert_Miss_To_Null
633: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
634: ) RETURN QP_Attr_Map_PUB.Fna_Rec_Type
635: IS
636: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type := p_FNA_rec;
637: BEGIN

Line 634: ) RETURN QP_Attr_Map_PUB.Fna_Rec_Type

630: -- Function Convert_Miss_To_Null
631:
632: FUNCTION Convert_Miss_To_Null
633: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
634: ) RETURN QP_Attr_Map_PUB.Fna_Rec_Type
635: IS
636: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type := p_FNA_rec;
637: BEGIN
638: IF l_FNA_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 636: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type := p_FNA_rec;

632: FUNCTION Convert_Miss_To_Null
633: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
634: ) RETURN QP_Attr_Map_PUB.Fna_Rec_Type
635: IS
636: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type := p_FNA_rec;
637: BEGIN
638: IF l_FNA_rec.attribute1 = FND_API.G_MISS_CHAR THEN
639: l_FNA_rec.attribute1 := NULL;
640: END IF;

Line 765: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type

761:
762: -- Procedure Update_Row
763:
764: PROCEDURE Update_Row
765: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
766: )
767: IS
768: BEGIN
769:

Line 823: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type

819:
820: -- Procedure Insert_Row
821:
822: PROCEDURE Insert_Row
823: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
824: )
825: IS
826: BEGIN
827:

Line 941: ) RETURN QP_Attr_Map_PUB.Fna_Rec_Type

937: -- Function Query_Row
938:
939: FUNCTION Query_Row
940: ( p_pte_sourcesystem_fnarea_id IN NUMBER
941: ) RETURN QP_Attr_Map_PUB.Fna_Rec_Type
942: IS
943: BEGIN
944:
945: RETURN Query_Rows

Line 960: ) RETURN QP_Attr_Map_PUB.Fna_Tbl_Type

956: ( p_pte_sourcesystem_fnarea_id IN NUMBER :=
957: FND_API.G_MISS_NUM
958: , p_pte_source_system_id IN NUMBER :=
959: FND_API.G_MISS_NUM
960: ) RETURN QP_Attr_Map_PUB.Fna_Tbl_Type
961: IS
962: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
963: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
964:

Line 962: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

958: , p_pte_source_system_id IN NUMBER :=
959: FND_API.G_MISS_NUM
960: ) RETURN QP_Attr_Map_PUB.Fna_Tbl_Type
961: IS
962: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
963: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
964:
965: CURSOR l_FNA_csr IS
966: SELECT ATTRIBUTE1

Line 963: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

959: FND_API.G_MISS_NUM
960: ) RETURN QP_Attr_Map_PUB.Fna_Tbl_Type
961: IS
962: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
963: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
964:
965: CURSOR l_FNA_csr IS
966: SELECT ATTRIBUTE1
967: , ATTRIBUTE10

Line 1108: , p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type

1104: --
1105:
1106: PROCEDURE Lock_Row
1107: ( x_return_status OUT NOCOPY VARCHAR2
1108: , p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
1109: , x_FNA_rec OUT NOCOPY QP_Attr_Map_PUB.Fna_Rec_Type
1110: )
1111: IS
1112: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 1109: , x_FNA_rec OUT NOCOPY QP_Attr_Map_PUB.Fna_Rec_Type

1105:
1106: PROCEDURE Lock_Row
1107: ( x_return_status OUT NOCOPY VARCHAR2
1108: , p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
1109: , x_FNA_rec OUT NOCOPY QP_Attr_Map_PUB.Fna_Rec_Type
1110: )
1111: IS
1112: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1113: BEGIN

Line 1112: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

1108: , p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
1109: , x_FNA_rec OUT NOCOPY QP_Attr_Map_PUB.Fna_Rec_Type
1110: )
1111: IS
1112: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1113: BEGIN
1114:
1115: SELECT ATTRIBUTE1
1116: , ATTRIBUTE10

Line 1313: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type

1309:
1310: -- Function Get_Values
1311:
1312: FUNCTION Get_Values
1313: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
1314: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=
1315: QP_Attr_Map_PUB.G_MISS_FNA_REC
1316: ) RETURN QP_Attr_Map_PUB.Fna_Val_Rec_Type
1317: IS

Line 1314: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=

1310: -- Function Get_Values
1311:
1312: FUNCTION Get_Values
1313: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
1314: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=
1315: QP_Attr_Map_PUB.G_MISS_FNA_REC
1316: ) RETURN QP_Attr_Map_PUB.Fna_Val_Rec_Type
1317: IS
1318: l_FNA_val_rec QP_Attr_Map_PUB.Fna_Val_Rec_Type;

Line 1315: QP_Attr_Map_PUB.G_MISS_FNA_REC

1311:
1312: FUNCTION Get_Values
1313: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
1314: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=
1315: QP_Attr_Map_PUB.G_MISS_FNA_REC
1316: ) RETURN QP_Attr_Map_PUB.Fna_Val_Rec_Type
1317: IS
1318: l_FNA_val_rec QP_Attr_Map_PUB.Fna_Val_Rec_Type;
1319: BEGIN

Line 1316: ) RETURN QP_Attr_Map_PUB.Fna_Val_Rec_Type

1312: FUNCTION Get_Values
1313: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
1314: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=
1315: QP_Attr_Map_PUB.G_MISS_FNA_REC
1316: ) RETURN QP_Attr_Map_PUB.Fna_Val_Rec_Type
1317: IS
1318: l_FNA_val_rec QP_Attr_Map_PUB.Fna_Val_Rec_Type;
1319: BEGIN
1320:

Line 1318: l_FNA_val_rec QP_Attr_Map_PUB.Fna_Val_Rec_Type;

1314: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=
1315: QP_Attr_Map_PUB.G_MISS_FNA_REC
1316: ) RETURN QP_Attr_Map_PUB.Fna_Val_Rec_Type
1317: IS
1318: l_FNA_val_rec QP_Attr_Map_PUB.Fna_Val_Rec_Type;
1319: BEGIN
1320:
1321: IF p_FNA_rec.enabled_flag IS NOT NULL AND
1322: p_FNA_rec.enabled_flag <> FND_API.G_MISS_CHAR AND

Line 1386: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type

1382:
1383: -- Function Get_Ids
1384:
1385: FUNCTION Get_Ids
1386: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
1387: , p_FNA_val_rec IN QP_Attr_Map_PUB.Fna_Val_Rec_Type
1388: ) RETURN QP_Attr_Map_PUB.Fna_Rec_Type
1389: IS
1390: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 1387: , p_FNA_val_rec IN QP_Attr_Map_PUB.Fna_Val_Rec_Type

1383: -- Function Get_Ids
1384:
1385: FUNCTION Get_Ids
1386: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
1387: , p_FNA_val_rec IN QP_Attr_Map_PUB.Fna_Val_Rec_Type
1388: ) RETURN QP_Attr_Map_PUB.Fna_Rec_Type
1389: IS
1390: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1391: BEGIN

Line 1388: ) RETURN QP_Attr_Map_PUB.Fna_Rec_Type

1384:
1385: FUNCTION Get_Ids
1386: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
1387: , p_FNA_val_rec IN QP_Attr_Map_PUB.Fna_Val_Rec_Type
1388: ) RETURN QP_Attr_Map_PUB.Fna_Rec_Type
1389: IS
1390: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1391: BEGIN
1392:

Line 1390: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

1386: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
1387: , p_FNA_val_rec IN QP_Attr_Map_PUB.Fna_Val_Rec_Type
1388: ) RETURN QP_Attr_Map_PUB.Fna_Rec_Type
1389: IS
1390: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1391: BEGIN
1392:
1393: -- initialize return_status.
1394: