886: X_FIGURE => l_association_info.figure,
887: X_PAGE => l_association_info.page,
888: X_NOTE => l_association_info.note,
889: X_CREATION_DATE => sysdate,
890: X_CREATED_BY => fnd_global.user_id,
891: X_LAST_UPDATE_DATE => sysdate,
892: X_LAST_UPDATED_BY => fnd_global.user_id,
893: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
894: --Assign the doc title asso id,object version number
888: X_NOTE => l_association_info.note,
889: X_CREATION_DATE => sysdate,
890: X_CREATED_BY => fnd_global.user_id,
891: X_LAST_UPDATE_DATE => sysdate,
892: X_LAST_UPDATED_BY => fnd_global.user_id,
893: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
894: --Assign the doc title asso id,object version number
895: p_x_association_tbl(i).doc_title_asso_id := l_doc_title_asso_id;
896: p_x_association_tbl(i).object_version_number := 1;
889: X_CREATION_DATE => sysdate,
890: X_CREATED_BY => fnd_global.user_id,
891: X_LAST_UPDATE_DATE => sysdate,
892: X_LAST_UPDATED_BY => fnd_global.user_id,
893: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
894: --Assign the doc title asso id,object version number
895: p_x_association_tbl(i).doc_title_asso_id := l_doc_title_asso_id;
896: p_x_association_tbl(i).object_version_number := 1;
897: --Standard check to count messages
1477: X_FIGURE => l_association_tl_info.figure,
1478: X_PAGE => l_association_tl_info.page,
1479: X_NOTE => l_association_tl_info.note,
1480: X_LAST_UPDATE_DATE => sysdate,
1481: X_LAST_UPDATED_BY => fnd_global.user_id,
1482: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
1483: --In case of delete
1484: ELSIF (p_x_association_tbl(i).doc_title_asso_id IS NOT NULL
1485: AND
1478: X_PAGE => l_association_tl_info.page,
1479: X_NOTE => l_association_tl_info.note,
1480: X_LAST_UPDATE_DATE => sysdate,
1481: X_LAST_UPDATED_BY => fnd_global.user_id,
1482: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
1483: --In case of delete
1484: ELSIF (p_x_association_tbl(i).doc_title_asso_id IS NOT NULL
1485: AND
1486: p_x_association_tbl(i).delete_flag = 'Y' )
1924: X_FIGURE => l_association_info.figure,
1925: X_PAGE => l_association_info.page,
1926: X_NOTE => l_association_info.note,
1927: X_CREATION_DATE => sysdate,
1928: X_CREATED_BY => fnd_global.user_id,
1929: X_LAST_UPDATE_DATE => sysdate,
1930: X_LAST_UPDATED_BY => fnd_global.user_id,
1931: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
1932: --Standard check to count messages
1926: X_NOTE => l_association_info.note,
1927: X_CREATION_DATE => sysdate,
1928: X_CREATED_BY => fnd_global.user_id,
1929: X_LAST_UPDATE_DATE => sysdate,
1930: X_LAST_UPDATED_BY => fnd_global.user_id,
1931: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
1932: --Standard check to count messages
1933: l_msg_count := Fnd_Msg_Pub.count_msg;
1934:
1927: X_CREATION_DATE => sysdate,
1928: X_CREATED_BY => fnd_global.user_id,
1929: X_LAST_UPDATE_DATE => sysdate,
1930: X_LAST_UPDATED_BY => fnd_global.user_id,
1931: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
1932: --Standard check to count messages
1933: l_msg_count := Fnd_Msg_Pub.count_msg;
1934:
1935: IF l_msg_count > 0 THEN