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.POS_CANCEL_ASN dependencies on AP_INVOICES

Line 64: from AP_INVOICES_ALL

60: and rsh.vendor_site_id = p_vendor_site_id;
61:
62: CURSOR c_invoice IS
63: select invoice_id, org_id
64: from AP_INVOICES_ALL
65: where invoice_num = p_invoice_num
66: and vendor_id = p_vendor_id
67: and vendor_site_id = p_vendor_site_id;
68:

Line 1117: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;

1113: plsql_block_old VARCHAR2(1000);
1114: plsql_block_new VARCHAR2(1000);
1115:
1116: l_message_name FND_NEW_MESSAGES.message_name%TYPE;
1117: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
1118: l_base_amount AP_INVOICES.base_amount%TYPE;
1119: l_tax_amount AP_INVOICES.tax_amount%TYPE;
1120: l_temp_cancelled_amount AP_INVOICES.temp_cancelled_amount%TYPE;
1121: l_cancelled_by AP_INVOICES.cancelled_by%TYPE;

Line 1118: l_base_amount AP_INVOICES.base_amount%TYPE;

1114: plsql_block_new VARCHAR2(1000);
1115:
1116: l_message_name FND_NEW_MESSAGES.message_name%TYPE;
1117: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
1118: l_base_amount AP_INVOICES.base_amount%TYPE;
1119: l_tax_amount AP_INVOICES.tax_amount%TYPE;
1120: l_temp_cancelled_amount AP_INVOICES.temp_cancelled_amount%TYPE;
1121: l_cancelled_by AP_INVOICES.cancelled_by%TYPE;
1122: l_cancelled_amount AP_INVOICES.cancelled_amount%TYPE;

Line 1119: l_tax_amount AP_INVOICES.tax_amount%TYPE;

1115:
1116: l_message_name FND_NEW_MESSAGES.message_name%TYPE;
1117: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
1118: l_base_amount AP_INVOICES.base_amount%TYPE;
1119: l_tax_amount AP_INVOICES.tax_amount%TYPE;
1120: l_temp_cancelled_amount AP_INVOICES.temp_cancelled_amount%TYPE;
1121: l_cancelled_by AP_INVOICES.cancelled_by%TYPE;
1122: l_cancelled_amount AP_INVOICES.cancelled_amount%TYPE;
1123: l_cancelled_date AP_INVOICES.cancelled_date%TYPE;

Line 1120: l_temp_cancelled_amount AP_INVOICES.temp_cancelled_amount%TYPE;

1116: l_message_name FND_NEW_MESSAGES.message_name%TYPE;
1117: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
1118: l_base_amount AP_INVOICES.base_amount%TYPE;
1119: l_tax_amount AP_INVOICES.tax_amount%TYPE;
1120: l_temp_cancelled_amount AP_INVOICES.temp_cancelled_amount%TYPE;
1121: l_cancelled_by AP_INVOICES.cancelled_by%TYPE;
1122: l_cancelled_amount AP_INVOICES.cancelled_amount%TYPE;
1123: l_cancelled_date AP_INVOICES.cancelled_date%TYPE;
1124: l_last_update_date AP_INVOICES.last_update_date%TYPE;

Line 1121: l_cancelled_by AP_INVOICES.cancelled_by%TYPE;

1117: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
1118: l_base_amount AP_INVOICES.base_amount%TYPE;
1119: l_tax_amount AP_INVOICES.tax_amount%TYPE;
1120: l_temp_cancelled_amount AP_INVOICES.temp_cancelled_amount%TYPE;
1121: l_cancelled_by AP_INVOICES.cancelled_by%TYPE;
1122: l_cancelled_amount AP_INVOICES.cancelled_amount%TYPE;
1123: l_cancelled_date AP_INVOICES.cancelled_date%TYPE;
1124: l_last_update_date AP_INVOICES.last_update_date%TYPE;
1125: l_dummy_amount NUMBER;

Line 1122: l_cancelled_amount AP_INVOICES.cancelled_amount%TYPE;

1118: l_base_amount AP_INVOICES.base_amount%TYPE;
1119: l_tax_amount AP_INVOICES.tax_amount%TYPE;
1120: l_temp_cancelled_amount AP_INVOICES.temp_cancelled_amount%TYPE;
1121: l_cancelled_by AP_INVOICES.cancelled_by%TYPE;
1122: l_cancelled_amount AP_INVOICES.cancelled_amount%TYPE;
1123: l_cancelled_date AP_INVOICES.cancelled_date%TYPE;
1124: l_last_update_date AP_INVOICES.last_update_date%TYPE;
1125: l_dummy_amount NUMBER;
1126: l_token VARCHAR2(1000);

Line 1123: l_cancelled_date AP_INVOICES.cancelled_date%TYPE;

1119: l_tax_amount AP_INVOICES.tax_amount%TYPE;
1120: l_temp_cancelled_amount AP_INVOICES.temp_cancelled_amount%TYPE;
1121: l_cancelled_by AP_INVOICES.cancelled_by%TYPE;
1122: l_cancelled_amount AP_INVOICES.cancelled_amount%TYPE;
1123: l_cancelled_date AP_INVOICES.cancelled_date%TYPE;
1124: l_last_update_date AP_INVOICES.last_update_date%TYPE;
1125: l_dummy_amount NUMBER;
1126: l_token VARCHAR2(1000);
1127: l_pay_curr_invoice_amount AP_INVOICES.pay_curr_invoice_amount%TYPE;

Line 1124: l_last_update_date AP_INVOICES.last_update_date%TYPE;

1120: l_temp_cancelled_amount AP_INVOICES.temp_cancelled_amount%TYPE;
1121: l_cancelled_by AP_INVOICES.cancelled_by%TYPE;
1122: l_cancelled_amount AP_INVOICES.cancelled_amount%TYPE;
1123: l_cancelled_date AP_INVOICES.cancelled_date%TYPE;
1124: l_last_update_date AP_INVOICES.last_update_date%TYPE;
1125: l_dummy_amount NUMBER;
1126: l_token VARCHAR2(1000);
1127: l_pay_curr_invoice_amount AP_INVOICES.pay_curr_invoice_amount%TYPE;
1128:

Line 1127: l_pay_curr_invoice_amount AP_INVOICES.pay_curr_invoice_amount%TYPE;

1123: l_cancelled_date AP_INVOICES.cancelled_date%TYPE;
1124: l_last_update_date AP_INVOICES.last_update_date%TYPE;
1125: l_dummy_amount NUMBER;
1126: l_token VARCHAR2(1000);
1127: l_pay_curr_invoice_amount AP_INVOICES.pay_curr_invoice_amount%TYPE;
1128:
1129: BEGIN
1130:
1131: /* plsql_block_new has one more binding argument than plsql_block_old. */

Line 1212: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;

1208: plsql_block_old VARCHAR2(1000);
1209: plsql_block_new VARCHAR2(1000);
1210:
1211: l_message_name FND_NEW_MESSAGES.message_name%TYPE;
1212: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
1213: l_base_amount AP_INVOICES.base_amount%TYPE;
1214: l_tax_amount AP_INVOICES.tax_amount%TYPE;
1215: l_temp_cancelled_amount AP_INVOICES.temp_cancelled_amount%TYPE;
1216: l_cancelled_by AP_INVOICES.cancelled_by%TYPE;

Line 1213: l_base_amount AP_INVOICES.base_amount%TYPE;

1209: plsql_block_new VARCHAR2(1000);
1210:
1211: l_message_name FND_NEW_MESSAGES.message_name%TYPE;
1212: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
1213: l_base_amount AP_INVOICES.base_amount%TYPE;
1214: l_tax_amount AP_INVOICES.tax_amount%TYPE;
1215: l_temp_cancelled_amount AP_INVOICES.temp_cancelled_amount%TYPE;
1216: l_cancelled_by AP_INVOICES.cancelled_by%TYPE;
1217: l_cancelled_amount AP_INVOICES.cancelled_amount%TYPE;

Line 1214: l_tax_amount AP_INVOICES.tax_amount%TYPE;

1210:
1211: l_message_name FND_NEW_MESSAGES.message_name%TYPE;
1212: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
1213: l_base_amount AP_INVOICES.base_amount%TYPE;
1214: l_tax_amount AP_INVOICES.tax_amount%TYPE;
1215: l_temp_cancelled_amount AP_INVOICES.temp_cancelled_amount%TYPE;
1216: l_cancelled_by AP_INVOICES.cancelled_by%TYPE;
1217: l_cancelled_amount AP_INVOICES.cancelled_amount%TYPE;
1218: l_cancelled_date AP_INVOICES.cancelled_date%TYPE;

Line 1215: l_temp_cancelled_amount AP_INVOICES.temp_cancelled_amount%TYPE;

1211: l_message_name FND_NEW_MESSAGES.message_name%TYPE;
1212: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
1213: l_base_amount AP_INVOICES.base_amount%TYPE;
1214: l_tax_amount AP_INVOICES.tax_amount%TYPE;
1215: l_temp_cancelled_amount AP_INVOICES.temp_cancelled_amount%TYPE;
1216: l_cancelled_by AP_INVOICES.cancelled_by%TYPE;
1217: l_cancelled_amount AP_INVOICES.cancelled_amount%TYPE;
1218: l_cancelled_date AP_INVOICES.cancelled_date%TYPE;
1219: l_last_update_date AP_INVOICES.last_update_date%TYPE;

Line 1216: l_cancelled_by AP_INVOICES.cancelled_by%TYPE;

1212: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
1213: l_base_amount AP_INVOICES.base_amount%TYPE;
1214: l_tax_amount AP_INVOICES.tax_amount%TYPE;
1215: l_temp_cancelled_amount AP_INVOICES.temp_cancelled_amount%TYPE;
1216: l_cancelled_by AP_INVOICES.cancelled_by%TYPE;
1217: l_cancelled_amount AP_INVOICES.cancelled_amount%TYPE;
1218: l_cancelled_date AP_INVOICES.cancelled_date%TYPE;
1219: l_last_update_date AP_INVOICES.last_update_date%TYPE;
1220: l_dummy_amount NUMBER;

Line 1217: l_cancelled_amount AP_INVOICES.cancelled_amount%TYPE;

1213: l_base_amount AP_INVOICES.base_amount%TYPE;
1214: l_tax_amount AP_INVOICES.tax_amount%TYPE;
1215: l_temp_cancelled_amount AP_INVOICES.temp_cancelled_amount%TYPE;
1216: l_cancelled_by AP_INVOICES.cancelled_by%TYPE;
1217: l_cancelled_amount AP_INVOICES.cancelled_amount%TYPE;
1218: l_cancelled_date AP_INVOICES.cancelled_date%TYPE;
1219: l_last_update_date AP_INVOICES.last_update_date%TYPE;
1220: l_dummy_amount NUMBER;
1221: l_token VARCHAR2(1000);

Line 1218: l_cancelled_date AP_INVOICES.cancelled_date%TYPE;

1214: l_tax_amount AP_INVOICES.tax_amount%TYPE;
1215: l_temp_cancelled_amount AP_INVOICES.temp_cancelled_amount%TYPE;
1216: l_cancelled_by AP_INVOICES.cancelled_by%TYPE;
1217: l_cancelled_amount AP_INVOICES.cancelled_amount%TYPE;
1218: l_cancelled_date AP_INVOICES.cancelled_date%TYPE;
1219: l_last_update_date AP_INVOICES.last_update_date%TYPE;
1220: l_dummy_amount NUMBER;
1221: l_token VARCHAR2(1000);
1222: l_pay_curr_invoice_amount AP_INVOICES.pay_curr_invoice_amount%TYPE;

Line 1219: l_last_update_date AP_INVOICES.last_update_date%TYPE;

1215: l_temp_cancelled_amount AP_INVOICES.temp_cancelled_amount%TYPE;
1216: l_cancelled_by AP_INVOICES.cancelled_by%TYPE;
1217: l_cancelled_amount AP_INVOICES.cancelled_amount%TYPE;
1218: l_cancelled_date AP_INVOICES.cancelled_date%TYPE;
1219: l_last_update_date AP_INVOICES.last_update_date%TYPE;
1220: l_dummy_amount NUMBER;
1221: l_token VARCHAR2(1000);
1222: l_pay_curr_invoice_amount AP_INVOICES.pay_curr_invoice_amount%TYPE;
1223:

Line 1222: l_pay_curr_invoice_amount AP_INVOICES.pay_curr_invoice_amount%TYPE;

1218: l_cancelled_date AP_INVOICES.cancelled_date%TYPE;
1219: l_last_update_date AP_INVOICES.last_update_date%TYPE;
1220: l_dummy_amount NUMBER;
1221: l_token VARCHAR2(1000);
1222: l_pay_curr_invoice_amount AP_INVOICES.pay_curr_invoice_amount%TYPE;
1223:
1224: BEGIN
1225:
1226: /* plsql_block_new has one more binding argument than plsql_block_old. */

Line 1311: from ap_invoices_all

1307: BEGIN
1308:
1309: select set_of_books_id, gl_date
1310: into l_set_of_books_id, l_gl_date
1311: from ap_invoices_all
1312: where invoice_id = p_invoice_id;
1313:
1314: l_period_name := AP_INVOICES_PKG.GET_PERIOD_NAME(l_gl_date);
1315:

Line 1314: l_period_name := AP_INVOICES_PKG.GET_PERIOD_NAME(l_gl_date);

1310: into l_set_of_books_id, l_gl_date
1311: from ap_invoices_all
1312: where invoice_id = p_invoice_id;
1313:
1314: l_period_name := AP_INVOICES_PKG.GET_PERIOD_NAME(l_gl_date);
1315:
1316: /** Get AP's patch level in the enviroment **/
1317: BEGIN
1318: ad_version_util.get_product_patch_level(200, l_ap_patch_level);