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.HZ_PURGE dependencies on HZ_GEN_PLSQL

Line 68: HZ_GEN_PLSQL.new('HZ_PURGE_GEN', 'PACKAGE BODY');

64:
65: -- initialize API return status to success.
66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67: /* Beginnig of the dynamic package generation*/
68: HZ_GEN_PLSQL.new('HZ_PURGE_GEN', 'PACKAGE BODY');
69: HZ_GEN_PLSQL.add_line('CREATE OR REPLACE PACKAGE BODY HZ_PURGE_GEN AS');
70: HZ_GEN_PLSQL.add_line('PROCEDURE IDENTIFY_CANDIDATES(p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
71: x_return_status OUT NOCOPY VARCHAR2,
72: x_msg_count OUT NOCOPY NUMBER,

Line 69: HZ_GEN_PLSQL.add_line('CREATE OR REPLACE PACKAGE BODY HZ_PURGE_GEN AS');

65: -- initialize API return status to success.
66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67: /* Beginnig of the dynamic package generation*/
68: HZ_GEN_PLSQL.new('HZ_PURGE_GEN', 'PACKAGE BODY');
69: HZ_GEN_PLSQL.add_line('CREATE OR REPLACE PACKAGE BODY HZ_PURGE_GEN AS');
70: HZ_GEN_PLSQL.add_line('PROCEDURE IDENTIFY_CANDIDATES(p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
71: x_return_status OUT NOCOPY VARCHAR2,
72: x_msg_count OUT NOCOPY NUMBER,
73: x_msg_data OUT NOCOPY VARCHAR2,

Line 70: HZ_GEN_PLSQL.add_line('PROCEDURE IDENTIFY_CANDIDATES(p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67: /* Beginnig of the dynamic package generation*/
68: HZ_GEN_PLSQL.new('HZ_PURGE_GEN', 'PACKAGE BODY');
69: HZ_GEN_PLSQL.add_line('CREATE OR REPLACE PACKAGE BODY HZ_PURGE_GEN AS');
70: HZ_GEN_PLSQL.add_line('PROCEDURE IDENTIFY_CANDIDATES(p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
71: x_return_status OUT NOCOPY VARCHAR2,
72: x_msg_count OUT NOCOPY NUMBER,
73: x_msg_data OUT NOCOPY VARCHAR2,
74: check_flag boolean, con_prg boolean, regid_proc boolean) IS');

Line 75: HZ_GEN_PLSQL.add_line('appid number;');

71: x_return_status OUT NOCOPY VARCHAR2,
72: x_msg_count OUT NOCOPY NUMBER,
73: x_msg_data OUT NOCOPY VARCHAR2,
74: check_flag boolean, con_prg boolean, regid_proc boolean) IS');
75: HZ_GEN_PLSQL.add_line('appid number;');
76: HZ_GEN_PLSQL.add_line('sql_count number;');
77: HZ_GEN_PLSQL.add_line('total_parties number;');
78: HZ_GEN_PLSQL.add_line('parties_count1 number;');
79: HZ_GEN_PLSQL.add_line('parties_count2 number;');

Line 76: HZ_GEN_PLSQL.add_line('sql_count number;');

72: x_msg_count OUT NOCOPY NUMBER,
73: x_msg_data OUT NOCOPY VARCHAR2,
74: check_flag boolean, con_prg boolean, regid_proc boolean) IS');
75: HZ_GEN_PLSQL.add_line('appid number;');
76: HZ_GEN_PLSQL.add_line('sql_count number;');
77: HZ_GEN_PLSQL.add_line('total_parties number;');
78: HZ_GEN_PLSQL.add_line('parties_count1 number;');
79: HZ_GEN_PLSQL.add_line('parties_count2 number;');
80: HZ_GEN_PLSQL.add_line('single_party number;');

Line 77: HZ_GEN_PLSQL.add_line('total_parties number;');

73: x_msg_data OUT NOCOPY VARCHAR2,
74: check_flag boolean, con_prg boolean, regid_proc boolean) IS');
75: HZ_GEN_PLSQL.add_line('appid number;');
76: HZ_GEN_PLSQL.add_line('sql_count number;');
77: HZ_GEN_PLSQL.add_line('total_parties number;');
78: HZ_GEN_PLSQL.add_line('parties_count1 number;');
79: HZ_GEN_PLSQL.add_line('parties_count2 number;');
80: HZ_GEN_PLSQL.add_line('single_party number;');
81: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));

Line 78: HZ_GEN_PLSQL.add_line('parties_count1 number;');

74: check_flag boolean, con_prg boolean, regid_proc boolean) IS');
75: HZ_GEN_PLSQL.add_line('appid number;');
76: HZ_GEN_PLSQL.add_line('sql_count number;');
77: HZ_GEN_PLSQL.add_line('total_parties number;');
78: HZ_GEN_PLSQL.add_line('parties_count1 number;');
79: HZ_GEN_PLSQL.add_line('parties_count2 number;');
80: HZ_GEN_PLSQL.add_line('single_party number;');
81: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));
82: HZ_GEN_PLSQL.ADD_LINE('cursor repopulate is');

Line 79: HZ_GEN_PLSQL.add_line('parties_count2 number;');

75: HZ_GEN_PLSQL.add_line('appid number;');
76: HZ_GEN_PLSQL.add_line('sql_count number;');
77: HZ_GEN_PLSQL.add_line('total_parties number;');
78: HZ_GEN_PLSQL.add_line('parties_count1 number;');
79: HZ_GEN_PLSQL.add_line('parties_count2 number;');
80: HZ_GEN_PLSQL.add_line('single_party number;');
81: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));
82: HZ_GEN_PLSQL.ADD_LINE('cursor repopulate is');
83: HZ_GEN_PLSQL.ADD_LINE('select party_id from hz_purge_gt;');

Line 80: HZ_GEN_PLSQL.add_line('single_party number;');

76: HZ_GEN_PLSQL.add_line('sql_count number;');
77: HZ_GEN_PLSQL.add_line('total_parties number;');
78: HZ_GEN_PLSQL.add_line('parties_count1 number;');
79: HZ_GEN_PLSQL.add_line('parties_count2 number;');
80: HZ_GEN_PLSQL.add_line('single_party number;');
81: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));
82: HZ_GEN_PLSQL.ADD_LINE('cursor repopulate is');
83: HZ_GEN_PLSQL.ADD_LINE('select party_id from hz_purge_gt;');
84: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));

Line 81: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));

77: HZ_GEN_PLSQL.add_line('total_parties number;');
78: HZ_GEN_PLSQL.add_line('parties_count1 number;');
79: HZ_GEN_PLSQL.add_line('parties_count2 number;');
80: HZ_GEN_PLSQL.add_line('single_party number;');
81: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));
82: HZ_GEN_PLSQL.ADD_LINE('cursor repopulate is');
83: HZ_GEN_PLSQL.ADD_LINE('select party_id from hz_purge_gt;');
84: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));
85: HZ_GEN_PLSQL.add_line('BEGIN');

Line 82: HZ_GEN_PLSQL.ADD_LINE('cursor repopulate is');

78: HZ_GEN_PLSQL.add_line('parties_count1 number;');
79: HZ_GEN_PLSQL.add_line('parties_count2 number;');
80: HZ_GEN_PLSQL.add_line('single_party number;');
81: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));
82: HZ_GEN_PLSQL.ADD_LINE('cursor repopulate is');
83: HZ_GEN_PLSQL.ADD_LINE('select party_id from hz_purge_gt;');
84: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));
85: HZ_GEN_PLSQL.add_line('BEGIN');
86: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));

Line 83: HZ_GEN_PLSQL.ADD_LINE('select party_id from hz_purge_gt;');

79: HZ_GEN_PLSQL.add_line('parties_count2 number;');
80: HZ_GEN_PLSQL.add_line('single_party number;');
81: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));
82: HZ_GEN_PLSQL.ADD_LINE('cursor repopulate is');
83: HZ_GEN_PLSQL.ADD_LINE('select party_id from hz_purge_gt;');
84: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));
85: HZ_GEN_PLSQL.add_line('BEGIN');
86: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));
87: HZ_GEN_PLSQL.add_line('SAVEPOINT identify_candidates;');

Line 84: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));

80: HZ_GEN_PLSQL.add_line('single_party number;');
81: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));
82: HZ_GEN_PLSQL.ADD_LINE('cursor repopulate is');
83: HZ_GEN_PLSQL.ADD_LINE('select party_id from hz_purge_gt;');
84: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));
85: HZ_GEN_PLSQL.add_line('BEGIN');
86: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));
87: HZ_GEN_PLSQL.add_line('SAVEPOINT identify_candidates;');
88:

Line 85: HZ_GEN_PLSQL.add_line('BEGIN');

81: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));
82: HZ_GEN_PLSQL.ADD_LINE('cursor repopulate is');
83: HZ_GEN_PLSQL.ADD_LINE('select party_id from hz_purge_gt;');
84: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));
85: HZ_GEN_PLSQL.add_line('BEGIN');
86: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));
87: HZ_GEN_PLSQL.add_line('SAVEPOINT identify_candidates;');
88:
89: -- initialize message list if p_init_msg_list is set to TRUE.

Line 86: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));

82: HZ_GEN_PLSQL.ADD_LINE('cursor repopulate is');
83: HZ_GEN_PLSQL.ADD_LINE('select party_id from hz_purge_gt;');
84: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));
85: HZ_GEN_PLSQL.add_line('BEGIN');
86: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));
87: HZ_GEN_PLSQL.add_line('SAVEPOINT identify_candidates;');
88:
89: -- initialize message list if p_init_msg_list is set to TRUE.
90: HZ_GEN_PLSQL.add_line('IF FND_API.to_Boolean(p_init_msg_list) THEN');

Line 87: HZ_GEN_PLSQL.add_line('SAVEPOINT identify_candidates;');

83: HZ_GEN_PLSQL.ADD_LINE('select party_id from hz_purge_gt;');
84: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));
85: HZ_GEN_PLSQL.add_line('BEGIN');
86: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));
87: HZ_GEN_PLSQL.add_line('SAVEPOINT identify_candidates;');
88:
89: -- initialize message list if p_init_msg_list is set to TRUE.
90: HZ_GEN_PLSQL.add_line('IF FND_API.to_Boolean(p_init_msg_list) THEN');
91: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.initialize;');

Line 90: HZ_GEN_PLSQL.add_line('IF FND_API.to_Boolean(p_init_msg_list) THEN');

86: HZ_GEN_PLSQL.add_line(fnd_global.local_chr(10));
87: HZ_GEN_PLSQL.add_line('SAVEPOINT identify_candidates;');
88:
89: -- initialize message list if p_init_msg_list is set to TRUE.
90: HZ_GEN_PLSQL.add_line('IF FND_API.to_Boolean(p_init_msg_list) THEN');
91: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.initialize;');
92: HZ_GEN_PLSQL.add_line('END IF;');
93:
94: -- initialize API return status to success.

Line 91: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.initialize;');

87: HZ_GEN_PLSQL.add_line('SAVEPOINT identify_candidates;');
88:
89: -- initialize message list if p_init_msg_list is set to TRUE.
90: HZ_GEN_PLSQL.add_line('IF FND_API.to_Boolean(p_init_msg_list) THEN');
91: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.initialize;');
92: HZ_GEN_PLSQL.add_line('END IF;');
93:
94: -- initialize API return status to success.
95: HZ_GEN_PLSQL.add_line('x_return_status := FND_API.G_RET_STS_SUCCESS;');

Line 92: HZ_GEN_PLSQL.add_line('END IF;');

88:
89: -- initialize message list if p_init_msg_list is set to TRUE.
90: HZ_GEN_PLSQL.add_line('IF FND_API.to_Boolean(p_init_msg_list) THEN');
91: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.initialize;');
92: HZ_GEN_PLSQL.add_line('END IF;');
93:
94: -- initialize API return status to success.
95: HZ_GEN_PLSQL.add_line('x_return_status := FND_API.G_RET_STS_SUCCESS;');
96: HZ_GEN_PLSQL.add_line('delete from hz_application_trans_gt; ');

Line 95: HZ_GEN_PLSQL.add_line('x_return_status := FND_API.G_RET_STS_SUCCESS;');

91: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.initialize;');
92: HZ_GEN_PLSQL.add_line('END IF;');
93:
94: -- initialize API return status to success.
95: HZ_GEN_PLSQL.add_line('x_return_status := FND_API.G_RET_STS_SUCCESS;');
96: HZ_GEN_PLSQL.add_line('delete from hz_application_trans_gt; ');
97: HZ_GEN_PLSQL.add_line('open repopulate;');
98: HZ_GEN_PLSQL.add_line('fetch repopulate into single_party;');
99: HZ_GEN_PLSQL.add_line('close repopulate;');

Line 96: HZ_GEN_PLSQL.add_line('delete from hz_application_trans_gt; ');

92: HZ_GEN_PLSQL.add_line('END IF;');
93:
94: -- initialize API return status to success.
95: HZ_GEN_PLSQL.add_line('x_return_status := FND_API.G_RET_STS_SUCCESS;');
96: HZ_GEN_PLSQL.add_line('delete from hz_application_trans_gt; ');
97: HZ_GEN_PLSQL.add_line('open repopulate;');
98: HZ_GEN_PLSQL.add_line('fetch repopulate into single_party;');
99: HZ_GEN_PLSQL.add_line('close repopulate;');
100: populate_fk_datatype;

Line 97: HZ_GEN_PLSQL.add_line('open repopulate;');

93:
94: -- initialize API return status to success.
95: HZ_GEN_PLSQL.add_line('x_return_status := FND_API.G_RET_STS_SUCCESS;');
96: HZ_GEN_PLSQL.add_line('delete from hz_application_trans_gt; ');
97: HZ_GEN_PLSQL.add_line('open repopulate;');
98: HZ_GEN_PLSQL.add_line('fetch repopulate into single_party;');
99: HZ_GEN_PLSQL.add_line('close repopulate;');
100: populate_fk_datatype;
101: -- open cursor to get each application id

Line 98: HZ_GEN_PLSQL.add_line('fetch repopulate into single_party;');

94: -- initialize API return status to success.
95: HZ_GEN_PLSQL.add_line('x_return_status := FND_API.G_RET_STS_SUCCESS;');
96: HZ_GEN_PLSQL.add_line('delete from hz_application_trans_gt; ');
97: HZ_GEN_PLSQL.add_line('open repopulate;');
98: HZ_GEN_PLSQL.add_line('fetch repopulate into single_party;');
99: HZ_GEN_PLSQL.add_line('close repopulate;');
100: populate_fk_datatype;
101: -- open cursor to get each application id
102: OPEN app_id;

Line 99: HZ_GEN_PLSQL.add_line('close repopulate;');

95: HZ_GEN_PLSQL.add_line('x_return_status := FND_API.G_RET_STS_SUCCESS;');
96: HZ_GEN_PLSQL.add_line('delete from hz_application_trans_gt; ');
97: HZ_GEN_PLSQL.add_line('open repopulate;');
98: HZ_GEN_PLSQL.add_line('fetch repopulate into single_party;');
99: HZ_GEN_PLSQL.add_line('close repopulate;');
100: populate_fk_datatype;
101: -- open cursor to get each application id
102: OPEN app_id;
103: LOOP

Line 150: HZ_GEN_PLSQL.ADD_LINE('--delete and insert records into hz_purge_gt for an application');

