eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZPB_AW_WRITE_BACK dependencies on ZPB_AW

Line 1: PACKAGE BODY ZPB_AW_WRITE_BACK AS

1: PACKAGE BODY ZPB_AW_WRITE_BACK AS
2: /* $Header: zpbwriteback.plb 120.10 2007/12/05 12:53:22 mbhat ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(17) := 'zpb_aw_write_back';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(17) := 'zpb_aw_write_back';

1: PACKAGE BODY ZPB_AW_WRITE_BACK AS
2: /* $Header: zpbwriteback.plb 120.10 2007/12/05 12:53:22 mbhat ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(17) := 'zpb_aw_write_back';
5:
6: ------------------------------------------------------------------------------
7: -- INITIALIZE - Initializes the session by attaching the AW's and setting the
8: -- context for a given business area

Line 20: ZPB_AW.INITIALIZE (p_api_version => 1.0,

16: l_user_id NUMBER;
17: begin
18: select USER_ID into l_user_id from FND_USER where USER_NAME = p_user_name;
19:
20: ZPB_AW.INITIALIZE (p_api_version => 1.0,
21: p_init_msg_list => FND_API.G_TRUE,
22: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
23: x_return_status => p_return_status,
24: x_msg_count => l_msg_count,

Line 44: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_log_user',

40: P_ORDER IN NUMBER,
41: P_QDR IN VARCHAR2)
42: IS
43: BEGIN
44: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_log_user',
45: 'ZPB_WRITEMGR_PROCESS_TASK',
46: 'TASK_NUMBER', to_char(p_task));
47: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_log_user',
48: 'ZPB_WRITEMGR_SUBMITTED_BY',

Line 47: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_log_user',

43: BEGIN
44: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_log_user',
45: 'ZPB_WRITEMGR_PROCESS_TASK',
46: 'TASK_NUMBER', to_char(p_task));
47: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_log_user',
48: 'ZPB_WRITEMGR_SUBMITTED_BY',
49: 'USER', p_user,
50: 'RESP', p_resp);
51: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_log_user',

Line 51: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_log_user',

47: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_log_user',
48: 'ZPB_WRITEMGR_SUBMITTED_BY',
49: 'USER', p_user,
50: 'RESP', p_resp);
51: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_log_user',
52: 'ZPB_WRITEMGR_EXECUTE',
53: 'ORDER', to_char(p_order));
54: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_log_user',
55: 'ZPB_WRITEMGR_PROCEDURE',

Line 54: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_log_user',

50: 'RESP', p_resp);
51: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_log_user',
52: 'ZPB_WRITEMGR_EXECUTE',
53: 'ORDER', to_char(p_order));
54: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_log_user',
55: 'ZPB_WRITEMGR_PROCEDURE',
56: 'PROC', p_qdr);
57: END l_log_user;
58:

Line 73: zpb_log.write ('ZPB_AW_WRITE_BACK.l_remove_old_records','Begin program :');

69: rcd_ct number;
70: prof_name varchar2(35);
71: l_aws varchar2(256);
72: BEGIN
73: zpb_log.write ('ZPB_AW_WRITE_BACK.l_remove_old_records','Begin program :');
74:
75: prof_name := 'ZPB_WRITEBACK_TABLE_NUMBER_OF_DAYS';
76: fnd_profile.get(prof_name, prof_num_of_days);
77: if prof_num_of_days is null then

Line 89: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_remove_old_records',

85: where (status = COMPLETED or status = FAILED)
86: and completion_date <= (SYSDATE - num_of_days);
87:
88: if rcd_ct > 0 then
89: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_remove_old_records',
90: 'ZPB_WRITEMGR_CLEANUP',
91: 'DATE', (SYSDATE - (num_of_days - 1)));
92:
93: delete from ZPB_WRITEBACK_TASKS

Line 97: zpb_log.write ('ZPB_AW_WRITE_BACK.l_remove_old_records','End program :');

93: delete from ZPB_WRITEBACK_TASKS
94: where (status = COMPLETED or status = FAILED)
95: and completion_date <= (SYSDATE - num_of_days);
96: end if;
97: zpb_log.write ('ZPB_AW_WRITE_BACK.l_remove_old_records','End program :');
98: END l_remove_old_records;
99:
100: ------------------------------------------------------------------------------
101: -- SUBMIT_WRITEBACK_REQUEST - Submits the writeback request

Line 281: --delete * from zpb_aw_references;

277: delete * from zpb_ac_param_values;
278: delete * from zpb_analysis_cycles;
279: delete * from zpb_analysis_cycle_instances;
280: delete * from zpb_analysis_cycle_tasks;
281: --delete * from zpb_aw_references;
282: delete * from zpb_cycle_model_dimensions;
283: delete * from zpb_cycle_relationships;
284: delete * from zpb_dc_distribution_lists;
285: delete * from zpb_dc_distribution_list_items;

Line 411: zpb_aw.execute(l_spl);

407: -- Delete the logic that would only execute the first dvac olap
408: -- command and execute the olap command for each v_tokens
409: -- if (v_tokens.exorder = 1) then
410: l_spl := v_tokens.token;
411: zpb_aw.execute(l_spl);
412: -- end if;
413: end loop;
414:
415: -- the following line is deleted to fix the bug 5007057

Line 416: -- zpb_aw.execute(l_spl);

412: -- end if;
413: end loop;
414:
415: -- the following line is deleted to fix the bug 5007057
416: -- zpb_aw.execute(l_spl);
417: -- end of bug 5007057
418:
419: --update the tasks table
420: update zpb_writeback_tasks set

Line 428: ZPB_AW.EXECUTE ('update');

424: where task_seq = v_task.taskseq;
425:
426: end loop;
427:
428: ZPB_AW.EXECUTE ('update');
429: commit;
430:
431: ZPB_AW.DETACH_ALL;
432:

Line 431: ZPB_AW.DETACH_ALL;

427:
428: ZPB_AW.EXECUTE ('update');
429: commit;
430:
431: ZPB_AW.DETACH_ALL;
432:
433: l_remove_old_records;
434: RETCODE := '0';
435:

Line 443: ZPB_AW.DETACH_ALL;

439: 'process_dvac_admin_task');
440: retcode := '2';
441: errNum := SQLCODE;
442: errbuf := sqlerrm(errNum);
443: ZPB_AW.DETACH_ALL;
444:
445: END process_dvac_writeback;
446:
447:

Line 512: zpb_log.write ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks','Begin program :');

508: AND a.task_type = 'DO'
509: ORDER BY b.exec_order ASC;
510:
511: BEGIN
512: zpb_log.write ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks','Begin program :');
513: errbuf := ' ';
514: retcode := '0';
515:
516: -- Added for Bug:5475982

Line 530: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',

526: errbuf);
527: l_initialized := true;
528: end if;
529:
530: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',
531: 'Updating writeback_tasks table with Status as FAILED for Task Seq: '||task );
532: --set the initial status to failed
533: update zpb_writeback_tasks set
534: status = FAILED, completion_date = SYSDATE,

Line 548: ZPB_AW.EXECUTE(v_task.token);

544: v_task.exorder, v_task.token);
545:
546: -- Added exception handling code for Bug:5475982
547: BEGIN
548: ZPB_AW.EXECUTE(v_task.token);
549: EXCEPTION
550: WHEN OTHERS THEN
551: fnd_message.set_name('ZPB','ZPB_MNTDATASEC_FAILED');
552:

Line 594: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',

590: retcode := '2';
591: END;
592: end if;
593:
594: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',
595: 'Checking for Read access in accounts_states table for User'||l_user_id);
596:
597: --check this user for read access and update has_read_access flag in zpb_account_states
598: ZPB_SECURITY_UTIL_PVT.validate_user(l_user_id,

Line 615: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',

611: else
612: x_has_read_acc := 0;
613: end if;
614:
615: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',
616: 'Updating accounts_states table has_read_access col for User'||l_user_id);
617: update zpb_account_states
618: set has_read_access = x_has_read_acc
619: where user_id = l_user_id

Line 637: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',

633: errbuf);
634: l_initialized := true;
635: end if;
636:
637: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',
638: 'Updating writeback_tasks table with Status as FAILED for Task Seq: '||task );
639: --set the initial status to failed
640: update zpb_writeback_tasks set
641: status = FAILED, completion_date = SYSDATE,

Line 652: ZPB_AW.EXECUTE(v_task.token);

648: l_user_id := to_number(s_user_id);
649: else
650: l_log_user (v_task.taskseq, v_task.asuser, v_task.asresp,
651: v_task.exorder, v_task.token);
652: ZPB_AW.EXECUTE(v_task.token);
653: end if;
654:
655: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',
656: 'Checking for Read access in accounts_states table for User'||l_user_id);

Line 655: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',

651: v_task.exorder, v_task.token);
652: ZPB_AW.EXECUTE(v_task.token);
653: end if;
654:
655: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',
656: 'Checking for Read access in accounts_states table for User'||l_user_id);
657:
658: --check this user for read access and update has_read_access flag in zpb_account_states
659: ZPB_SECURITY_UTIL_PVT.validate_user(l_user_id,

Line 676: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',

672: else
673: x_has_read_acc := 0;
674: end if;
675:
676: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',
677: 'Updating accounts_states table has_read_access col for User'||l_user_id);
678: update zpb_account_states
679: set has_read_access = x_has_read_acc
680: where user_id = l_user_id

Line 687: ZPB_AW.EXECUTE ('update');

683: end loop;
684: END IF;
685:
686:
687: ZPB_AW.EXECUTE ('update');
688: commit;
689:
690: ZPB_AW.DETACH_ALL;
691:

Line 690: ZPB_AW.DETACH_ALL;

686:
687: ZPB_AW.EXECUTE ('update');
688: commit;
689:
690: ZPB_AW.DETACH_ALL;
691:
692: --update the tasks table
693: -- Added for Bug: 5475982
694: IF p_conc_request_id > 0 THEN

Line 696: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',

692: --update the tasks table
693: -- Added for Bug: 5475982
694: IF p_conc_request_id > 0 THEN
695:
696: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',
697: 'Updating writeback_tasks table with Status as COMPLETED for SessionID: '||p_conc_request_id );
698:
699: UPDATE zpb_writeback_tasks
700: SET status = COMPLETED,

Line 709: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',

705: WHERE session_id = p_conc_request_id;
706:
707: ELSE
708:
709: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',
710: 'Updating writeback_tasks table with Status as COMPLETED for Task Seq: '||task );
711:
712: UPDATE zpb_writeback_tasks
713: SET status = COMPLETED,

Line 733: zpb_log.write ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks','End program :');

729: -- then the retcode is set to '2'.
730:
731: -- RETCODE := '0';
732:
733: zpb_log.write ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks','End program :');
734:
735: EXCEPTION
736: when others then
737: ZPB_ERROR_HANDLER.HANDLE_EXCEPTION (G_PKG_NAME,

Line 742: ZPB_AW.DETACH_ALL;

738: 'process_ownership_tasks');
739: retcode := '2';
740: errNum := SQLCODE;
741: errbuf := sqlerrm(errNum);
742: ZPB_AW.DETACH_ALL;
743:
744: END process_scoping_admin_tasks;
745:
746: ------------------------------------------------------------------------------

Line 801: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Begin program :');

797: into l_user_name
798: from FND_USER
799: where USER_ID = FND_GLOBAL.USER_ID;
800:
801: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Begin program :');
802:
803: INITIALIZE (l_user_name,
804: p_business_area,
805: l_retcode,

Line 808: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Initialization done :');

804: p_business_area,
805: l_retcode,
806: errbuf);
807:
808: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Initialization done :');
809:
810: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Process Read Access');
811: for each in all_readaccess loop
812: l_query_path := each.query_path;

Line 810: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Process Read Access');

806: errbuf);
807:
808: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Initialization done :');
809:
810: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Process Read Access');
811: for each in all_readaccess loop
812: l_query_path := each.query_path;
813: ZPB_AW.EXECUTE('call sc.set.scope('''||l_query_path||''')');
814: end loop;

Line 813: ZPB_AW.EXECUTE('call sc.set.scope('''||l_query_path||''')');

809:
810: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Process Read Access');
811: for each in all_readaccess loop
812: l_query_path := each.query_path;
813: ZPB_AW.EXECUTE('call sc.set.scope('''||l_query_path||''')');
814: end loop;
815:
816: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Process Write Access');
817: for each in all_writeaccess loop

Line 816: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Process Write Access');

812: l_query_path := each.query_path;
813: ZPB_AW.EXECUTE('call sc.set.scope('''||l_query_path||''')');
814: end loop;
815:
816: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Process Write Access');
817: for each in all_writeaccess loop
818: l_query_path := each.query_path;
819: ZPB_AW.EXECUTE('call sc.set.write.acc('''||l_query_path||''')');
820: end loop;

Line 819: ZPB_AW.EXECUTE('call sc.set.write.acc('''||l_query_path||''')');

815:
816: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Process Write Access');
817: for each in all_writeaccess loop
818: l_query_path := each.query_path;
819: ZPB_AW.EXECUTE('call sc.set.write.acc('''||l_query_path||''')');
820: end loop;
821:
822: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Process Ownership Access');
823: for each in all_ownership loop

Line 822: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Process Ownership Access');

818: l_query_path := each.query_path;
819: ZPB_AW.EXECUTE('call sc.set.write.acc('''||l_query_path||''')');
820: end loop;
821:
822: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Process Ownership Access');
823: for each in all_ownership loop
824: l_query_path := each.query_path;
825: ZPB_AW.EXECUTE('call sc.set.ownership('''||l_query_path||''')');
826: end loop;

Line 825: ZPB_AW.EXECUTE('call sc.set.ownership('''||l_query_path||''')');

821:
822: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Process Ownership Access');
823: for each in all_ownership loop
824: l_query_path := each.query_path;
825: ZPB_AW.EXECUTE('call sc.set.ownership('''||l_query_path||''')');
826: end loop;
827:
828: DELETE FROM zpb_validation_temp_data WHERE business_area_id = p_business_area;
829:

Line 830: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Done');

826: end loop;
827:
828: DELETE FROM zpb_validation_temp_data WHERE business_area_id = p_business_area;
829:
830: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Done');
831:
832: ZPB_AW.EXECUTE ('update');
833: commit;
834:

Line 832: ZPB_AW.EXECUTE ('update');

828: DELETE FROM zpb_validation_temp_data WHERE business_area_id = p_business_area;
829:
830: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Done');
831:
832: ZPB_AW.EXECUTE ('update');
833: commit;
834:
835: ZPB_AW.DETACH_ALL;
836: RETCODE := '0';

Line 835: ZPB_AW.DETACH_ALL;

831:
832: ZPB_AW.EXECUTE ('update');
833: commit;
834:
835: ZPB_AW.DETACH_ALL;
836: RETCODE := '0';
837:
838: EXCEPTION
839: WHEN OTHERS THEN

Line 904: ZPB_AW.EXECUTE(each.qdr);

900: LAST_UPDATED_BY = fnd_global.USER_ID, LAST_UPDATE_DATE = SYSDATE,
901: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
902: where task_seq = each.taskseq;
903:
904: ZPB_AW.EXECUTE(each.qdr);
905:
906: if (each.tasktype = UMAINT) then
907: ZPB_AW.EXECUTE('update');
908: commit; --commit changes so zpb_personal_aw.aw_create has visibility to new user

Line 907: ZPB_AW.EXECUTE('update');

903:
904: ZPB_AW.EXECUTE(each.qdr);
905:
906: if (each.tasktype = UMAINT) then
907: ZPB_AW.EXECUTE('update');
908: commit; --commit changes so zpb_personal_aw.aw_create has visibility to new user
909: b_commit := false;
910: l_initialized := false;
911:

Line 919: l_personal_aw_nm := ZPB_AW.GET_PERSONAL_AW (l_user_id);

915:
916: -- Make sure at least one personal AW does not exist before starting daemon
917: -- null test added for 10g only
918: if (not b_start_aw_daemon ) then
919: l_personal_aw_nm := ZPB_AW.GET_PERSONAL_AW (l_user_id);
920: if(l_personal_aw_nm is null) then
921: b_start_aw_daemon := true;
922: else
923: l_personal_aw_nmq := ZPB_AW.GET_SCHEMA || '.' || l_personal_aw_nm;

Line 923: l_personal_aw_nmq := ZPB_AW.GET_SCHEMA || '.' || l_personal_aw_nm;

919: l_personal_aw_nm := ZPB_AW.GET_PERSONAL_AW (l_user_id);
920: if(l_personal_aw_nm is null) then
921: b_start_aw_daemon := true;
922: else
923: l_personal_aw_nmq := ZPB_AW.GET_SCHEMA || '.' || l_personal_aw_nm;
924: if (not zpb_aw.interpbool('shw aw(exists ''' || l_personal_aw_nmq ||''')')) then
925: b_start_aw_daemon := true;
926: end if;
927: end if;

Line 924: if (not zpb_aw.interpbool('shw aw(exists ''' || l_personal_aw_nmq ||''')')) then

920: if(l_personal_aw_nm is null) then
921: b_start_aw_daemon := true;
922: else
923: l_personal_aw_nmq := ZPB_AW.GET_SCHEMA || '.' || l_personal_aw_nm;
924: if (not zpb_aw.interpbool('shw aw(exists ''' || l_personal_aw_nmq ||''')')) then
925: b_start_aw_daemon := true;
926: end if;
927: end if;
928: end if;

Line 934: ZPB_AW.EXECUTE ('update');

930: end if;
931: END LOOP;
932:
933: if (b_commit) then
934: ZPB_AW.EXECUTE ('update');
935: commit;
936: end if;
937:
938: ZPB_AW.DETACH_ALL;

Line 938: ZPB_AW.DETACH_ALL;

934: ZPB_AW.EXECUTE ('update');
935: commit;
936: end if;
937:
938: ZPB_AW.DETACH_ALL;
939:
940: --update the tasks table
941: update zpb_writeback_tasks set
942: status = COMPLETED, completion_date = SYSDATE,

Line 1035: l_personal_aw_nm := ZPB_AW.GET_PERSONAL_AW (l_user_id);

1031: l_user_id := substr(users_rec.qdr, l_start+2, l_end - l_start - 3);
1032:
1033: -- Ensure aw does not exist before launching request
1034: -- null test added for 10g only
1035: l_personal_aw_nm := ZPB_AW.GET_PERSONAL_AW (l_user_id);
1036: if(l_personal_aw_nm is null) then
1037: b_start_aw_cr_daemon := true;
1038: else
1039: l_personal_aw_nmq := ZPB_AW.GET_SCHEMA || '.' || l_personal_aw_nm;

Line 1039: l_personal_aw_nmq := ZPB_AW.GET_SCHEMA || '.' || l_personal_aw_nm;

1035: l_personal_aw_nm := ZPB_AW.GET_PERSONAL_AW (l_user_id);
1036: if(l_personal_aw_nm is null) then
1037: b_start_aw_cr_daemon := true;
1038: else
1039: l_personal_aw_nmq := ZPB_AW.GET_SCHEMA || '.' || l_personal_aw_nm;
1040: if (not zpb_aw.interpbool('shw aw(exists ''' || l_personal_aw_nmq ||''')')) then
1041: b_start_aw_cr_daemon := true;
1042: end if;
1043: end if;

Line 1040: if (not zpb_aw.interpbool('shw aw(exists ''' || l_personal_aw_nmq ||''')')) then

1036: if(l_personal_aw_nm is null) then
1037: b_start_aw_cr_daemon := true;
1038: else
1039: l_personal_aw_nmq := ZPB_AW.GET_SCHEMA || '.' || l_personal_aw_nm;
1040: if (not zpb_aw.interpbool('shw aw(exists ''' || l_personal_aw_nmq ||''')')) then
1041: b_start_aw_cr_daemon := true;
1042: end if;
1043: end if;
1044:

Line 1145: END ZPB_AW_WRITE_BACK;

1141: p_child_request_id := -1;
1142:
1143: END bulk_writeback;
1144:
1145: END ZPB_AW_WRITE_BACK;
1146: