APPS.CN_SCA_CREDITS_BATCH_PUB dependencies on CN_COMMISSION_HEADERS_ALL

Line 1693: /* -- obsolete the corresponding record in cn_commission_headers_all */

1689: errbuf := 'CN_SCATM_TAE_PUB.process_new_txns.others';
1690: END process_new_txns;
1691:
1692: /* This procedure does the following for txns that have been loaded for calc */
1693: /* -- obsolete the corresponding record in cn_commission_headers_all */
1694: /* -- create a reversal entry in cn_comm_lines_api_all */
1695: PROCEDURE api_negate_record(
1696: p_api_id_tbl IN OUT NOCOPY g_comm_lines_api_id_tbl_type
1697: , p_rowid_tbl IN OUT NOCOPY g_rowid_tbl_type

Line 2067: FROM cn_comm_lines_api ccla, cn_commission_headers_all ccha

2063: , ccla.split_status
2064: , ccla.org_id
2065: , ccla.terr_id
2066: , ccla.terr_name
2067: FROM cn_comm_lines_api ccla, cn_commission_headers_all ccha
2068: WHERE ccla.ROWID = p_rowid_tbl(i)
2069: AND ccha.comm_lines_api_id = ccla.comm_lines_api_id
2070: AND ((ccha.adjust_status NOT IN('FROZEN', 'REVERSAL')) OR(ccha.adjust_status IS NULL))
2071: AND ccha.trx_type NOT IN('ITD', 'GRP', 'THR');

Line 2078: FROM cn_commission_headers_all

2074: UPDATE cn_commission_headers
2075: SET adjust_status = 'FROZEN'
2076: , reversal_header_id =
2077: (SELECT commission_header_id
2078: FROM cn_commission_headers_all
2079: WHERE comm_lines_api_id = p_api_id_tbl(i)
2080: AND ((adjust_status NOT IN('FROZEN', 'REVERSAL')) OR(adjust_status IS NULL))
2081: AND trx_type NOT IN('ITD', 'GRP', 'THR'))
2082: , reversal_flag = 'Y'