675: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TL_REC_CHANGED');
676: FND_MSG_PUB.ADD;
677: END IF;
678: /*-------------------------------------------------------- */
679: /* procedure name: AHL_DOC_TITLE_ASSOS_PKG.DELETE_ROW */
680: /* description : Added by Senthil to call Table Handler */
681: /* Date : Dec 31 2001 */
682: /*---------------------------------------------------------*/
683: -- Delete the record from document associations table and association Trans table
680: /* description : Added by Senthil to call Table Handler */
681: /* Date : Dec 31 2001 */
682: /*---------------------------------------------------------*/
683: -- Delete the record from document associations table and association Trans table
684: AHL_DOC_TITLE_ASSOS_PKG.DELETE_ROW(
685: X_DOC_TITLE_ASSO_ID => p_association_rec.doc_title_asso_id
686: );
687: /*
688: -- Delete the record from document associations table
1246: AHL_DEBUG_PUB.debug( 'bafore 3 update Association','+DOBJASS+');
1247: END IF;
1248:
1249: /*-------------------------------------------------------- */
1250: /* procedure name: AHL_DOC_TITLE_ASSOS_PKG.UPDATE_ROW */
1251: /* description : Added by Senthil to call Table Handler */
1252: /* Date : Dec 31 2001 */
1253: /*---------------------------------------------------------*/
1254: -- Update doc title assos table and trans table
1251: /* description : Added by Senthil to call Table Handler */
1252: /* Date : Dec 31 2001 */
1253: /*---------------------------------------------------------*/
1254: -- Update doc title assos table and trans table
1255: AHL_DOC_TITLE_ASSOS_PKG.UPDATE_ROW(
1256: X_DOC_TITLE_ASSO_ID => p_x_association_tbl(i).doc_title_asso_id,
1257: X_SERIAL_NO => p_x_association_tbl(i).serial_no,
1258: X_ATTRIBUTE_CATEGORY => p_x_association_tbl(i).attribute_category,
1259: X_ATTRIBUTE1 => p_x_association_tbl(i).attribute1,
1298: SELECT AHL_DOC_TITLE_ASSOS_B_S.Nextval INTO
1299: l_doc_title_asso_id from DUAL;
1300:
1301: /*-------------------------------------------------------- */
1302: /* procedure name: AHL_DOC_TITLE_ASSOS_PKG.INSERT_ROW */
1303: /* description : Added by Senthil to call Table Handler */
1304: /* Date : Dec 31 2001 */
1305: /*---------------------------------------------------------*/
1306: --Insert the record into doc title assos table and tranlations table
1303: /* description : Added by Senthil to call Table Handler */
1304: /* Date : Dec 31 2001 */
1305: /*---------------------------------------------------------*/
1306: --Insert the record into doc title assos table and tranlations table
1307: AHL_DOC_TITLE_ASSOS_PKG.INSERT_ROW(
1308: X_ROWID => l_rowid,
1309: X_DOC_TITLE_ASSO_ID => l_doc_title_asso_id,
1310: X_SERIAL_NO => p_x_association_tbl(i).serial_no,
1311: X_ATTRIBUTE_CATEGORY => p_x_association_tbl(i).attribute_category,
1812: --Gets the sequence Number
1813: SELECT AHL_DOC_TITLE_ASSOS_B_S.NEXTVAL INTO
1814: l_doc_title_asso_id FROM DUAL;
1815: /*-------------------------------------------------------- */
1816: /* procedure name: AHL_DOC_TITLE_ASSOS_PKG.INSERT_ROW */
1817: /* description : Added by Senthil to call Table Handler */
1818: /* Date : Dec 31 2001 */
1819: /*---------------------------------------------------------*/
1820: --Insert the record into doc title assos table and tranlations table
1817: /* description : Added by Senthil to call Table Handler */
1818: /* Date : Dec 31 2001 */
1819: /*---------------------------------------------------------*/
1820: --Insert the record into doc title assos table and tranlations table
1821: AHL_DOC_TITLE_ASSOS_PKG.INSERT_ROW(
1822: X_ROWID => l_rowid,
1823: X_DOC_TITLE_ASSO_ID => l_doc_title_asso_id,
1824: X_SERIAL_NO => l_association_info.serial_no,
1825: X_ATTRIBUTE_CATEGORY => l_association_info.attribute_category,