APPS.OKC_ARTICLES_IMPORT_GRP dependencies on OKC_ART_INT_BATPROCS_ALL

Line 154: FROM OKC_ART_INT_BATPROCS_ALL a,

150: CURSOR get_info_csr IS
151: SELECT
152: total_rows_processed,total_rows_failed,
153: f.meaning entity_meaning
154: FROM OKC_ART_INT_BATPROCS_ALL a,
155: fnd_lookups f
156: WHERE UPPER(a.entity) = f.lookup_code
157: and f.lookup_type = 'OKC_ARTICLE_IMPORT_ENTITY'
158: and a.batch_process_id = p_batch_procs_id

Line 419: FROM OKC_ART_INT_BATPROCS_ALL

415: WHERE lookup_type = 'OKC_YN' and lookup_code = cp_code;
416:
417: CURSOR import_src_csr IS
418: SELECT import_source
419: FROM OKC_ART_INT_BATPROCS_ALL
420: WHERE batch_process_id = p_batch_procs_id
421: and batch_number = p_batch_number
422: and rownum =1;
423:

Line 433: FROM OKC_ART_INT_BATPROCS_ALL a,

429: fnd_date.date_to_displaydt( a.start_date, FND_DATE.calendar_aware_alt) start_date,
430: f.meaning validate_meaning,
431: nvl(f1.meaning,' ') global_flag_meaning,
432: nvl(f2.meaning,' ') status_meaning
433: FROM OKC_ART_INT_BATPROCS_ALL a,
434: fnd_lookups f,fnd_lookups f1,fnd_lookups f2,hr_organization_units hr
435: WHERE a.validate_only_yn = f.lookup_code
436: and f.lookup_type = 'OKC_YN'
437: and a.global_flag = f1.lookup_code (+)

Line 452: FROM OKC_ART_INT_BATPROCS_ALL a,

448: CURSOR get_old_info_csr IS
449: SELECT
450: fnd_date.date_to_displaydt( a.start_date, FND_DATE.calendar_aware_alt) start_date,
451: f.meaning validate_meaning,a.fetch_size
452: FROM OKC_ART_INT_BATPROCS_ALL a,
453: fnd_lookups f
454: WHERE a.validate_only_yn = f.lookup_code
455: and f.lookup_type = 'OKC_YN'
456: and a.batch_process_id = p_batch_procs_id

Line 602: FROM OKC_ART_INT_BATPROCS_ALL

