DBA Data[Home] [Help]

APPS.CN_COLLECTION_AIA_PUB dependencies on CN_GET_TX_DATA_PUB

Line 1878: l_adj_rec_type cn_get_tx_data_pub.adj_rec_type;

1874: AND org_id = l_org_id ;
1875:
1876:
1877: l_comm_lines_id NUMBER;
1878: l_adj_rec_type cn_get_tx_data_pub.adj_rec_type;
1879: l_api_id NUMBER;
1880: l_return_status VARCHAR2(100);
1881: l_msg_count NUMBER;
1882: l_msg_data VARCHAR2(2000);

Line 2218: cn_get_tx_data_pub.update_api_record ( p_api_version => 1.0, p_newtx_rec => l_adj_rec_type, x_api_id => l_api_id, x_return_status => l_return_status , x_msg_count => l_msg_count , x_msg_data => l_msg_data, x_loading_status => l_loading_status);

2214: --x_return_status := 'F';
2215: --DBMS_OUTPUT.put_line('CN_COLLECTION_AIA_PUB.updaterow_comm_api:exception in debug messages others: ' || '[ ' || SQLERRM(SQLCODE()) || ' ]');
2216: debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api:exception in debug messages others: ' || SQLERRM(SQLCODE()) );
2217: end;
2218: cn_get_tx_data_pub.update_api_record ( p_api_version => 1.0, p_newtx_rec => l_adj_rec_type, x_api_id => l_api_id, x_return_status => l_return_status , x_msg_count => l_msg_count , x_msg_data => l_msg_data, x_loading_status => l_loading_status);
2219: -- DBMS_OUTPUT.put_line('Start update' || l_collect_aia_tbl(i).invoice_number);
2220: -- DBMS_OUTPUT.put_line('Start update' || l_comm_lines_id);
2221: debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: updating update_flag to N of CN_COLLECTION_AIA : ' );
2222: UPDATE CN_COLLECTION_AIA