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 1173: cn_comm_lines_api_all api,

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

Line 1728: UPDATE cn_comm_lines_api_all

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