eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_LIMIT_BALANCES_UTIL dependencies on QP_LIMITS

Line 12: , p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_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_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
13: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=
14: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC
15: , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Rec_Type
16: )

Line 13: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=

9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
13: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=
14: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC
15: , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Rec_Type
16: )
17: IS

Line 14: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC

10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
13: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=
14: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC
15: , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;

Line 15: , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Rec_Type

11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
13: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=
14: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC
15: , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

Line 426: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type

422:
423: -- Procedure Apply_Attribute_Changes
424:
425: PROCEDURE Apply_Attribute_Changes
426: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
427: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=
428: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC
429: , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Rec_Type
430: )

Line 427: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=

423: -- Procedure Apply_Attribute_Changes
424:
425: PROCEDURE Apply_Attribute_Changes
426: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
427: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=
428: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC
429: , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Rec_Type
430: )
431: IS

Line 428: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC

424:
425: PROCEDURE Apply_Attribute_Changes
426: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
427: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=
428: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC
429: , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Rec_Type
430: )
431: IS
432: BEGIN

Line 429: , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Rec_Type

425: PROCEDURE Apply_Attribute_Changes
426: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
427: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=
428: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC
429: , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Rec_Type
430: )
431: IS
432: BEGIN
433:

Line 659: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type

655:
656: -- Function Complete_Record
657:
658: FUNCTION Complete_Record
659: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
660: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
661: ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type
662: IS
663: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type := p_LIMIT_BALANCES_rec;

Line 660: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type

656: -- Function Complete_Record
657:
658: FUNCTION Complete_Record
659: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
660: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
661: ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type
662: IS
663: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type := p_LIMIT_BALANCES_rec;
664: BEGIN

Line 661: ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type

657:
658: FUNCTION Complete_Record
659: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
660: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
661: ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type
662: IS
663: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type := p_LIMIT_BALANCES_rec;
664: BEGIN
665:

Line 663: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type := p_LIMIT_BALANCES_rec;

659: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
660: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
661: ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type
662: IS
663: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type := p_LIMIT_BALANCES_rec;
664: BEGIN
665:
666: IF l_LIMIT_BALANCES_rec.attribute1 = FND_API.G_MISS_CHAR THEN
667: l_LIMIT_BALANCES_rec.attribute1 := p_old_LIMIT_BALANCES_rec.attribute1;

Line 845: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type

841:
842: -- Function Convert_Miss_To_Null
843:
844: FUNCTION Convert_Miss_To_Null
845: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
846: ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type
847: IS
848: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type := p_LIMIT_BALANCES_rec;
849: BEGIN

Line 846: ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type

842: -- Function Convert_Miss_To_Null
843:
844: FUNCTION Convert_Miss_To_Null
845: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
846: ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type
847: IS
848: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type := p_LIMIT_BALANCES_rec;
849: BEGIN
850:

Line 848: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type := p_LIMIT_BALANCES_rec;

844: FUNCTION Convert_Miss_To_Null
845: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
846: ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type
847: IS
848: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type := p_LIMIT_BALANCES_rec;
849: BEGIN
850:
851: IF l_LIMIT_BALANCES_rec.attribute1 = FND_API.G_MISS_CHAR THEN
852: l_LIMIT_BALANCES_rec.attribute1 := NULL;

Line 1030: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type

1026:
1027: -- Procedure Update_Row
1028:
1029: PROCEDURE Update_Row
1030: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
1031: )
1032: IS
1033: l_check_active_flag VARCHAR2(1);
1034: l_active_flag VARCHAR2(1);

Line 1038: FROM QP_LIMITS a,QP_LIST_HEADERS_B b

1034: l_active_flag VARCHAR2(1);
1035: BEGIN
1036: SELECT active_flag
1037: INTO l_active_flag
1038: FROM QP_LIMITS a,QP_LIST_HEADERS_B b
1039: WHERE a.limit_id=p_LIMIT_BALANCES_rec.limit_id
1040: AND b.list_header_id=a.list_header_id;
1041:
1042:

Line 1141: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type

1137:
1138: -- Procedure Insert_Row
1139:
1140: PROCEDURE Insert_Row
1141: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
1142: )
1143: IS
1144: l_check_active_flag VARCHAR2(1);
1145: l_active_flag VARCHAR2(1);

Line 1149: FROM QP_LIMITS a,QP_LIST_HEADERS_B b

1145: l_active_flag VARCHAR2(1);
1146: BEGIN
1147: SELECT active_flag
1148: INTO l_active_flag
1149: FROM QP_LIMITS a,QP_LIST_HEADERS_B b
1150: WHERE a.limit_id=p_LIMIT_BALANCES_rec.limit_id
1151: AND b.list_header_id=a.list_header_id;
1152:
1153: INSERT INTO QP_LIMIT_BALANCES

Line 1323: ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type

1319: -- Function Query_Row
1320:
1321: FUNCTION Query_Row
1322: ( p_limit_balance_id IN NUMBER
1323: ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type
1324: IS
1325: BEGIN
1326:
1327: RETURN Query_Rows

Line 1342: ) RETURN QP_Limits_PUB.Limit_Balances_Tbl_Type

