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) 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) 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 4112: UPDATE OKC_ART_INT_BATPROCS_ALL

4108: --RAISE FND_API.G_EXC_ERROR ;
4109: END;
4110: /*********
4111: --Update Batch Process Table as a last step
4112: UPDATE OKC_ART_INT_BATPROCS_ALL
4113: SET
4114: TOTAL_ROWS_PROCESSED = l_tot_rows_processed,
4115: TOTAL_ROWS_FAILED = l_tot_rows_failed,
4116: TOTAL_ROWS_WARNED = l_tot_rows_warned,

Line 5739: UPDATE OKC_ART_INT_BATPROCS_ALL

5735: l_tot_rows_failed := l_tot_rows_failed + l_part_rows_failed;
5736: l_tot_rows_warned := l_tot_rows_warned + l_part_rows_warned;
5737:
5738: --Update Batch Process Table as a last step
5739: UPDATE OKC_ART_INT_BATPROCS_ALL
5740: SET
5741: TOTAL_ROWS_PROCESSED = l_tot_rows_processed,
5742: TOTAL_ROWS_FAILED = l_tot_rows_failed,
5743: TOTAL_ROWS_WARNED = l_tot_rows_warned,

Line 6856: UPDATE OKC_ART_INT_BATPROCS_ALL

6852: l_tot_rows_failed := l_tot_rows_failed + l_part_rows_failed;
6853: l_tot_rows_warned := l_tot_rows_warned + l_part_rows_warned;
6854: /*****************
6855: --Update Batch Process Table as a last step
6856: UPDATE OKC_ART_INT_BATPROCS_ALL
6857: SET
6858: TOTAL_ROWS_PROCESSED = l_tot_rows_processed,
6859: TOTAL_ROWS_FAILED = l_tot_rows_failed,
6860: TOTAL_ROWS_WARNED = l_tot_rows_warned,

Line 7859: UPDATE OKC_ART_INT_BATPROCS_ALL

7855: l_tot_rows_failed := l_tot_rows_failed + l_part_rows_failed;
7856: l_tot_rows_warned := l_tot_rows_warned + l_part_rows_warned;
7857:
7858: --Update Batch Process Table as a last step
7859: UPDATE OKC_ART_INT_BATPROCS_ALL
7860: SET
7861: TOTAL_ROWS_PROCESSED = l_tot_rows_processed,
7862: TOTAL_ROWS_FAILED = l_tot_rows_failed,
7863: TOTAL_ROWS_WARNED = l_tot_rows_warned,

Line 9004: UPDATE OKC_ART_INT_BATPROCS_ALL

9000: l_tot_rows_failed := l_tot_rows_failed + l_part_rows_failed;
9001: l_tot_rows_warned := l_tot_rows_warned + l_part_rows_warned;
9002:
9003: --Update Batch Process Table as a last step
9004: UPDATE OKC_ART_INT_BATPROCS_ALL
9005: SET
9006: TOTAL_ROWS_PROCESSED = l_tot_rows_processed,
9007: TOTAL_ROWS_FAILED = l_tot_rows_failed,
9008: TOTAL_ROWS_WARNED = l_tot_rows_warned,