APPS.CN_TRANSACTION_LOAD_PUB dependencies on CN_COMM_LINES_API_ALL

Line 476: cn_comm_lines_api_all api

472: api.split_pct,
473: api.split_status,
474: api.org_id
475: FROM
476: cn_comm_lines_api_all api
477: WHERE
478: api.load_status = 'UNLOADED' AND
479: api.processed_date >= TRUNC(p_start_date) AND
480: api.processed_date < (TRUNC(p_end_date) + 1) AND

Line 820: cn_comm_lines_api_all api

816: api.split_pct,
817: api.split_status,
818: api.org_id
819: FROM
820: cn_comm_lines_api_all api
821: WHERE
822: api.load_status = 'UNLOADED' AND
823: api.processed_date >= TRUNC(p_start_date) AND
824: api.processed_date < (TRUNC(p_end_date) + 1) AND

Line 838: UPDATE cn_comm_lines_api_all api

834:
835: debugmsg('Loader : number of loaded trx = ' ||to_char(SQL%ROWCOUNT));
836:
837: IF (l_skip_credit_flag = 'Y') THEN
838: UPDATE cn_comm_lines_api_all api
839: SET load_Status = 'LOADED'
840: WHERE
841: api.load_status = 'UNLOADED' AND
842: api.processed_date >= TRUNC(p_start_date) AND

Line 852: UPDATE cn_comm_lines_api_all api

848: api.processed_date >= Trunc(batch.start_date) AND
849: api.processed_date < (Trunc(batch.end_date) + 1) AND
850: api.org_id = p_org_id;
851: ELSE
852: UPDATE cn_comm_lines_api_all api
853: SET load_Status = 'LOADED'
854: WHERE
855: api.load_status = 'UNLOADED' AND
856: api.processed_date >= TRUNC(p_start_date) AND

Line 1142: cn_comm_lines_api_all api,

1138: acc.start_date start_date,
1139: acc.end_date end_date,
1140: count(*) trx_count
1141: FROM
1142: cn_comm_lines_api_all api,
1143: cn_acc_period_statuses_v acc
1144: WHERE
1145: api.load_status = 'UNLOADED' AND
1146: api.trx_type <> 'FORECAST' AND

Line 1174: cn_comm_lines_api_all api,

1170: acc.start_date start_date,
1171: acc.end_date end_date,
1172: count(*) trx_count
1173: FROM
1174: cn_comm_lines_api_all api,
1175: cn_acc_period_statuses_v acc
1176: WHERE
1177: api.load_status = 'UNLOADED' AND
1178: api.trx_type <> 'FORECAST' AND

Line 1730: UPDATE cn_comm_lines_api_all

1726: WHEN no_valid_transactions THEN
1727: OPEN logical_batches(p_salesrep_id, p_start_date, p_end_date, p_org_id);
1728: ROLLBACK TO load_savepoint;
1729:
1730: UPDATE cn_comm_lines_api_all
1731: SET load_status = 'SALESREP ERROR'
1732: WHERE
1733: load_status = 'UNLOADED' AND
1734: trx_type <> 'FORECAST' AND