1338: ( p_limit_balance_id IN NUMBER :=
1339: FND_API.G_MISS_NUM
1340: , p_limit_id IN NUMBER :=
1341: FND_API.G_MISS_NUM
1342: ) RETURN QP_Limits_PUB.Limit_Balances_Tbl_Type
1343: IS
1344: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1345: l_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
1346:

Line 1344: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;

1340: , p_limit_id IN NUMBER :=
1341: FND_API.G_MISS_NUM
1342: ) RETURN QP_Limits_PUB.Limit_Balances_Tbl_Type
1343: IS
1344: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1345: l_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
1346:
1347: CURSOR l_LIMIT_BALANCES_csr IS
1348: SELECT ATTRIBUTE1

Line 1345: l_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

1341: FND_API.G_MISS_NUM
1342: ) RETURN QP_Limits_PUB.Limit_Balances_Tbl_Type
1343: IS
1344: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1345: l_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
1346:
1347: CURSOR l_LIMIT_BALANCES_csr IS
1348: SELECT ATTRIBUTE1
1349: , ATTRIBUTE10

Line 1517: , p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type

1513: --
1514:
1515: PROCEDURE Lock_Row
1516: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1517: , p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
1518: , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Rec_Type
1519: )
1520: IS
1521: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;

Line 1518: , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Rec_Type

1514:
1515: PROCEDURE Lock_Row
1516: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1517: , p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
1518: , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Rec_Type
1519: )
1520: IS
1521: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1522: BEGIN

Line 1521: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;

1517: , p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
1518: , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Rec_Type
1519: )
1520: IS
1521: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1522: BEGIN
1523:
1524: SELECT ATTRIBUTE1
1525: , ATTRIBUTE10

Line 1774: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type

1770:
1771: -- Function Get_Values
1772:
1773: FUNCTION Get_Values
1774: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
1775: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=
1776: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC
1777: ) RETURN QP_Limits_PUB.Limit_Balances_Val_Rec_Type
1778: IS

Line 1775: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=

1771: -- Function Get_Values
1772:
1773: FUNCTION Get_Values
1774: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
1775: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=
1776: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC
1777: ) RETURN QP_Limits_PUB.Limit_Balances_Val_Rec_Type
1778: IS
1779: l_LIMIT_BALANCES_val_rec QP_Limits_PUB.Limit_Balances_Val_Rec_Type;

Line 1776: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC

1772:
1773: FUNCTION Get_Values
1774: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
1775: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=
1776: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC
1777: ) RETURN QP_Limits_PUB.Limit_Balances_Val_Rec_Type
1778: IS
1779: l_LIMIT_BALANCES_val_rec QP_Limits_PUB.Limit_Balances_Val_Rec_Type;
1780: BEGIN

Line 1777: ) RETURN QP_Limits_PUB.Limit_Balances_Val_Rec_Type

1773: FUNCTION Get_Values
1774: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
1775: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=
1776: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC
1777: ) RETURN QP_Limits_PUB.Limit_Balances_Val_Rec_Type
1778: IS
1779: l_LIMIT_BALANCES_val_rec QP_Limits_PUB.Limit_Balances_Val_Rec_Type;
1780: BEGIN
1781:

Line 1779: l_LIMIT_BALANCES_val_rec QP_Limits_PUB.Limit_Balances_Val_Rec_Type;

1775: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=
1776: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC
1777: ) RETURN QP_Limits_PUB.Limit_Balances_Val_Rec_Type
1778: IS
1779: l_LIMIT_BALANCES_val_rec QP_Limits_PUB.Limit_Balances_Val_Rec_Type;
1780: BEGIN
1781:
1782: IF p_LIMIT_BALANCES_rec.limit_balance_id IS NOT NULL AND
1783: p_LIMIT_BALANCES_rec.limit_balance_id <> FND_API.G_MISS_NUM AND

Line 1809: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type

1805:
1806: -- Function Get_Ids
1807:
1808: FUNCTION Get_Ids
1809: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
1810: , p_LIMIT_BALANCES_val_rec IN QP_Limits_PUB.Limit_Balances_Val_Rec_Type
1811: ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type
1812: IS
1813: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;

Line 1810: , p_LIMIT_BALANCES_val_rec IN QP_Limits_PUB.Limit_Balances_Val_Rec_Type

1806: -- Function Get_Ids
1807:
1808: FUNCTION Get_Ids
1809: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
1810: , p_LIMIT_BALANCES_val_rec IN QP_Limits_PUB.Limit_Balances_Val_Rec_Type
1811: ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type
1812: IS
1813: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1814: BEGIN

Line 1811: ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type

1807:
1808: FUNCTION Get_Ids
1809: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
1810: , p_LIMIT_BALANCES_val_rec IN QP_Limits_PUB.Limit_Balances_Val_Rec_Type
1811: ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type
1812: IS
1813: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1814: BEGIN
1815:

Line 1813: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;

1809: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
1810: , p_LIMIT_BALANCES_val_rec IN QP_Limits_PUB.Limit_Balances_Val_Rec_Type
1811: ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type
1812: IS
1813: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1814: BEGIN
1815:
1816: -- initialize return_status.
1817: