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.PO_CONTERMS_WF_PVT dependencies on PO_HEADERS_ALL

Line 163: l_po_revision_num PO_HEADERS_ALL.REVISION_NUM%TYPE;

159: p_action_code IN VARCHAR2,
160: p_doc_subtype IN VARCHAR2,
161: x_event_tbl OUT NOCOPY EVENT_TBL_TYPE) IS
162:
163: l_po_revision_num PO_HEADERS_ALL.REVISION_NUM%TYPE;
164: l_po_start_date PO_HEADERS_ALL.START_DATE%TYPE;
165: l_po_end_date PO_HEADERS_ALL.END_DATE%TYPE;
166: l_archive_start_date PO_HEADERS_ALL.START_DATE%TYPE;
167: l_archive_end_date PO_HEADERS_ALL.END_DATE%TYPE;

Line 164: l_po_start_date PO_HEADERS_ALL.START_DATE%TYPE;

160: p_doc_subtype IN VARCHAR2,
161: x_event_tbl OUT NOCOPY EVENT_TBL_TYPE) IS
162:
163: l_po_revision_num PO_HEADERS_ALL.REVISION_NUM%TYPE;
164: l_po_start_date PO_HEADERS_ALL.START_DATE%TYPE;
165: l_po_end_date PO_HEADERS_ALL.END_DATE%TYPE;
166: l_archive_start_date PO_HEADERS_ALL.START_DATE%TYPE;
167: l_archive_end_date PO_HEADERS_ALL.END_DATE%TYPE;
168:

Line 165: l_po_end_date PO_HEADERS_ALL.END_DATE%TYPE;

161: x_event_tbl OUT NOCOPY EVENT_TBL_TYPE) IS
162:
163: l_po_revision_num PO_HEADERS_ALL.REVISION_NUM%TYPE;
164: l_po_start_date PO_HEADERS_ALL.START_DATE%TYPE;
165: l_po_end_date PO_HEADERS_ALL.END_DATE%TYPE;
166: l_archive_start_date PO_HEADERS_ALL.START_DATE%TYPE;
167: l_archive_end_date PO_HEADERS_ALL.END_DATE%TYPE;
168:
169: BEGIN

Line 166: l_archive_start_date PO_HEADERS_ALL.START_DATE%TYPE;

162:
163: l_po_revision_num PO_HEADERS_ALL.REVISION_NUM%TYPE;
164: l_po_start_date PO_HEADERS_ALL.START_DATE%TYPE;
165: l_po_end_date PO_HEADERS_ALL.END_DATE%TYPE;
166: l_archive_start_date PO_HEADERS_ALL.START_DATE%TYPE;
167: l_archive_end_date PO_HEADERS_ALL.END_DATE%TYPE;
168:
169: BEGIN
170: IF g_fnd_debug = 'Y' then

Line 167: l_archive_end_date PO_HEADERS_ALL.END_DATE%TYPE;

163: l_po_revision_num PO_HEADERS_ALL.REVISION_NUM%TYPE;
164: l_po_start_date PO_HEADERS_ALL.START_DATE%TYPE;
165: l_po_end_date PO_HEADERS_ALL.END_DATE%TYPE;
166: l_archive_start_date PO_HEADERS_ALL.START_DATE%TYPE;
167: l_archive_end_date PO_HEADERS_ALL.END_DATE%TYPE;
168:
169: BEGIN
170: IF g_fnd_debug = 'Y' then
171: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 204: FROM po_headers_all

200: l_po_start_date,
201: l_po_end_date,
202: l_po_revision_num
203:
204: FROM po_headers_all
205: WHERE po_header_id = p_po_header_id;
206:
207: IF g_fnd_debug = 'Y' then
208: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 307: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';

303:
304: return VARCHAR2 IS
305: l_changed VARCHAR2(1) := 'N';
306: l_k_terms_changed VARCHAR2(30);
307: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
308:
309: l_return_status VARCHAR2(1);
310: l_msg_data VARCHAR2(2000);
311: l_msg_count NUMBER;

Line 313: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;

309: l_return_status VARCHAR2(1);
310: l_msg_data VARCHAR2(2000);
311: l_msg_count NUMBER;
312:
313: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
314: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
315: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
316: l_archived_conterms_flag PO_headers_all.conterms_exist_Flag%Type :='N';
317:

