APPS.ZPB_DATA_COLLECTION_UTIL_PVT dependencies on ZPB_AW

Line 20: ZPB_AW.EXECUTE('call DC.DISTRIBUTE(' || TO_CHAR(IN_TEMPLATE_ID) || ', ' || TO_CHAR(IN_FROM_USER_ID) || ', ' || TO_CHAR(IN_TO_USER_ID) || ', ''' || IN_MOVE_DATA_FLAG || ''', ''' || IN_MOVE_TARGET_FLAG || ''', ''' || IN_STRUCT_OR_DATA || ''')' );

16: IN_STRUCT_OR_DATA IN VARCHAR2)
17: IS
18: BEGIN
19:
20: ZPB_AW.EXECUTE('call DC.DISTRIBUTE(' || TO_CHAR(IN_TEMPLATE_ID) || ', ' || TO_CHAR(IN_FROM_USER_ID) || ', ' || TO_CHAR(IN_TO_USER_ID) || ', ''' || IN_MOVE_DATA_FLAG || ''', ''' || IN_MOVE_TARGET_FLAG || ''', ''' || IN_STRUCT_OR_DATA || ''')' );
21:
22: END;
23:
24: PROCEDURE UPDATE_AW_DATA(IN_QDRS IN VARCHAR2)

Line 27: ZPB_AW.EXECUTE('');

23:
24: PROCEDURE UPDATE_AW_DATA(IN_QDRS IN VARCHAR2)
25: IS
26: BEGIN
27: ZPB_AW.EXECUTE('');
28: END;
29:
30: PROCEDURE COMMIT_AW_DATA
31: IS

Line 33: ZPB_AW.EXECUTE('');

29:
30: PROCEDURE COMMIT_AW_DATA
31: IS
32: BEGIN
33: ZPB_AW.EXECUTE('');
34: END;
35:
36:
37: PROCEDURE get_dc_owners(p_object_id IN NUMBER,

Line 97: --ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'running zpb_aw_status.run_olapi_queries(' ||

93:
94: l_query_key := l_query_path || '/' || l_query_name;
95:
96: --set zpb_status_sql_members
97: --ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'running zpb_aw_status.run_olapi_queries(' ||
98: -- l_query_key || ').');
99:
100: --not needed for new cm.setsqlstatus procecure
101: --zpb_aw_status.run_olapi_queries(l_query_key);

Line 101: --zpb_aw_status.run_olapi_queries(l_query_key);

97: --ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'running zpb_aw_status.run_olapi_queries(' ||
98: -- l_query_key || ').');
99:
100: --not needed for new cm.setsqlstatus procecure
101: --zpb_aw_status.run_olapi_queries(l_query_key);
102:
103: --run the ownership query
104: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'running sc.get.dstr.own');
105:

Line 106: l_stat_len := zpb_aw.interp('shw sc.get.dstr.own(''' || to_char(p_object_id) || ''', ''' ||

102:
103: --run the ownership query
104: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'running sc.get.dstr.own');
105:
106: l_stat_len := zpb_aw.interp('shw sc.get.dstr.own(''' || to_char(p_object_id) || ''', ''' ||
107: to_char(p_user_id) || ''', ''' || p_query_type || ''')');
108:
109: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'sc.get.dstr.own found ' || l_stat_len || ' owners.');
110:

Line 115: l_owners := zpb_aw.interp('shw joinchars(joincols(values(secuser), '' ''))');

111: --dbms_output.put_line('Stat Length = ' || l_stat_len);
112:
113: l_length := to_number(l_stat_len);
114: if (l_length > 0) then
115: l_owners := zpb_aw.interp('shw joinchars(joincols(values(secuser), '' ''))');
116: --dbms_output.put_line(l_owners);
117: l_owners := substr(l_owners, 1, length(l_owners) - 1);
118: i := 1;
119: loop