DBA Data[Home] [Help]

APPS.AHL_DI_ASSO_DOC_ASO_PVT dependencies on AHL_DOC_TITLE_ASSOS_PKG

Line 357: /* procedure name: AHL_DOC_TITLE_ASSOS_PKG.DELETE_ROW */

353: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TL_REC_CHANGED');
354: FND_MSG_PUB.ADD;
355: END IF;
356: /*-------------------------------------------------------- */
357: /* procedure name: AHL_DOC_TITLE_ASSOS_PKG.DELETE_ROW */
358: /* description : Added by Senthil to call Table Handler */
359: /* Date : Dec 31 2001 */
360: /*---------------------------------------------------------*/
361: -- Delete the record from document associations table and association Trans table

Line 362: AHL_DOC_TITLE_ASSOS_PKG.DELETE_ROW(

358: /* description : Added by Senthil to call Table Handler */
359: /* Date : Dec 31 2001 */
360: /*---------------------------------------------------------*/
361: -- Delete the record from document associations table and association Trans table
362: AHL_DOC_TITLE_ASSOS_PKG.DELETE_ROW(
363: X_DOC_TITLE_ASSO_ID => p_association_rec.doc_title_asso_id
364: );
365: /*
366: -- Delete the record from document associations table

Line 851: /* procedure name: AHL_DOC_TITLE_ASSOS_PKG.INSERT_ROW */

847: SELECT AHL_DOC_TITLE_ASSOS_B_S.Nextval INTO
848: l_doc_title_asso_id from DUAL;
849:
850: /*-------------------------------------------------------- */
851: /* procedure name: AHL_DOC_TITLE_ASSOS_PKG.INSERT_ROW */
852: /* description : Added by Senthil to call Table Handler */
853: /* Date : Dec 31 2001 */
854: /*---------------------------------------------------------*/
855: --Insert the record into doc title assos table and tranlations table

Line 856: AHL_DOC_TITLE_ASSOS_PKG.INSERT_ROW(

852: /* description : Added by Senthil to call Table Handler */
853: /* Date : Dec 31 2001 */
854: /*---------------------------------------------------------*/
855: --Insert the record into doc title assos table and tranlations table
856: AHL_DOC_TITLE_ASSOS_PKG.INSERT_ROW(
857: X_ROWID => l_rowid,
858: X_DOC_TITLE_ASSO_ID => l_doc_title_asso_id,
859: X_SERIAL_NO => l_association_info.serial_no,
860: X_ATTRIBUTE_CATEGORY => l_association_info.attribute_category,

Line 1443: /* procedure name: AHL_DOC_TITLE_ASSOS_PKG.UPDATE_ROW */

1439: END IF;
1440: CLOSE dup_rec_check;
1441: END IF;
1442: /*-------------------------------------------------------- */
1443: /* procedure name: AHL_DOC_TITLE_ASSOS_PKG.UPDATE_ROW */
1444: /* description : Added by Senthil to call Table Handler */
1445: /* Date : Dec 31 2001 */
1446: /*---------------------------------------------------------*/
1447: -- Update doc title assos table and trans table

Line 1448: AHL_DOC_TITLE_ASSOS_PKG.UPDATE_ROW(

1444: /* description : Added by Senthil to call Table Handler */
1445: /* Date : Dec 31 2001 */
1446: /*---------------------------------------------------------*/
1447: -- Update doc title assos table and trans table
1448: AHL_DOC_TITLE_ASSOS_PKG.UPDATE_ROW(
1449: X_DOC_TITLE_ASSO_ID => p_x_association_tbl(i).doc_title_asso_id,
1450: X_SERIAL_NO => l_association_info.serial_no,
1451: X_ATTRIBUTE_CATEGORY => l_association_info.attribute_category,
1452: X_ATTRIBUTE1 => l_association_info.attribute1,

Line 1889: /* procedure name: AHL_DOC_TITLE_ASSOS_PKG.INSERT_ROW */

1885: --Gets the sequence Number
1886: SELECT AHL_DOC_TITLE_ASSOS_B_S.NEXTVAL INTO
1887: l_doc_title_asso_id FROM DUAL;
1888: /*-------------------------------------------------------- */
1889: /* procedure name: AHL_DOC_TITLE_ASSOS_PKG.INSERT_ROW */
1890: /* description : Added by Senthil to call Table Handler */
1891: /* Date : Dec 31 2001 */
1892: /*---------------------------------------------------------*/
1893: --Insert the record into doc title assos table and tranlations table

Line 1894: AHL_DOC_TITLE_ASSOS_PKG.INSERT_ROW(

1890: /* description : Added by Senthil to call Table Handler */
1891: /* Date : Dec 31 2001 */
1892: /*---------------------------------------------------------*/
1893: --Insert the record into doc title assos table and tranlations table
1894: AHL_DOC_TITLE_ASSOS_PKG.INSERT_ROW(
1895: X_ROWID => l_rowid,
1896: X_DOC_TITLE_ASSO_ID => l_doc_title_asso_id,
1897: X_SERIAL_NO => l_association_info.serial_no,
1898: X_ATTRIBUTE_CATEGORY => l_association_info.attribute_category,