146: end if;
147:
148: if (s1 is not null) then
149: stmt1:= stmt1||fnd_global.local_chr(10)||s1;
150: HZ_GEN_PLSQL.ADD_LINE('--delete and insert records into hz_purge_gt for an application');
151: HZ_GEN_PLSQL.ADD_LINE('appid:='||appid||';');
152: stmt3:= 'insert into hz_application_trans_gt(app_id,party_id) select '||appid||', temp.party_id from hz_purge_gt temp where ';
153: HZ_GEN_PLSQL.ADD_LINE(' if(regid_proc = true) then ');
154: HZ_GEN_PLSQL.ADD_LINE(stmt3||fnd_global.local_chr(10)||s1||';');

Line 151: HZ_GEN_PLSQL.ADD_LINE('appid:='||appid||';');

147:
148: if (s1 is not null) then
149: stmt1:= stmt1||fnd_global.local_chr(10)||s1;
150: HZ_GEN_PLSQL.ADD_LINE('--delete and insert records into hz_purge_gt for an application');
151: HZ_GEN_PLSQL.ADD_LINE('appid:='||appid||';');
152: stmt3:= 'insert into hz_application_trans_gt(app_id,party_id) select '||appid||', temp.party_id from hz_purge_gt temp where ';
153: HZ_GEN_PLSQL.ADD_LINE(' if(regid_proc = true) then ');
154: HZ_GEN_PLSQL.ADD_LINE(stmt3||fnd_global.local_chr(10)||s1||';');
155: HZ_GEN_PLSQL.ADD_LINE(' else ');

Line 153: HZ_GEN_PLSQL.ADD_LINE(' if(regid_proc = true) then ');

149: stmt1:= stmt1||fnd_global.local_chr(10)||s1;
150: HZ_GEN_PLSQL.ADD_LINE('--delete and insert records into hz_purge_gt for an application');
151: HZ_GEN_PLSQL.ADD_LINE('appid:='||appid||';');
152: stmt3:= 'insert into hz_application_trans_gt(app_id,party_id) select '||appid||', temp.party_id from hz_purge_gt temp where ';
153: HZ_GEN_PLSQL.ADD_LINE(' if(regid_proc = true) then ');
154: HZ_GEN_PLSQL.ADD_LINE(stmt3||fnd_global.local_chr(10)||s1||';');
155: HZ_GEN_PLSQL.ADD_LINE(' else ');
156: HZ_GEN_PLSQL.ADD_LINE(stmt1||';');
157: HZ_GEN_PLSQL.ADD_LINE('end if;');

Line 154: HZ_GEN_PLSQL.ADD_LINE(stmt3||fnd_global.local_chr(10)||s1||';');

150: HZ_GEN_PLSQL.ADD_LINE('--delete and insert records into hz_purge_gt for an application');
151: HZ_GEN_PLSQL.ADD_LINE('appid:='||appid||';');
152: stmt3:= 'insert into hz_application_trans_gt(app_id,party_id) select '||appid||', temp.party_id from hz_purge_gt temp where ';
153: HZ_GEN_PLSQL.ADD_LINE(' if(regid_proc = true) then ');
154: HZ_GEN_PLSQL.ADD_LINE(stmt3||fnd_global.local_chr(10)||s1||';');
155: HZ_GEN_PLSQL.ADD_LINE(' else ');
156: HZ_GEN_PLSQL.ADD_LINE(stmt1||';');
157: HZ_GEN_PLSQL.ADD_LINE('end if;');
158:

Line 155: HZ_GEN_PLSQL.ADD_LINE(' else ');

151: HZ_GEN_PLSQL.ADD_LINE('appid:='||appid||';');
152: stmt3:= 'insert into hz_application_trans_gt(app_id,party_id) select '||appid||', temp.party_id from hz_purge_gt temp where ';
153: HZ_GEN_PLSQL.ADD_LINE(' if(regid_proc = true) then ');
154: HZ_GEN_PLSQL.ADD_LINE(stmt3||fnd_global.local_chr(10)||s1||';');
155: HZ_GEN_PLSQL.ADD_LINE(' else ');
156: HZ_GEN_PLSQL.ADD_LINE(stmt1||';');
157: HZ_GEN_PLSQL.ADD_LINE('end if;');
158:
159: --HZ_GEN_PLSQL.ADD_LINE('HZ_PURGE.post_app_logic(appid,single_party,check_flag);');

Line 156: HZ_GEN_PLSQL.ADD_LINE(stmt1||';');

152: stmt3:= 'insert into hz_application_trans_gt(app_id,party_id) select '||appid||', temp.party_id from hz_purge_gt temp where ';
153: HZ_GEN_PLSQL.ADD_LINE(' if(regid_proc = true) then ');
154: HZ_GEN_PLSQL.ADD_LINE(stmt3||fnd_global.local_chr(10)||s1||';');
155: HZ_GEN_PLSQL.ADD_LINE(' else ');
156: HZ_GEN_PLSQL.ADD_LINE(stmt1||';');
157: HZ_GEN_PLSQL.ADD_LINE('end if;');
158:
159: --HZ_GEN_PLSQL.ADD_LINE('HZ_PURGE.post_app_logic(appid,single_party,check_flag);');
160: HZ_GEN_PLSQL.ADD_LINE(fnd_global.local_chr(10));

Line 157: HZ_GEN_PLSQL.ADD_LINE('end if;');

153: HZ_GEN_PLSQL.ADD_LINE(' if(regid_proc = true) then ');
154: HZ_GEN_PLSQL.ADD_LINE(stmt3||fnd_global.local_chr(10)||s1||';');
155: HZ_GEN_PLSQL.ADD_LINE(' else ');
156: HZ_GEN_PLSQL.ADD_LINE(stmt1||';');
157: HZ_GEN_PLSQL.ADD_LINE('end if;');
158:
159: --HZ_GEN_PLSQL.ADD_LINE('HZ_PURGE.post_app_logic(appid,single_party,check_flag);');
160: HZ_GEN_PLSQL.ADD_LINE(fnd_global.local_chr(10));
161: end if;

Line 159: --HZ_GEN_PLSQL.ADD_LINE('HZ_PURGE.post_app_logic(appid,single_party,check_flag);');

155: HZ_GEN_PLSQL.ADD_LINE(' else ');
156: HZ_GEN_PLSQL.ADD_LINE(stmt1||';');
157: HZ_GEN_PLSQL.ADD_LINE('end if;');
158:
159: --HZ_GEN_PLSQL.ADD_LINE('HZ_PURGE.post_app_logic(appid,single_party,check_flag);');
160: HZ_GEN_PLSQL.ADD_LINE(fnd_global.local_chr(10));
161: end if;
162: id := 1;
163: s1 := null;

Line 160: HZ_GEN_PLSQL.ADD_LINE(fnd_global.local_chr(10));

156: HZ_GEN_PLSQL.ADD_LINE(stmt1||';');
157: HZ_GEN_PLSQL.ADD_LINE('end if;');
158:
159: --HZ_GEN_PLSQL.ADD_LINE('HZ_PURGE.post_app_logic(appid,single_party,check_flag);');
160: HZ_GEN_PLSQL.ADD_LINE(fnd_global.local_chr(10));
161: end if;
162: id := 1;
163: s1 := null;
164: stmt1 := 'delete from hz_purge_gt temp where ';

Line 186: HZ_GEN_PLSQL.add_line('--'||e1||';'||fk1);

182: --dbms_output.put_line('non indexed entity='||e1||',column='||fk1||'parent='||pe1);
183: cnt :=1;
184: delete_template(e1, fk1, pk1, j1, pe1, fk_data_typ1,'FALSE', s2,cnt);
185: if(s2 is not NULL) then
186: HZ_GEN_PLSQL.add_line('--'||e1||';'||fk1);
187: stmt4 := 'insert into hz_application_trans_gt(app_id,party_id) select '||appid||', temp.party_id from hz_purge_gt temp ';
188: stmt5 := ' where not exists(select ''Y'' from hz_application_trans_gt appl where appl.app_id = '||appid||' and appl.party_id=temp.party_id) and ';
189: HZ_GEN_PLSQL.ADD_LINE('appid:='||appid||';');
190: --HZ_GEN_PLSQL.ADD_LINE('HZ_PURGE.post_app_logic(appid,single_party,check_flag);');

Line 189: HZ_GEN_PLSQL.ADD_LINE('appid:='||appid||';');

185: if(s2 is not NULL) then
186: HZ_GEN_PLSQL.add_line('--'||e1||';'||fk1);
187: stmt4 := 'insert into hz_application_trans_gt(app_id,party_id) select '||appid||', temp.party_id from hz_purge_gt temp ';
188: stmt5 := ' where not exists(select ''Y'' from hz_application_trans_gt appl where appl.app_id = '||appid||' and appl.party_id=temp.party_id) and ';
189: HZ_GEN_PLSQL.ADD_LINE('appid:='||appid||';');
190: --HZ_GEN_PLSQL.ADD_LINE('HZ_PURGE.post_app_logic(appid,single_party,check_flag);');
191: HZ_GEN_PLSQL.ADD_LINE(' if(regid_proc = true) then ');
192: HZ_GEN_PLSQL.ADD_LINE(stmt4||stmt5||fnd_global.local_chr(10)||s2||';');
193: HZ_GEN_PLSQL.ADD_LINE(' else ');

Line 190: --HZ_GEN_PLSQL.ADD_LINE('HZ_PURGE.post_app_logic(appid,single_party,check_flag);');

186: HZ_GEN_PLSQL.add_line('--'||e1||';'||fk1);
187: stmt4 := 'insert into hz_application_trans_gt(app_id,party_id) select '||appid||', temp.party_id from hz_purge_gt temp ';
188: stmt5 := ' where not exists(select ''Y'' from hz_application_trans_gt appl where appl.app_id = '||appid||' and appl.party_id=temp.party_id) and ';
189: HZ_GEN_PLSQL.ADD_LINE('appid:='||appid||';');
190: --HZ_GEN_PLSQL.ADD_LINE('HZ_PURGE.post_app_logic(appid,single_party,check_flag);');
191: HZ_GEN_PLSQL.ADD_LINE(' if(regid_proc = true) then ');
192: HZ_GEN_PLSQL.ADD_LINE(stmt4||stmt5||fnd_global.local_chr(10)||s2||';');
193: HZ_GEN_PLSQL.ADD_LINE(' else ');
194: HZ_GEN_PLSQL.add_line(stmt2||s2||';');

Line 191: HZ_GEN_PLSQL.ADD_LINE(' if(regid_proc = true) then ');

187: stmt4 := 'insert into hz_application_trans_gt(app_id,party_id) select '||appid||', temp.party_id from hz_purge_gt temp ';
188: stmt5 := ' where not exists(select ''Y'' from hz_application_trans_gt appl where appl.app_id = '||appid||' and appl.party_id=temp.party_id) and ';
189: HZ_GEN_PLSQL.ADD_LINE('appid:='||appid||';');
190: --HZ_GEN_PLSQL.ADD_LINE('HZ_PURGE.post_app_logic(appid,single_party,check_flag);');
191: HZ_GEN_PLSQL.ADD_LINE(' if(regid_proc = true) then ');
192: HZ_GEN_PLSQL.ADD_LINE(stmt4||stmt5||fnd_global.local_chr(10)||s2||';');
193: HZ_GEN_PLSQL.ADD_LINE(' else ');
194: HZ_GEN_PLSQL.add_line(stmt2||s2||';');
195: HZ_GEN_PLSQL.ADD_LINE('end if;');

Line 192: HZ_GEN_PLSQL.ADD_LINE(stmt4||stmt5||fnd_global.local_chr(10)||s2||';');

188: stmt5 := ' where not exists(select ''Y'' from hz_application_trans_gt appl where appl.app_id = '||appid||' and appl.party_id=temp.party_id) and ';
189: HZ_GEN_PLSQL.ADD_LINE('appid:='||appid||';');
190: --HZ_GEN_PLSQL.ADD_LINE('HZ_PURGE.post_app_logic(appid,single_party,check_flag);');
191: HZ_GEN_PLSQL.ADD_LINE(' if(regid_proc = true) then ');
192: HZ_GEN_PLSQL.ADD_LINE(stmt4||stmt5||fnd_global.local_chr(10)||s2||';');
193: HZ_GEN_PLSQL.ADD_LINE(' else ');
194: HZ_GEN_PLSQL.add_line(stmt2||s2||';');
195: HZ_GEN_PLSQL.ADD_LINE('end if;');
196:

Line 193: HZ_GEN_PLSQL.ADD_LINE(' else ');

189: HZ_GEN_PLSQL.ADD_LINE('appid:='||appid||';');
190: --HZ_GEN_PLSQL.ADD_LINE('HZ_PURGE.post_app_logic(appid,single_party,check_flag);');
191: HZ_GEN_PLSQL.ADD_LINE(' if(regid_proc = true) then ');
192: HZ_GEN_PLSQL.ADD_LINE(stmt4||stmt5||fnd_global.local_chr(10)||s2||';');
193: HZ_GEN_PLSQL.ADD_LINE(' else ');
194: HZ_GEN_PLSQL.add_line(stmt2||s2||';');
195: HZ_GEN_PLSQL.ADD_LINE('end if;');
196:
197: end if;

Line 194: HZ_GEN_PLSQL.add_line(stmt2||s2||';');

190: --HZ_GEN_PLSQL.ADD_LINE('HZ_PURGE.post_app_logic(appid,single_party,check_flag);');
191: HZ_GEN_PLSQL.ADD_LINE(' if(regid_proc = true) then ');
192: HZ_GEN_PLSQL.ADD_LINE(stmt4||stmt5||fnd_global.local_chr(10)||s2||';');
193: HZ_GEN_PLSQL.ADD_LINE(' else ');
194: HZ_GEN_PLSQL.add_line(stmt2||s2||';');
195: HZ_GEN_PLSQL.ADD_LINE('end if;');
196:
197: end if;
198: end if;

Line 195: HZ_GEN_PLSQL.ADD_LINE('end if;');

191: HZ_GEN_PLSQL.ADD_LINE(' if(regid_proc = true) then ');
192: HZ_GEN_PLSQL.ADD_LINE(stmt4||stmt5||fnd_global.local_chr(10)||s2||';');
193: HZ_GEN_PLSQL.ADD_LINE(' else ');
194: HZ_GEN_PLSQL.add_line(stmt2||s2||';');
195: HZ_GEN_PLSQL.ADD_LINE('end if;');
196:
197: end if;
198: end if;
199: end loop;

Line 204: HZ_GEN_PLSQL.ADD_LINE(' if(regid_proc = true) then ');

200: close x1;
201: end if;
202: END LOOP;
203: CLOSE app_id;
204: HZ_GEN_PLSQL.ADD_LINE(' if(regid_proc = true) then ');
205: HZ_GEN_PLSQL.ADD_LINE('delete from hz_purge_gt temp where temp.party_id in (select appl.party_id from hz_application_trans_gt appl) ;');
206: HZ_GEN_PLSQL.ADD_LINE('end if;');
207: HZ_GEN_PLSQL.ADD_LINE(fnd_global.local_chr(10));
208: HZ_GEN_PLSQL.add_line('EXCEPTION');

Line 205: HZ_GEN_PLSQL.ADD_LINE('delete from hz_purge_gt temp where temp.party_id in (select appl.party_id from hz_application_trans_gt appl) ;');

201: end if;
202: END LOOP;
203: CLOSE app_id;
204: HZ_GEN_PLSQL.ADD_LINE(' if(regid_proc = true) then ');
205: HZ_GEN_PLSQL.ADD_LINE('delete from hz_purge_gt temp where temp.party_id in (select appl.party_id from hz_application_trans_gt appl) ;');
206: HZ_GEN_PLSQL.ADD_LINE('end if;');
207: HZ_GEN_PLSQL.ADD_LINE(fnd_global.local_chr(10));
208: HZ_GEN_PLSQL.add_line('EXCEPTION');
209: HZ_GEN_PLSQL.add_line('WHEN OTHERS THEN');

Line 206: HZ_GEN_PLSQL.ADD_LINE('end if;');

202: END LOOP;
203: CLOSE app_id;
204: HZ_GEN_PLSQL.ADD_LINE(' if(regid_proc = true) then ');
205: HZ_GEN_PLSQL.ADD_LINE('delete from hz_purge_gt temp where temp.party_id in (select appl.party_id from hz_application_trans_gt appl) ;');
206: HZ_GEN_PLSQL.ADD_LINE('end if;');
207: HZ_GEN_PLSQL.ADD_LINE(fnd_global.local_chr(10));
208: HZ_GEN_PLSQL.add_line('EXCEPTION');
209: HZ_GEN_PLSQL.add_line('WHEN OTHERS THEN');
210: HZ_GEN_PLSQL.add_line('ROLLBACK to identify_candidates;');

Line 207: HZ_GEN_PLSQL.ADD_LINE(fnd_global.local_chr(10));

203: CLOSE app_id;
204: HZ_GEN_PLSQL.ADD_LINE(' if(regid_proc = true) then ');
205: HZ_GEN_PLSQL.ADD_LINE('delete from hz_purge_gt temp where temp.party_id in (select appl.party_id from hz_application_trans_gt appl) ;');
206: HZ_GEN_PLSQL.ADD_LINE('end if;');
207: HZ_GEN_PLSQL.ADD_LINE(fnd_global.local_chr(10));
208: HZ_GEN_PLSQL.add_line('EXCEPTION');
209: HZ_GEN_PLSQL.add_line('WHEN OTHERS THEN');
210: HZ_GEN_PLSQL.add_line('ROLLBACK to identify_candidates;');
211: HZ_GEN_PLSQL.add_line('x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');

Line 208: HZ_GEN_PLSQL.add_line('EXCEPTION');

204: HZ_GEN_PLSQL.ADD_LINE(' if(regid_proc = true) then ');
205: HZ_GEN_PLSQL.ADD_LINE('delete from hz_purge_gt temp where temp.party_id in (select appl.party_id from hz_application_trans_gt appl) ;');
206: HZ_GEN_PLSQL.ADD_LINE('end if;');
207: HZ_GEN_PLSQL.ADD_LINE(fnd_global.local_chr(10));
208: HZ_GEN_PLSQL.add_line('EXCEPTION');
209: HZ_GEN_PLSQL.add_line('WHEN OTHERS THEN');
210: HZ_GEN_PLSQL.add_line('ROLLBACK to identify_candidates;');
211: HZ_GEN_PLSQL.add_line('x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
212: HZ_GEN_PLSQL.add_line('FND_MESSAGE.SET_NAME( ''AR'', ''HZ_API_OTHERS_EXCEP'' );');

Line 209: HZ_GEN_PLSQL.add_line('WHEN OTHERS THEN');

205: HZ_GEN_PLSQL.ADD_LINE('delete from hz_purge_gt temp where temp.party_id in (select appl.party_id from hz_application_trans_gt appl) ;');
206: HZ_GEN_PLSQL.ADD_LINE('end if;');
207: HZ_GEN_PLSQL.ADD_LINE(fnd_global.local_chr(10));
208: HZ_GEN_PLSQL.add_line('EXCEPTION');
209: HZ_GEN_PLSQL.add_line('WHEN OTHERS THEN');
210: HZ_GEN_PLSQL.add_line('ROLLBACK to identify_candidates;');
211: HZ_GEN_PLSQL.add_line('x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
212: HZ_GEN_PLSQL.add_line('FND_MESSAGE.SET_NAME( ''AR'', ''HZ_API_OTHERS_EXCEP'' );');
213: HZ_GEN_PLSQL.add_line('FND_MESSAGE.SET_TOKEN( ''ERROR'' ,SQLERRM );');

Line 210: HZ_GEN_PLSQL.add_line('ROLLBACK to identify_candidates;');

206: HZ_GEN_PLSQL.ADD_LINE('end if;');
207: HZ_GEN_PLSQL.ADD_LINE(fnd_global.local_chr(10));
208: HZ_GEN_PLSQL.add_line('EXCEPTION');
209: HZ_GEN_PLSQL.add_line('WHEN OTHERS THEN');
210: HZ_GEN_PLSQL.add_line('ROLLBACK to identify_candidates;');
211: HZ_GEN_PLSQL.add_line('x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
212: HZ_GEN_PLSQL.add_line('FND_MESSAGE.SET_NAME( ''AR'', ''HZ_API_OTHERS_EXCEP'' );');
213: HZ_GEN_PLSQL.add_line('FND_MESSAGE.SET_TOKEN( ''ERROR'' ,SQLERRM );');
214: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.ADD;');

Line 211: HZ_GEN_PLSQL.add_line('x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');

207: HZ_GEN_PLSQL.ADD_LINE(fnd_global.local_chr(10));
208: HZ_GEN_PLSQL.add_line('EXCEPTION');
209: HZ_GEN_PLSQL.add_line('WHEN OTHERS THEN');
210: HZ_GEN_PLSQL.add_line('ROLLBACK to identify_candidates;');
211: HZ_GEN_PLSQL.add_line('x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
212: HZ_GEN_PLSQL.add_line('FND_MESSAGE.SET_NAME( ''AR'', ''HZ_API_OTHERS_EXCEP'' );');
213: HZ_GEN_PLSQL.add_line('FND_MESSAGE.SET_TOKEN( ''ERROR'' ,SQLERRM );');
214: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.ADD;');
215:

Line 212: HZ_GEN_PLSQL.add_line('FND_MESSAGE.SET_NAME( ''AR'', ''HZ_API_OTHERS_EXCEP'' );');

208: HZ_GEN_PLSQL.add_line('EXCEPTION');
209: HZ_GEN_PLSQL.add_line('WHEN OTHERS THEN');
210: HZ_GEN_PLSQL.add_line('ROLLBACK to identify_candidates;');
211: HZ_GEN_PLSQL.add_line('x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
212: HZ_GEN_PLSQL.add_line('FND_MESSAGE.SET_NAME( ''AR'', ''HZ_API_OTHERS_EXCEP'' );');
213: HZ_GEN_PLSQL.add_line('FND_MESSAGE.SET_TOKEN( ''ERROR'' ,SQLERRM );');
214: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.ADD;');
215:
216: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.Count_And_Get(

Line 213: HZ_GEN_PLSQL.add_line('FND_MESSAGE.SET_TOKEN( ''ERROR'' ,SQLERRM );');

209: HZ_GEN_PLSQL.add_line('WHEN OTHERS THEN');
210: HZ_GEN_PLSQL.add_line('ROLLBACK to identify_candidates;');
211: HZ_GEN_PLSQL.add_line('x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
212: HZ_GEN_PLSQL.add_line('FND_MESSAGE.SET_NAME( ''AR'', ''HZ_API_OTHERS_EXCEP'' );');
213: HZ_GEN_PLSQL.add_line('FND_MESSAGE.SET_TOKEN( ''ERROR'' ,SQLERRM );');
214: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.ADD;');
215:
216: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.Count_And_Get(
217: p_encoded => FND_API.G_FALSE,

Line 214: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.ADD;');

210: HZ_GEN_PLSQL.add_line('ROLLBACK to identify_candidates;');
211: HZ_GEN_PLSQL.add_line('x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
212: HZ_GEN_PLSQL.add_line('FND_MESSAGE.SET_NAME( ''AR'', ''HZ_API_OTHERS_EXCEP'' );');
213: HZ_GEN_PLSQL.add_line('FND_MESSAGE.SET_TOKEN( ''ERROR'' ,SQLERRM );');
214: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.ADD;');
215:
216: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.Count_And_Get(
217: p_encoded => FND_API.G_FALSE,
218: p_count => x_msg_count,

Line 216: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.Count_And_Get(

212: HZ_GEN_PLSQL.add_line('FND_MESSAGE.SET_NAME( ''AR'', ''HZ_API_OTHERS_EXCEP'' );');
213: HZ_GEN_PLSQL.add_line('FND_MESSAGE.SET_TOKEN( ''ERROR'' ,SQLERRM );');
214: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.ADD;');
215:
216: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.Count_And_Get(
217: p_encoded => FND_API.G_FALSE,
218: p_count => x_msg_count,
219: p_data => x_msg_data );');
220: HZ_GEN_PLSQL.add_line('RAISE FND_API.G_EXC_ERROR;');

Line 220: HZ_GEN_PLSQL.add_line('RAISE FND_API.G_EXC_ERROR;');

216: HZ_GEN_PLSQL.add_line('FND_MSG_PUB.Count_And_Get(
217: p_encoded => FND_API.G_FALSE,
218: p_count => x_msg_count,
219: p_data => x_msg_data );');
220: HZ_GEN_PLSQL.add_line('RAISE FND_API.G_EXC_ERROR;');
221:
222: HZ_GEN_PLSQL.add_line('END IDENTIFY_CANDIDATES;');
223:
224: HZ_GEN_PLSQL.add_line('END HZ_PURGE_GEN;');

Line 222: HZ_GEN_PLSQL.add_line('END IDENTIFY_CANDIDATES;');

218: p_count => x_msg_count,
219: p_data => x_msg_data );');
220: HZ_GEN_PLSQL.add_line('RAISE FND_API.G_EXC_ERROR;');
221:
222: HZ_GEN_PLSQL.add_line('END IDENTIFY_CANDIDATES;');
223:
224: HZ_GEN_PLSQL.add_line('END HZ_PURGE_GEN;');
225: HZ_GEN_PLSQL.compile_code;
226:

Line 224: HZ_GEN_PLSQL.add_line('END HZ_PURGE_GEN;');

220: HZ_GEN_PLSQL.add_line('RAISE FND_API.G_EXC_ERROR;');
221:
222: HZ_GEN_PLSQL.add_line('END IDENTIFY_CANDIDATES;');
223:
224: HZ_GEN_PLSQL.add_line('END HZ_PURGE_GEN;');
225: HZ_GEN_PLSQL.compile_code;
226:
227:
228: -- standard call to get message count and if count is 1, get message info.

Line 225: HZ_GEN_PLSQL.compile_code;

221:
222: HZ_GEN_PLSQL.add_line('END IDENTIFY_CANDIDATES;');
223:
224: HZ_GEN_PLSQL.add_line('END HZ_PURGE_GEN;');
225: HZ_GEN_PLSQL.compile_code;
226:
227:
228: -- standard call to get message count and if count is 1, get message info.
229: FND_MSG_PUB.Count_And_Get(