Line 316: l_archived_conterms_flag PO_headers_all.conterms_exist_Flag%Type :='N';

312:
313: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
314: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
315: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
316: l_archived_conterms_flag PO_headers_all.conterms_exist_Flag%Type :='N';
317:
318: l_contracts_call_exception exception;
319: l_api_name VARCHAR2(100);
320: BEGIN

Line 674: -- SQL What:Updates PO_HEADERS_ALL table and sets the contract terms dates

670: MODULE =>g_module_prefix||l_api_name,
671: MESSAGE =>'120: Before update of dates in po headers'||l_deliv_upd_date);
672: END IF;
673: END IF;
674: -- SQL What:Updates PO_HEADERS_ALL table and sets the contract terms dates
675: -- SQL Why :After PO is Approved, sync up contract terms dates.
676: -- SQL Join:none
677: UPDATE PO_HEADERS_ALL
678: SET conterms_articles_upd_date = l_articles_upd_date,

Line 677: UPDATE PO_HEADERS_ALL

673: END IF;
674: -- SQL What:Updates PO_HEADERS_ALL table and sets the contract terms dates
675: -- SQL Why :After PO is Approved, sync up contract terms dates.
676: -- SQL Join:none
677: UPDATE PO_HEADERS_ALL
678: SET conterms_articles_upd_date = l_articles_upd_date,
679: conterms_deliv_upd_date = l_deliv_upd_date,
680: last_updated_by = FND_GLOBAL.user_id,
681: last_update_login = FND_GLOBAL.login_id,

Line 803: l_conterms_exist_flag PO_HEADERS_ALL.CONTERMS_EXIST_FLAG%TYPE;

799: x_return_status OUT NOCOPY VARCHAR2,
800: x_msg_data OUT NOCOPY VARCHAR2,
801: x_msg_count OUT NOCOPY NUMBER) IS
802:
803: l_conterms_exist_flag PO_HEADERS_ALL.CONTERMS_EXIST_FLAG%TYPE;
804: l_po_doc_subtype PO_DOCUMENT_TYPES_ALL_B.DOCUMENT_SUBTYPE%TYPE;
805: l_po_revision_num PO_HEADERS_ALL.REVISION_NUM%TYPE;
806: l_event_tbl EVENT_TBL_TYPE;
807: l_k_api_name VARCHAR2(100);

Line 805: l_po_revision_num PO_HEADERS_ALL.REVISION_NUM%TYPE;

801: x_msg_count OUT NOCOPY NUMBER) IS
802:
803: l_conterms_exist_flag PO_HEADERS_ALL.CONTERMS_EXIST_FLAG%TYPE;
804: l_po_doc_subtype PO_DOCUMENT_TYPES_ALL_B.DOCUMENT_SUBTYPE%TYPE;
805: l_po_revision_num PO_HEADERS_ALL.REVISION_NUM%TYPE;
806: l_event_tbl EVENT_TBL_TYPE;
807: l_k_api_name VARCHAR2(100);
808: l_cancel_flag PO_HEADERS_ALL.CANCEL_FLAG%TYPE;
809: l_po_doc_type VARCHAR2(2);

Line 808: l_cancel_flag PO_HEADERS_ALL.CANCEL_FLAG%TYPE;

804: l_po_doc_subtype PO_DOCUMENT_TYPES_ALL_B.DOCUMENT_SUBTYPE%TYPE;
805: l_po_revision_num PO_HEADERS_ALL.REVISION_NUM%TYPE;
806: l_event_tbl EVENT_TBL_TYPE;
807: l_k_api_name VARCHAR2(100);
808: l_cancel_flag PO_HEADERS_ALL.CANCEL_FLAG%TYPE;
809: l_po_doc_type VARCHAR2(2);
810:
811: l_i BINARY_INTEGER;
812: l_Contracts_call_exception EXCEPTION;

Line 816: l_last_signed_revision PO_HEADERS_ALL.REVISION_NUM%TYPE;

812: l_Contracts_call_exception EXCEPTION;
813: l_api_name CONSTANT VARCHAR(30) := 'UPDATE_CONTRACT_TERMS';
814:
815: -- Bug 3652222 START
816: l_last_signed_revision PO_HEADERS_ALL.REVISION_NUM%TYPE;
817: l_signed_records VARCHAR2(1);
818: -- Bug 3652222 END
819: BEGIN
820: IF g_fnd_debug = 'Y' then

Line 842: FROM po_headers_all

838: l_po_doc_subtype,
839: l_po_revision_num,
840: l_cancel_flag,
841: l_po_doc_type
842: FROM po_headers_all
843: WHERE po_header_id = p_po_header_id;
844:
845: IF g_fnd_debug = 'Y' then
846: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 1243: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;

1239: actid IN NUMBER,
1240: funcmode IN VARCHAR2,
1241: result OUT NOCOPY VARCHAR2) IS
1242:
1243: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
1244: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
1245: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
1246: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
1247:

Line 1244: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';

1240: funcmode IN VARCHAR2,
1241: result OUT NOCOPY VARCHAR2) IS
1242:
1243: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
1244: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
1245: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
1246: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
1247:
1248: l_return_status VARCHAR2(1);

Line 1393: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;

1389: actid IN NUMBER,
1390: funcmode IN VARCHAR2,
1391: result OUT NOCOPY VARCHAR2) IS
1392:
1393: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
1394: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
1395: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
1396: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
1397:

Line 1394: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';

1390: funcmode IN VARCHAR2,
1391: result OUT NOCOPY VARCHAR2) IS
1392:
1393: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
1394: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
1395: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
1396: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
1397:
1398: l_return_status VARCHAR2(1);

Line 1544: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;

1540: actid IN NUMBER,
1541: funcmode IN VARCHAR2,
1542: result OUT NOCOPY VARCHAR2) IS
1543:
1544: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
1545: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
1546: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
1547: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
1548:

Line 1545: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';

1541: funcmode IN VARCHAR2,
1542: result OUT NOCOPY VARCHAR2) IS
1543:
1544: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
1545: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
1546: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
1547: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
1548:
1549: l_return_status VARCHAR2(1);

Line 1696: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;

1692: actid IN NUMBER,
1693: funcmode IN VARCHAR2,
1694: result OUT NOCOPY VARCHAR2) IS
1695:
1696: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
1697: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
1698: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
1699: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
1700:

Line 1697: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';

1693: funcmode IN VARCHAR2,
1694: result OUT NOCOPY VARCHAR2) IS
1695:
1696: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
1697: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
1698: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
1699: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
1700:
1701: l_return_status VARCHAR2(1);

Line 1851: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;

1847: actid IN NUMBER,
1848: funcmode IN VARCHAR2,
1849: result OUT NOCOPY VARCHAR2) IS
1850:
1851: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
1852: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
1853: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
1854: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
1855:

Line 1852: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';

1848: funcmode IN VARCHAR2,
1849: result OUT NOCOPY VARCHAR2) IS
1850:
1851: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
1852: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
1853: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
1854: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
1855:
1856: l_return_status VARCHAR2(1);

Line 2007: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;

2003: actid IN NUMBER,
2004: funcmode IN VARCHAR2,
2005: result OUT NOCOPY VARCHAR2) IS
2006:
2007: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
2008: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
2009: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
2010: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
2011:

Line 2008: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';

2004: funcmode IN VARCHAR2,
2005: result OUT NOCOPY VARCHAR2) IS
2006:
2007: l_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
2008: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N';
2009: l_po_doc_type PO_Document_Types_all_B.Document_type_code%Type;
2010: l_po_doc_subtype PO_Document_Types_all_B.Document_subtype%Type;
2011:
2012: l_return_status VARCHAR2(1);

Line 2177: l_bus_doc_version PO_HEADERS_ALL.revision_num%TYPE;

2173: ,p_busdocdates_tbl IN EVENT_TBL_TYPE
2174: ,x_return_status OUT NOCOPY VARCHAR2
2175: ) IS
2176:
2177: l_bus_doc_version PO_HEADERS_ALL.revision_num%TYPE;
2178: l_contracts_document_type VARCHAR2(150);
2179:
2180: l_api_name VARCHAR2(30) := 'cancel_deliverables';
2181: l_msg_data VARCHAR2(2000);

Line 2197: FROM po_headers_all

2193: -- SQL why : to cancel deliverables on the current version
2194: -- SQL join: po_header_id
2195: SELECT revision_num
2196: INTO l_bus_doc_version
2197: FROM po_headers_all
2198: WHERE po_header_id = p_bus_doc_id;
2199: ELSE
2200: l_bus_doc_version := p_bus_doc_version;
2201: END IF;