APPS.INV_QUANTITY_TREE_PVT dependencies on FND_DATE

Line 1300: -- dbms_output.put(', lotdate: '|| fnd_date.date_to_canonical(l_lot_expiration_date));

1296: -- dbms_output.put('org '||l_organization_id);
1297: -- dbms_output.put(', item '||l_inventory_item_id);
1298: -- dbms_output.put(', rev '||l_revision);
1299: -- dbms_output.put(', lot '||l_lot_number);
1300: -- dbms_output.put(', lotdate: '|| fnd_date.date_to_canonical(l_lot_expiration_date));
1301: -- dbms_output.put(', sub '||l_subinventory_code);
1302: -- dbms_output.put(', rsvtype '|| To_char(l_reservable_type));
1303: -- dbms_output.put(', loc '||To_char(l_locator_id));
1304: -- dbms_output.put(', priqty '|| To_char(l_primary_quantity));

Line 1384: -- || fnd_date.date_to_canonical

1380: -- END IF;
1381:
1382: -- print_debug
1383: -- ('lot_expiration_date: '
1384: -- || fnd_date.date_to_canonical
1385: -- (g_rootinfos(p_tree_id).lot_expiration_date));
1386: -- print_debug('item_node_index: '
1387: -- || To_char(g_rootinfos(p_tree_id).item_node_index));
1388: -- print_debug('_____end of rootinfo '||To_char(p_tree_id));

Line 8485: -- dbms_output.put(', lotdate: '|| fnd_date.date_to_canonical(l_lot_expiration_date));

8481: -- dbms_output.put(', loc '||To_char(l_locator_id));
8482: -- dbms_output.put(', lot '||l_lot_number);
8483: -- print_debug(', priqty '|| To_char(l_primary_quantity));
8484: -- dbms_output.put(', rev '||l_revision);
8485: -- dbms_output.put(', lotdate: '|| fnd_date.date_to_canonical(l_lot_expiration_date));
8486: -- dbms_output.put(', rsvtype '|| To_char(l_reservable_type));
8487: -- dbms_output.put(', datercv '||To_char(l_date_received));
8488: -- dbms_output.put_line(', qtytype '||l_quantity_type);
8489:

Line 13216: l_buf := l_buf || ' TIMESTAMP="'||fnd_date.date_to_canonical(Sysdate)

13212: || '_Org_' || To_char(g_rootinfos(p_tree_id).organization_id)
13213: || '_Item_'|| To_char(g_rootinfos(p_tree_id).inventory_item_id);
13214: l_buf := ' 13215:
13216: l_buf := l_buf || ' TIMESTAMP="'||fnd_date.date_to_canonical(Sysdate)
13217: || '"';
13218: l_buf := l_buf || ' TREE_ID="'||To_char(p_tree_id) ||'"';
13219: l_buf := l_buf || ' ORGANIZATION_ID="'
13220: || To_char(g_rootinfos(p_tree_id).organization_id)|| '"';

Line 13275: ||fnd_date.date_to_canonical

13271: l_buf := l_buf || ' NEED_REFRESH="FALSE"';
13272: END IF;
13273:
13274: l_buf := l_buf || ' LOT_EXPIRATION_DATE="'
13275: ||fnd_date.date_to_canonical
13276: (g_rootinfos(p_tree_id).lot_expiration_date)|| '"';
13277: l_buf := l_buf || ' ITEM_NODE_INDEX="'
13278: || To_char(g_rootinfos(p_tree_id).item_node_index)|| '"';
13279:

Line 13425: || fnd_date.date_to_canonical(Sysdate) || '">';

13421:
13422: -- dbm_output.put_line('Dumping All Trees');
13423:
13424: l_buf := '';
13426:
13427: l_rval := send
13428: (
13429: p_pipename => p_pipename