APPS.ASO_PRICE_RLTSHIPS_PKG dependencies on ASO_PRICE_ADJ_RELATIONSHIPS

Line 38: INSERT INTO ASO_PRICE_ADJ_RELATIONSHIPS(

34: OPEN C2;
35: FETCH C2 INTO px_ADJ_RELATIONSHIP_ID;
36: CLOSE C2;
37: End If;
38: INSERT INTO ASO_PRICE_ADJ_RELATIONSHIPS(
39: ADJ_RELATIONSHIP_ID,
40: CREATION_DATE,
41: CREATED_BY,
42: LAST_UPDATED_BY,

Line 93: Update ASO_PRICE_ADJ_RELATIONSHIPS

89: )
90:
91: IS
92: BEGIN
93: Update ASO_PRICE_ADJ_RELATIONSHIPS
94: SET
95: CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
96: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
97: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

Line 121: DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS

117: PROCEDURE Delete_Row(
118: p_ADJ_RELATIONSHIP_ID NUMBER)
119: IS
120: BEGIN
121: DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS
122: WHERE ADJ_RELATIONSHIP_ID = p_ADJ_RELATIONSHIP_ID;
123: If (SQL%NOTFOUND) then
124: RAISE NO_DATA_FOUND;
125: End If;

Line 161: FROM ASO_PRICE_ADJ_RELATIONSHIPS

157: QUOTE_LINE_ID,
158: PRICE_ADJUSTMENT_ID,
159: RLTD_PRICE_ADJ_ID,
160: quote_shipment_id
161: FROM ASO_PRICE_ADJ_RELATIONSHIPS
162: WHERE ADJ_RELATIONSHIP_ID = p_ADJ_RELATIONSHIP_ID
163: FOR UPDATE of ADJ_RELATIONSHIP_ID NOWAIT;
164: Recinfo C%ROWTYPE;
165: BEGIN