598: p_msg_name => 'OKC_ART_WARN_PUR_ALL_DELETED');
599: DELETE FROM OKC_ART_INT_ERRORS
600: WHERE batch_process_id in
601: ( SELECT batch_process_id
602: FROM OKC_ART_INT_BATPROCS_ALL
603: WHERE org_id = G_CURRENT_ORG_ID
604: AND batch_number in
605: (SELECT batch_number
606: FROM OKC_ART_INTERFACE_ALL

Line 664: FROM OKC_ART_INT_BATPROCS_ALL

660: -- this will clean the remaining error not related to interface_id
661: -- such as SQL exception etc.
662: DELETE FROM OKC_ART_INT_ERRORS
663: WHERE batch_process_id in ( SELECT batch_process_id
664: FROM OKC_ART_INT_BATPROCS_ALL
665: WHERE org_id = G_CURRENT_ORG_ID
666: AND batch_number not in
667: (SELECT batch_number
668: FROM OKC_ART_INTERFACE_ALL

Line 752: SUBTYPE entity IS OKC_ART_INT_BATPROCS_ALL.ENTITY%TYPE;

748: l_part_rel_rows_processed NUMBER := 0;
749: l_part_rel_rows_failed NUMBER := 0;
750: l_part_rel_rows_warned NUMBER := 0;
751:
752: SUBTYPE entity IS OKC_ART_INT_BATPROCS_ALL.ENTITY%TYPE;
753:
754: TYPE entity_tbl_type IS TABLE OF entity;
755: l_entity_tbl_type entity_tbl_type;
756:

Line 837: OKC_ART_INT_BATPROCS_ALL_S1.nextval into lc_batch_process_id

833: -- Need to initialize the record for each entity
834: l_entity_tbl_type := entity_tbl_type('Clause','Variable','Relationship','Valueset','Value');
835: -- Generate batch_process_id
836: SELECT
837: OKC_ART_INT_BATPROCS_ALL_S1.nextval into lc_batch_process_id
838: FROM DUAL;
839:
840: FOR i IN 1..l_entity_tbl_type.LAST LOOP
841:

Line 842: INSERT INTO OKC_ART_INT_BATPROCS_ALL

838: FROM DUAL;
839:
840: FOR i IN 1..l_entity_tbl_type.LAST LOOP
841:
842: INSERT INTO OKC_ART_INT_BATPROCS_ALL
843: (
844: BATCH_PROCESS_ID,
845: OBJECT_VERSION_NUMBER,
846: BATCH_NUMBER,

Line 1261: UPDATE OKC_ART_INT_BATPROCS_ALL

1257: END IF;
1258: END LOOP;
1259:
1260: --Update Batch Process Table with the clause related process counts
1261: UPDATE OKC_ART_INT_BATPROCS_ALL
1262: SET
1263: TOTAL_ROWS_PROCESSED = l_tot_art_rows_processed,
1264: TOTAL_ROWS_FAILED = l_tot_art_rows_failed,
1265: TOTAL_ROWS_WARNED = l_tot_art_rows_warned,

Line 1280: UPDATE OKC_ART_INT_BATPROCS_ALL

1276: BATCH_PROCESS_ID = l_batch_process_id
1277: AND ENTITY = 'Clause';
1278:
1279: --Update Batch Process Table with the relationship related counts
1280: UPDATE OKC_ART_INT_BATPROCS_ALL
1281: SET
1282: TOTAL_ROWS_PROCESSED = l_tot_rel_rows_processed,
1283: TOTAL_ROWS_FAILED = l_tot_rel_rows_failed,
1284: TOTAL_ROWS_WARNED = l_tot_rel_rows_warned,

Line 4178: UPDATE OKC_ART_INT_BATPROCS_ALL

4174: --RAISE FND_API.G_EXC_ERROR ;
4175: END;
4176: /*********
4177: --Update Batch Process Table as a last step
4178: UPDATE OKC_ART_INT_BATPROCS_ALL
4179: SET
4180: TOTAL_ROWS_PROCESSED = l_tot_rows_processed,
4181: TOTAL_ROWS_FAILED = l_tot_rows_failed,
4182: TOTAL_ROWS_WARNED = l_tot_rows_warned,

Line 5807: UPDATE OKC_ART_INT_BATPROCS_ALL

5803: l_tot_rows_failed := l_tot_rows_failed + l_part_rows_failed;
5804: l_tot_rows_warned := l_tot_rows_warned + l_part_rows_warned;
5805:
5806: --Update Batch Process Table as a last step
5807: UPDATE OKC_ART_INT_BATPROCS_ALL
5808: SET
5809: TOTAL_ROWS_PROCESSED = l_tot_rows_processed,
5810: TOTAL_ROWS_FAILED = l_tot_rows_failed,
5811: TOTAL_ROWS_WARNED = l_tot_rows_warned,

Line 6924: UPDATE OKC_ART_INT_BATPROCS_ALL

6920: l_tot_rows_failed := l_tot_rows_failed + l_part_rows_failed;
6921: l_tot_rows_warned := l_tot_rows_warned + l_part_rows_warned;
6922: /*****************
6923: --Update Batch Process Table as a last step
6924: UPDATE OKC_ART_INT_BATPROCS_ALL
6925: SET
6926: TOTAL_ROWS_PROCESSED = l_tot_rows_processed,
6927: TOTAL_ROWS_FAILED = l_tot_rows_failed,
6928: TOTAL_ROWS_WARNED = l_tot_rows_warned,

Line 7927: UPDATE OKC_ART_INT_BATPROCS_ALL

7923: l_tot_rows_failed := l_tot_rows_failed + l_part_rows_failed;
7924: l_tot_rows_warned := l_tot_rows_warned + l_part_rows_warned;
7925:
7926: --Update Batch Process Table as a last step
7927: UPDATE OKC_ART_INT_BATPROCS_ALL
7928: SET
7929: TOTAL_ROWS_PROCESSED = l_tot_rows_processed,
7930: TOTAL_ROWS_FAILED = l_tot_rows_failed,
7931: TOTAL_ROWS_WARNED = l_tot_rows_warned,

Line 9072: UPDATE OKC_ART_INT_BATPROCS_ALL

9068: l_tot_rows_failed := l_tot_rows_failed + l_part_rows_failed;
9069: l_tot_rows_warned := l_tot_rows_warned + l_part_rows_warned;
9070:
9071: --Update Batch Process Table as a last step
9072: UPDATE OKC_ART_INT_BATPROCS_ALL
9073: SET
9074: TOTAL_ROWS_PROCESSED = l_tot_rows_processed,
9075: TOTAL_ROWS_FAILED = l_tot_rows_failed,
9076: TOTAL_ROWS_WARNED = l_tot_rows_warned,