APPS.CSM_HTML5_PKG dependencies on ASG_CONF_INFO

Line 2091: FROM asg_conf_info

2087: CURSOR c_conf_rows (p_user_name VARCHAR2,
2088: p_upload_tranid NUMBER,
2089: p_pubitem VARCHAR2) IS
2090: SELECT sequence
2091: FROM asg_conf_info
2092: WHERE user_name = p_user_name AND
2093: transaction_id = p_upload_tranid AND
2094: pub_item = p_pubitem AND
2095: sequence IS NOT NULL;

Line 2113: insert into asg_conf_info (user_name,

2109: l_client_wins := asg_base.G_CLIENT_WINS;
2110: l_server_wins := asg_base.G_SERVER_WINS;
2111:
2112: -- Get the access_id of updated DMLs
2113: insert into asg_conf_info (user_name,
2114: pub_item,
2115: transaction_id,
2116: access_id,
2117: sequence,

Line 2159: UPDATE asg_conf_info

2155: WHEN OTHERS THEN
2156: CSM_UTIL_PKG.LOG('Exception in pub item level callback. ' || sqlerrm ,'CSM_HTML5_PKG.process_pubitem_conflicts', FND_LOG.LEVEL_PROCEDURE);
2157: END;
2158: IF (l_conf_resolution = l_server_wins) THEN
2159: UPDATE asg_conf_info
2160: SET resolution = l_conf_resolution
2161: WHERE user_name = p_user_name AND
2162: transaction_id = p_upload_tranid AND
2163: pub_item = p_pubitem AND

Line 2178: FROM asg_conf_info

2174: pub_item = p_pubitem AND
2175: transaction_id is NULL AND
2176: dml_type = 2 AND
2177: access_id in (select access_id
2178: FROM asg_conf_info
2179: WHERE user_name = p_user_name AND
2180: transaction_id = p_upload_tranid AND
2181: pub_item = p_pubitem AND
2182: sequence IS NOT NULL AND