APPS.ASG_CONS_QPKG dependencies on ASG_CONF_INFO

Line 1222: FROM asg_conf_info

1218: CURSOR c_conf_rows (p_user_name VARCHAR2,
1219: p_upload_tranid NUMBER,
1220: p_pubitem VARCHAR2) IS
1221: SELECT sequence
1222: FROM asg_conf_info
1223: WHERE user_name = p_user_name AND
1224: transaction_id = p_upload_tranid AND
1225: pub_item = p_pubitem AND
1226: sequence IS NOT NULL;

Line 1278: insert into asg_conf_info (user_name,

1274: l_client_wins := asg_base.G_CLIENT_WINS;
1275: l_server_wins := asg_base.G_SERVER_WINS;
1276: l_download_tranid := asg_base.get_current_tranid();
1277: -- Get the access_id of updated DMLs
1278: insert into asg_conf_info (user_name,
1279: pub_item,
1280: transaction_id,
1281: access_id,
1282: resolution,

Line 1314: l_query_string := 'UPDATE asg_conf_info ' ||

1310: END IF;
1311:
1312: -- Link the access-ids with sequence no in inq table
1313: l_pk_predicate := get_pk_predicate(l_primary_key_columns);
1314: l_query_string := 'UPDATE asg_conf_info ' ||
1315: 'SET (sequence, access_id) = ' ||
1316: '(SELECT seqno$$, access_id ' ||
1317: ' FROM ' || l_inqtable_name || ' inq, ' ||
1318: l_piv || ' piv ' ||

Line 1325: ' FROM asg_conf_info ' ||

1321: ' inq.dmltype$$ = ''U'' AND ' ||
1322: l_pk_predicate || ' AND ' ||
1323: ' piv.access_id in ' ||
1324: '(SELECT access_id ' ||
1325: ' FROM asg_conf_info ' ||
1326: ' WHERE user_name = :3 AND ' ||
1327: ' transaction_id = :4 AND ' ||
1328: ' pub_item = :5)) ' ||
1329: ' WHERE user_name = :6 AND ' ||

Line 1369: UPDATE asg_conf_info

1365: 'asg_cons_qpkg',g_stmt_level);
1366: END IF;
1367: END;
1368: IF (l_conf_resolution = l_server_wins) THEN
1369: UPDATE asg_conf_info
1370: SET resolution = l_conf_resolution
1371: WHERE user_name = p_user_name AND
1372: transaction_id = p_upload_tranid AND
1373: pub_item = p_pubitem AND

Line 1388: FROM asg_conf_info

1384: pub_item = p_pubitem AND
1385: transaction_id = l_download_tranid AND
1386: dml_type = 2 AND
1387: access_id in (select access_id
1388: FROM asg_conf_info
1389: WHERE user_name = p_user_name AND
1390: transaction_id = p_upload_tranid AND
1391: pub_item = p_pubitem AND
1392: sequence IS NOT NULL AND