DBA Data[Home] [Help]

APPS.ASO_HEADER_RLTSHIP_PVT dependencies on ASO_HEADER_RELATIONSHIPS

Line 96: -- Invoke table handler(ASO_HEADER_RELATIONSHIPS_PKG.Insert_Row)

92: RAISE FND_API.G_EXC_ERROR;
93: END IF;
94:
95:
96: -- Invoke table handler(ASO_HEADER_RELATIONSHIPS_PKG.Insert_Row)
97: ASO_HEADER_RELATIONSHIPS_PKG.Insert_Row(
98: px_HEADER_RELATIONSHIP_ID => x_HEADER_RELATIONSHIP_ID,
99: p_CREATION_DATE => SYSDATE,
100: p_CREATED_BY => G_USER_ID,

Line 97: ASO_HEADER_RELATIONSHIPS_PKG.Insert_Row(

93: END IF;
94:
95:
96: -- Invoke table handler(ASO_HEADER_RELATIONSHIPS_PKG.Insert_Row)
97: ASO_HEADER_RELATIONSHIPS_PKG.Insert_Row(
98: px_HEADER_RELATIONSHIP_ID => x_HEADER_RELATIONSHIP_ID,
99: p_CREATION_DATE => SYSDATE,
100: p_CREATED_BY => G_USER_ID,
101: p_LAST_UPDATE_DATE => SYSDATE,

Line 198: From ASO_HEADER_RELATIONSHIPS

194: QUOTE_HEADER_ID,
195: RELATED_HEADER_ID,
196: RELATIONSHIP_TYPE_CODE,
197: RECIPROCAL_FLAG
198: From ASO_HEADER_RELATIONSHIPS
199: where HEADER_RELATIONSHIP_ID = P_HEADER_RELATIONSHIP_ID;
200:
201: l_api_name CONSTANT VARCHAR2(30) := 'Update_header_rltship';
202: l_api_version_number CONSTANT NUMBER := 1.0;

Line 289: -- Invoke table handler(ASO_HEADER_RELATIONSHIPS_PKG.Update_Row)

285: END IF;
286: raise FND_API.G_EXC_ERROR;
287: End if;
288:
289: -- Invoke table handler(ASO_HEADER_RELATIONSHIPS_PKG.Update_Row)
290: ASO_HEADER_RELATIONSHIPS_PKG.Update_Row(
291: p_HEADER_RELATIONSHIP_ID => p_HEADER_RLTSHIP_rec.HEADER_RELATIONSHIP_ID,
292: p_CREATION_DATE => SYSDATE,
293: p_CREATED_BY => G_USER_ID,

Line 290: ASO_HEADER_RELATIONSHIPS_PKG.Update_Row(

286: raise FND_API.G_EXC_ERROR;
287: End if;
288:
289: -- Invoke table handler(ASO_HEADER_RELATIONSHIPS_PKG.Update_Row)
290: ASO_HEADER_RELATIONSHIPS_PKG.Update_Row(
291: p_HEADER_RELATIONSHIP_ID => p_HEADER_RLTSHIP_rec.HEADER_RELATIONSHIP_ID,
292: p_CREATION_DATE => SYSDATE,
293: p_CREATED_BY => G_USER_ID,
294: p_LAST_UPDATE_DATE => SYSDATE,

Line 417: -- Invoke table handler(ASO_HEADER_RELATIONSHIPS_PKG.Delete_Row)

413: --
414: -- Api body
415: --
416:
417: -- Invoke table handler(ASO_HEADER_RELATIONSHIPS_PKG.Delete_Row)
418: ASO_HEADER_RELATIONSHIPS_PKG.Delete_Row(
419: p_HEADER_RELATIONSHIP_ID => p_HEADER_RLTSHIP_ID);
420: --
421: -- End of API body

Line 418: ASO_HEADER_RELATIONSHIPS_PKG.Delete_Row(

414: -- Api body
415: --
416:
417: -- Invoke table handler(ASO_HEADER_RELATIONSHIPS_PKG.Delete_Row)
418: ASO_HEADER_RELATIONSHIPS_PKG.Delete_Row(
419: p_HEADER_RELATIONSHIP_ID => p_HEADER_RLTSHIP_ID);
420: --
421: -- End of API body
422: --

Line 484: ASO_HEADER_RELATIONSHIPS

480: )
481: IS
482: CURSOR related_headers(p_header_id NUMBER) IS
483: SELECT header_relationship_id FROM
484: ASO_HEADER_RELATIONSHIPS
485: WHERE QUOTE_HEADER_ID = p_header_id
486: OR RELATED_HEADER_ID = p_header_id;
487:
488: