APPS.QP_PTE_UTIL dependencies on QP_ATTR_MAP_PUB

Line 12: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_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_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
13: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
14: QP_Attr_Map_PUB.G_MISS_PTE_REC
15: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
16: )

Line 13: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=

9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
13: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
14: QP_Attr_Map_PUB.G_MISS_PTE_REC
15: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
16: )
17: IS

Line 14: QP_Attr_Map_PUB.G_MISS_PTE_REC

10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
13: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
14: QP_Attr_Map_PUB.G_MISS_PTE_REC
15: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;

Line 15: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type

11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
13: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
14: QP_Attr_Map_PUB.G_MISS_PTE_REC
15: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

Line 102: ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type

98:
99: -- Procedure Apply_Attribute_Changes
100:
101: PROCEDURE Apply_Attribute_Changes
102: ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
103: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
104: QP_Attr_Map_PUB.G_MISS_PTE_REC
105: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
106: )

Line 103: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=

99: -- Procedure Apply_Attribute_Changes
100:
101: PROCEDURE Apply_Attribute_Changes
102: ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
103: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
104: QP_Attr_Map_PUB.G_MISS_PTE_REC
105: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
106: )
107: IS

Line 104: QP_Attr_Map_PUB.G_MISS_PTE_REC

100:
101: PROCEDURE Apply_Attribute_Changes
102: ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
103: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
104: QP_Attr_Map_PUB.G_MISS_PTE_REC
105: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
106: )
107: IS
108: BEGIN

Line 105: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type

101: PROCEDURE Apply_Attribute_Changes
102: ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
103: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
104: QP_Attr_Map_PUB.G_MISS_PTE_REC
105: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
106: )
107: IS
108: BEGIN
109:

Line 154: ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type

150:
151: -- Function Complete_Record
152:
153: FUNCTION Complete_Record
154: ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
155: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
156: ) RETURN QP_Attr_Map_PUB.Pte_Rec_Type
157: IS
158: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_PTE_rec;

Line 155: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type

151: -- Function Complete_Record
152:
153: FUNCTION Complete_Record
154: ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
155: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
156: ) RETURN QP_Attr_Map_PUB.Pte_Rec_Type
157: IS
158: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_PTE_rec;
159: BEGIN

Line 156: ) RETURN QP_Attr_Map_PUB.Pte_Rec_Type

152:
153: FUNCTION Complete_Record
154: ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
155: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
156: ) RETURN QP_Attr_Map_PUB.Pte_Rec_Type
157: IS
158: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_PTE_rec;
159: BEGIN
160:

Line 158: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_PTE_rec;

154: ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
155: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
156: ) RETURN QP_Attr_Map_PUB.Pte_Rec_Type
157: IS
158: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_PTE_rec;
159: BEGIN
160:
161: IF l_PTE_rec.description = FND_API.G_MISS_CHAR THEN
162: l_PTE_rec.description := p_old_PTE_rec.description;

Line 196: ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type

192:
193: -- Function Convert_Miss_To_Null
194:
195: FUNCTION Convert_Miss_To_Null
196: ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
197: ) RETURN QP_Attr_Map_PUB.Pte_Rec_Type
198: IS
199: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_PTE_rec;
200: BEGIN

Line 197: ) RETURN QP_Attr_Map_PUB.Pte_Rec_Type

193: -- Function Convert_Miss_To_Null
194:
195: FUNCTION Convert_Miss_To_Null
196: ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
197: ) RETURN QP_Attr_Map_PUB.Pte_Rec_Type
198: IS
199: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_PTE_rec;
200: BEGIN
201:

Line 199: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_PTE_rec;

195: FUNCTION Convert_Miss_To_Null
196: ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
197: ) RETURN QP_Attr_Map_PUB.Pte_Rec_Type
198: IS
199: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_PTE_rec;
200: BEGIN
201:
202: IF l_PTE_rec.description = FND_API.G_MISS_CHAR THEN
203: l_PTE_rec.description := NULL;

Line 237: ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type

233:
234: -- Procedure Update_Row
235:
236: PROCEDURE Update_Row
237: ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
238: )
239: IS
240: BEGIN
241:

Line 275: ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type

271:
272: -- Procedure Insert_Row
273:
274: PROCEDURE Insert_Row
275: ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
276: )
277: IS
278: BEGIN
279:

Line 352: ) RETURN QP_Attr_Map_PUB.Pte_Rec_Type

348: -- Function Query_Row
349:
350: FUNCTION Query_Row
351: ( p_lookup_code IN VARCHAR2
352: ) RETURN QP_Attr_Map_PUB.Pte_Rec_Type
353: IS
354: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
355: BEGIN
356:

Line 354: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

350: FUNCTION Query_Row
351: ( p_lookup_code IN VARCHAR2
352: ) RETURN QP_Attr_Map_PUB.Pte_Rec_Type
353: IS
354: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
355: BEGIN
356:
357: SELECT DESCRIPTION
358: , ENABLED_FLAG

Line 398: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type

394: --
395:
396: PROCEDURE Lock_Row
397: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
398: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
399: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
400: )
401: IS
402: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

Line 399: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type

395:
396: PROCEDURE Lock_Row
397: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
398: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
399: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
400: )
401: IS
402: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
403: BEGIN

Line 402: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

398: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
399: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
400: )
401: IS
402: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
403: BEGIN
404: null;
405: /*
406: SELECT DESCRIPTION

Line 512: ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type

508:
509: -- Function Get_Values
510:
511: FUNCTION Get_Values
512: ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
513: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
514: QP_Attr_Map_PUB.G_MISS_PTE_REC
515: ) RETURN QP_Attr_Map_PUB.Pte_Val_Rec_Type
516: IS

Line 513: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=

509: -- Function Get_Values
510:
511: FUNCTION Get_Values
512: ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
513: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
514: QP_Attr_Map_PUB.G_MISS_PTE_REC
515: ) RETURN QP_Attr_Map_PUB.Pte_Val_Rec_Type
516: IS
517: l_PTE_val_rec QP_Attr_Map_PUB.Pte_Val_Rec_Type;

Line 514: QP_Attr_Map_PUB.G_MISS_PTE_REC

510:
511: FUNCTION Get_Values
512: ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
513: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
514: QP_Attr_Map_PUB.G_MISS_PTE_REC
515: ) RETURN QP_Attr_Map_PUB.Pte_Val_Rec_Type
516: IS
517: l_PTE_val_rec QP_Attr_Map_PUB.Pte_Val_Rec_Type;
518: BEGIN

Line 515: ) RETURN QP_Attr_Map_PUB.Pte_Val_Rec_Type

511: FUNCTION Get_Values
512: ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
513: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
514: QP_Attr_Map_PUB.G_MISS_PTE_REC
515: ) RETURN QP_Attr_Map_PUB.Pte_Val_Rec_Type
516: IS
517: l_PTE_val_rec QP_Attr_Map_PUB.Pte_Val_Rec_Type;
518: BEGIN
519:

Line 517: l_PTE_val_rec QP_Attr_Map_PUB.Pte_Val_Rec_Type;

513: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
514: QP_Attr_Map_PUB.G_MISS_PTE_REC
515: ) RETURN QP_Attr_Map_PUB.Pte_Val_Rec_Type
516: IS
517: l_PTE_val_rec QP_Attr_Map_PUB.Pte_Val_Rec_Type;
518: BEGIN
519:
520: IF p_PTE_rec.enabled_flag IS NOT NULL AND
521: p_PTE_rec.enabled_flag <> FND_API.G_MISS_CHAR AND

Line 547: ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type

543:
544: -- Function Get_Ids
545:
546: FUNCTION Get_Ids
547: ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
548: , p_PTE_val_rec IN QP_Attr_Map_PUB.Pte_Val_Rec_Type
549: ) RETURN QP_Attr_Map_PUB.Pte_Rec_Type
550: IS
551: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

Line 548: , p_PTE_val_rec IN QP_Attr_Map_PUB.Pte_Val_Rec_Type

544: -- Function Get_Ids
545:
546: FUNCTION Get_Ids
547: ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
548: , p_PTE_val_rec IN QP_Attr_Map_PUB.Pte_Val_Rec_Type
549: ) RETURN QP_Attr_Map_PUB.Pte_Rec_Type
550: IS
551: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
552: BEGIN

Line 549: ) RETURN QP_Attr_Map_PUB.Pte_Rec_Type

545:
546: FUNCTION Get_Ids
547: ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
548: , p_PTE_val_rec IN QP_Attr_Map_PUB.Pte_Val_Rec_Type
549: ) RETURN QP_Attr_Map_PUB.Pte_Rec_Type
550: IS
551: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
552: BEGIN
553:

Line 551: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

547: ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
548: , p_PTE_val_rec IN QP_Attr_Map_PUB.Pte_Val_Rec_Type
549: ) RETURN QP_Attr_Map_PUB.Pte_Rec_Type
550: IS
551: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
552: BEGIN
553:
554: -- initialize return_status.
555: