APPS.POS_SUPP_PUB_RAISE_EVENT_PKG dependencies on POS_SUPP_PUB_HISTORY

Line 235: -- Update the Last login details etc., in pos_supp_pub_history table

231: l_event_key := raise_publish_supplier_event(p_publication_event_id(i));
232: l_msg_data:=l_msg_data||p_publication_event_id(i)||',';
233: l_msg_count:=l_msg_count+1;
234:
235: -- Update the Last login details etc., in pos_supp_pub_history table
236: update pos_supp_pub_history set last_updated_by=l_user_id , last_update_date=sysdate,
237: last_update_login=l_last_update_login where publication_event_id=p_publication_event_id(i);
238: commit;
239:

Line 236: update pos_supp_pub_history set last_updated_by=l_user_id , last_update_date=sysdate,

232: l_msg_data:=l_msg_data||p_publication_event_id(i)||',';
233: l_msg_count:=l_msg_count+1;
234:
235: -- Update the Last login details etc., in pos_supp_pub_history table
236: update pos_supp_pub_history set last_updated_by=l_user_id , last_update_date=sysdate,
237: last_update_login=l_last_update_login where publication_event_id=p_publication_event_id(i);
238: commit;
239:
240: END LOOP;

Line 547: fnd_file.put_line(fnd_file.log,'Inserting the XML Payload into pos_supp_pub_history table');

543: IF l_xml_conversion_stats = 0 THEN
544: GOTO exit1;
545: END IF;
546:
547: fnd_file.put_line(fnd_file.log,'Inserting the XML Payload into pos_supp_pub_history table');
548: INSERT INTO pos_supp_pub_history
549: (publication_event_id,
550: party_id,
551: publication_date,

Line 548: INSERT INTO pos_supp_pub_history

544: GOTO exit1;
545: END IF;
546:
547: fnd_file.put_line(fnd_file.log,'Inserting the XML Payload into pos_supp_pub_history table');
548: INSERT INTO pos_supp_pub_history
549: (publication_event_id,
550: party_id,
551: publication_date,
552: published_by,

Line 650: FROM pos_supp_pub_history

646: BEGIN
647:
648: OPEN x_party_id_cursor FOR
649: SELECT party_id
650: FROM pos_supp_pub_history
651: WHERE publication_event_id = p_publication_event_id;
652: EXCEPTION
653: WHEN OTHERS THEN
654: x_return_status := fnd_api.g_ret_sts_unexp_error;