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_UTL_GRP dependencies on STANDARD

Line 149: IF (p_sub_doc_type = 'STANDARD') THEN

145: --End of Comments
146: -------------------------------------------------------------------------------
147: FUNCTION Get_Po_Contract_Doctype(p_sub_doc_type IN VARCHAR2) RETURN VARCHAR2 IS
148: BEGIN
149: IF (p_sub_doc_type = 'STANDARD') THEN
150: RETURN 'PO_STANDARD';
151: ELSIF (p_sub_doc_type = 'BLANKET') THEN
152: RETURN 'PA_BLANKET';
153: ELSIF (p_sub_doc_type = 'CONTRACT') THEN

Line 150: RETURN 'PO_STANDARD';

146: -------------------------------------------------------------------------------
147: FUNCTION Get_Po_Contract_Doctype(p_sub_doc_type IN VARCHAR2) RETURN VARCHAR2 IS
148: BEGIN
149: IF (p_sub_doc_type = 'STANDARD') THEN
150: RETURN 'PO_STANDARD';
151: ELSIF (p_sub_doc_type = 'BLANKET') THEN
152: RETURN 'PA_BLANKET';
153: ELSIF (p_sub_doc_type = 'CONTRACT') THEN
154: RETURN 'PA_CONTRACT';

Line 183: -- Contracts business document type ex: PA_BLANKET or PO_STANDARD

179: --IN:
180: --p_document_id
181: -- PO header ID
182: --p_document_type
183: -- Contracts business document type ex: PA_BLANKET or PO_STANDARD
184: -- This will be parsed to retrieve the PO document type
185: --p_external_contact_id
186: -- supplier contact ID on a contract deliverable. Default is NULL
187: --p_init_msg_list

Line 314: -- Contracts business document type ex: PA_BLANKET or PO_STANDARD

310: --IN:
311: --p_document_id
312: -- PO header ID
313: --p_document_type
314: -- Contracts business document type ex: PA_BLANKET or PO_STANDARD
315: -- This will be parsed to retrieve the PO document type
316: --p_external_contact_id
317: -- Supplier contact ID on the deliverable. Default is null.
318: --p_init_msg_list

Line 601: -- Standard Parameter. API version number expected by the caller

597: -- Return the current status and version back to Contracts with the results.
598: --Parameters:
599: --IN:
600: --p_api_version
601: -- Standard Parameter. API version number expected by the caller
602: --p_init_msg_list
603: -- Standard parameter.Initialize message list
604: --p_header_id
605: -- PO header id

Line 603: -- Standard parameter.Initialize message list

599: --IN:
600: --p_api_version
601: -- Standard Parameter. API version number expected by the caller
602: --p_init_msg_list
603: -- Standard parameter.Initialize message list
604: --p_header_id
605: -- PO header id
606: --p_callout_string
607: -- This string will contain concatenation of following parameters, delimited by comma

Line 619: -- Standard parameter.Message count

615: --OUT:
616: --x_update_allowed
617: -- Returns Y or N depending PO is in updatable status or not
618: --x_msg_count
619: -- Standard parameter.Message count
620: --x_msg_data
621: -- Standard parameter.message data
622: --x_return_status
623: -- Standard parameter. Status Returned to calling API. Possible values are following

Line 621: -- Standard parameter.message data

617: -- Returns Y or N depending PO is in updatable status or not
618: --x_msg_count
619: -- Standard parameter.Message count
620: --x_msg_data
621: -- Standard parameter.message data
622: --x_return_status
623: -- Standard parameter. Status Returned to calling API. Possible values are following
624: -- FND_API.G_RET_STS_ERROR - for expected error
625: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error

Line 623: -- Standard parameter. Status Returned to calling API. Possible values are following

619: -- Standard parameter.Message count
620: --x_msg_data
621: -- Standard parameter.message data
622: --x_return_status
623: -- Standard parameter. Status Returned to calling API. Possible values are following
624: -- FND_API.G_RET_STS_ERROR - for expected error
625: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
626: -- FND_API.G_RET_STS_SUCCESS - for success
627: --Notes:

Line 687: -- Standard call to check for call compatibility.

683: MESSAGE =>'10: Start' ||l_api_name);
684: END IF;
685: End if;
686:
687: -- Standard call to check for call compatibility.
688: IF NOT FND_API.Compatible_API_Call (p_current_version_number=>l_api_version,
689: p_caller_version_number =>p_api_version,
690: p_api_name =>l_api_name,
691: p_pkg_name =>G_PKG_NAME)

Line 791: ,DECODE(type_lookup_code,'STANDARD','PO','BLANKET','PA','CONTRACT','PA',null)

787: -- SQL WHAT-get the current status and revision of the PO
788: -- SQL WHY - Needed to compare status and revision with passed in values
789: -- SQL JOIN- PO_header_id
790: SELECT nvl(authorization_status,'INCOMPLETE'), revision_num, type_lookup_code
791: ,DECODE(type_lookup_code,'STANDARD','PO','BLANKET','PA','CONTRACT','PA',null)
792: INTO l_po_status,l_po_revision, l_doc_type_code
793: ,l_document_type
794: FROM po_headers_all
795: WHERE po_header_id = p_header_id;

Line 1078: -- Standard Parameter. API version number expected by the caller

1074:
1075: --Parameters:
1076: --IN:
1077: --p_api_version
1078: -- Standard Parameter. API version number expected by the caller
1079: --p_init_msg_list
1080: -- Standard parameter.Initialize message list
1081: --p_header_id
1082: -- PO header id

Line 1080: -- Standard parameter.Initialize message list

1076: --IN:
1077: --p_api_version
1078: -- Standard Parameter. API version number expected by the caller
1079: --p_init_msg_list
1080: -- Standard parameter.Initialize message list
1081: --p_header_id
1082: -- PO header id
1083: --p_callout_string
1084: -- This string will contain concatenation of following parameters, delimited by comma

Line 1099: -- Standard parameter.Message count

1095: --OUT:
1096: --x_update_allowed
1097: -- Returns Y or N depending PO is in updatable status or not
1098: --x_msg_count
1099: -- Standard parameter.Message count
1100: --x_msg_data
1101: -- Standard parameter.message data
1102: --x_return_status
1103: -- Standard parameter. Status Returned to calling API. Possible values are following

Line 1101: -- Standard parameter.message data

1097: -- Returns Y or N depending PO is in updatable status or not
1098: --x_msg_count
1099: -- Standard parameter.Message count
1100: --x_msg_data
1101: -- Standard parameter.message data
1102: --x_return_status
1103: -- Standard parameter. Status Returned to calling API. Possible values are following
1104: -- FND_API.G_RET_STS_ERROR - for expected error
1105: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error

Line 1103: -- Standard parameter. Status Returned to calling API. Possible values are following

1099: -- Standard parameter.Message count
1100: --x_msg_data
1101: -- Standard parameter.message data
1102: --x_return_status
1103: -- Standard parameter. Status Returned to calling API. Possible values are following
1104: -- FND_API.G_RET_STS_ERROR - for expected error
1105: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
1106: -- FND_API.G_RET_STS_SUCCESS - for success
1107: --Notes:

Line 1165: -- Standard call to check for call compatibility.

1161: END IF;
1162: End if;
1163: --Savepoint
1164: SAVEPOINT SP_APPLY_TEMPLATE_CHANGE;
1165: -- Standard call to check for call compatibility.
1166: IF NOT FND_API.Compatible_API_Call (p_current_version_number=>l_api_version,
1167: p_caller_version_number =>p_api_version,
1168: p_api_name =>l_api_name,
1169: p_pkg_name =>G_PKG_NAME)

Line 1469: -- Standard Parameter. API version number expected by the caller

1465: -- Changed between latest revision (working copy) and the last archived one.
1466: --Parameters:
1467: --IN:
1468: --p_api_version
1469: -- Standard Parameter. API version number expected by the caller
1470: --p_init_msg_list
1471: -- Standard parameter.Initialize message list
1472: --p_doc_id
1473: -- PO header id

Line 1471: -- Standard parameter.Initialize message list

1467: --IN:
1468: --p_api_version
1469: -- Standard Parameter. API version number expected by the caller
1470: --p_init_msg_list
1471: -- Standard parameter.Initialize message list
1472: --p_doc_id
1473: -- PO header id
1474: --IN OUT:
1475: --p_sys_var_tbl

Line 1481: -- Standard parameter.Message count

1477: -- Contracts will pass list of all PO attributes being used in Contract terms fot that PO
1478: -- This APi will filter that list to return only those which changed since last revsion
1479: --OUT:
1480: --x_msg_count
1481: -- Standard parameter.Message count
1482: --x_msg_data
1483: -- Standard parameter.message data
1484: --x_return_status
1485: -- Standard parameter. Status Returned to calling API. Possible values are following

Line 1483: -- Standard parameter.message data

1479: --OUT:
1480: --x_msg_count
1481: -- Standard parameter.Message count
1482: --x_msg_data
1483: -- Standard parameter.message data
1484: --x_return_status
1485: -- Standard parameter. Status Returned to calling API. Possible values are following
1486: -- FND_API.G_RET_STS_ERROR - for expected error
1487: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error

Line 1485: -- Standard parameter. Status Returned to calling API. Possible values are following

1481: -- Standard parameter.Message count
1482: --x_msg_data
1483: -- Standard parameter.message data
1484: --x_return_status
1485: -- Standard parameter. Status Returned to calling API. Possible values are following
1486: -- FND_API.G_RET_STS_ERROR - for expected error
1487: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
1488: -- FND_API.G_RET_STS_SUCCESS - for success
1489: --Notes:

Line 1527: -- Standard call to check for call compatibility.

1523: MODULE =>g_module_prefix||l_api_name,
1524: MESSAGE =>'10: Start API' ||l_api_name);
1525: END IF;
1526: END IF;
1527: -- Standard call to check for call compatibility.
1528: IF NOT FND_API.Compatible_API_Call (p_current_version_number=>l_api_version,
1529: p_caller_version_number =>p_api_version,
1530: p_api_name =>l_api_name,
1531: p_pkg_name =>G_PKG_NAME)

Line 1646: IF l_type_lookup_code = 'STANDARD' then

1642: -- Get Change for PO_total_amount for SPO
1643: -- The following query has an outer join based on the assumption that
1644: -- it is possible that only header was archived and the line was not
1645: -- since all the changes that happened were in Header only
1646: IF l_type_lookup_code = 'STANDARD' then
1647: -- get total amount for working copy of PO
1648: l_spo_amt := po_core_s.get_total(x_object_type=>'H',
1649: x_object_id =>p_doc_id);
1650: --get total amount for last archived version of PO

Line 1654: p_doc_subtype => 'STANDARD');

1650: --get total amount for last archived version of PO
1651: l_archived_spo_amt:=po_core_s.get_archive_total
1652: (p_object_id =>p_doc_id,
1653: p_doc_type => 'PO',
1654: p_doc_subtype => 'STANDARD');
1655: IF l_spo_amt <> l_archived_spo_amt THEN
1656: l_po_attrib_tbl(27) := 'OKC$B_PO_TOTAL_AMOUNT_TXN' ;
1657: --If amount for transaction currency has changed, then assume that amount in
1658: --Function currency Changed as well.

Line 1670: END IF;-- type_lookup_code='STANDARD'

1666: MODULE =>g_module_prefix||l_api_name,
1667: MESSAGE =>'150: Got header amount differnce');
1668: END IF;
1669: END IF;
1670: END IF;-- type_lookup_code='STANDARD'
1671: IF g_fnd_debug = 'Y' then
1672: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1673: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1674: MODULE =>g_module_prefix||l_api_name,

Line 1888: -- Standard Parameter. API version number expected by the caller

1884: -- have a value.
1885: --Parameters:
1886: --IN:
1887: --p_api_version
1888: -- Standard Parameter. API version number expected by the caller
1889: --p_init_msg_list
1890: -- Standard parameter.Initialize message list
1891: --p_doc_id
1892: -- PO header id

Line 1890: -- Standard parameter.Initialize message list

1886: --IN:
1887: --p_api_version
1888: -- Standard Parameter. API version number expected by the caller
1889: --p_init_msg_list
1890: -- Standard parameter.Initialize message list
1891: --p_doc_id
1892: -- PO header id
1893: --IN OUT:
1894: --p_sys_var_value_tbl

Line 1898: -- Standard parameter.Message count

1894: --p_sys_var_value_tbl
1895: -- A table of records to hold the system variable codes and values in working copy
1896: --OUT:
1897: --x_msg_count
1898: -- Standard parameter.Message count
1899: --x_msg_data
1900: -- Standard parameter.message data
1901: --x_return_status
1902: -- Standard parameter. Status Returned to calling API. Possible values are following

Line 1900: -- Standard parameter.message data

1896: --OUT:
1897: --x_msg_count
1898: -- Standard parameter.Message count
1899: --x_msg_data
1900: -- Standard parameter.message data
1901: --x_return_status
1902: -- Standard parameter. Status Returned to calling API. Possible values are following
1903: -- FND_API.G_RET_STS_ERROR - for expected error
1904: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error

Line 1902: -- Standard parameter. Status Returned to calling API. Possible values are following

1898: -- Standard parameter.Message count
1899: --x_msg_data
1900: -- Standard parameter.message data
1901: --x_return_status
1902: -- Standard parameter. Status Returned to calling API. Possible values are following
1903: -- FND_API.G_RET_STS_ERROR - for expected error
1904: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
1905: -- FND_API.G_RET_STS_SUCCESS - for success
1906: --Notes:

Line 1961: -- Standard call to check for call compatibility.

1957: MODULE =>g_module_prefix||l_api_name,
1958: MESSAGE =>'10: Start API' ||l_api_name);
1959: END IF;
1960: END IF;
1961: -- Standard call to check for call compatibility.
1962: IF NOT FND_API.Compatible_API_Call (p_current_version_number=>l_api_version,
1963: p_caller_version_number =>p_api_version,
1964: p_api_name =>l_api_name,
1965: p_pkg_name =>G_PKG_NAME)

Line 2216: ,decode(poh.type_lookup_code, 'STANDARD',l_po_total_amount,0)

2212: ,cuf.precision
2213: --Bug#3809298.Commenting out the below two calculations of funational
2214: --and transaction amounts as they will be replaced subsequently.
2215: /*Start of commenting for Bug#3809298 .
2216: ,decode(poh.type_lookup_code, 'STANDARD',l_po_total_amount,0)
2217: ,round(round(
2218: decode (poh.type_lookup_code,
2219: 'STANDARD',l_po_total_amount,0)
2220: * nvl(poh.rate,1)/nvl(cu.MINIMUM_ACCOUNTABLE_UNIT,1),decode(cu.MINIMUM_ACCOUNTABLE_UNIT,null,cu.precision,0)

Line 2219: 'STANDARD',l_po_total_amount,0)

2215: /*Start of commenting for Bug#3809298 .
2216: ,decode(poh.type_lookup_code, 'STANDARD',l_po_total_amount,0)
2217: ,round(round(
2218: decode (poh.type_lookup_code,
2219: 'STANDARD',l_po_total_amount,0)
2220: * nvl(poh.rate,1)/nvl(cu.MINIMUM_ACCOUNTABLE_UNIT,1),decode(cu.MINIMUM_ACCOUNTABLE_UNIT,null,cu.precision,0)
2221: ) * nvl(cu.MINIMUM_ACCOUNTABLE_UNIT,1) /
2222: nvl(cuf.MINIMUM_ACCOUNTABLE_UNIT,1),decode(cuf.MINIMUM_ACCOUNTABLE_UNIT,null,cuf.precision,0)
2223: )* nvl(cuf.MINIMUM_ACCOUNTABLE_UNIT,1) po_total_amount_func

Line 2327: --Bug#3809298.Check if the document type is "Standard"

2323: AND FP.set_of_books_id = gsb.set_of_books_id
2324: AND cuf.currency_code = gsb.currency_code
2325: ;
2326:
2327: --Bug#3809298.Check if the document type is "Standard"
2328: --If so then calculate the amount in functional and transaction currency.
2329: --If not assign zero those two.
2330: IF(l_poh_type_lookup_code='STANDARD')THEN
2331: l_po_total_amount :=po_core_s.get_total('H',p_doc_id);

Line 2330: IF(l_poh_type_lookup_code='STANDARD')THEN

2326:
2327: --Bug#3809298.Check if the document type is "Standard"
2328: --If so then calculate the amount in functional and transaction currency.
2329: --If not assign zero those two.
2330: IF(l_poh_type_lookup_code='STANDARD')THEN
2331: l_po_total_amount :=po_core_s.get_total('H',p_doc_id);
2332: l_po_attrib_tbl(12).variable_value_id :=l_po_total_amount;
2333: SELECT ROUND
2334: (

Line 2556: -- Standard Parameter. API version number expected by the caller

2552: -- This API will be called by Contracts to get the last signed document revision
2553: --Parameters:
2554: --IN:
2555: --p_api_version
2556: -- Standard Parameter. API version number expected by the caller
2557: --p_init_msg_list
2558: -- Standard parameter.Initialize message list
2559: --p_header_id
2560: -- PO header id

Line 2558: -- Standard parameter.Initialize message list

2554: --IN:
2555: --p_api_version
2556: -- Standard Parameter. API version number expected by the caller
2557: --p_init_msg_list
2558: -- Standard parameter.Initialize message list
2559: --p_header_id
2560: -- PO header id
2561: --p_revision_num
2562: -- Document Revision Number

Line 2565: -- Standard parameter.Message count

2561: --p_revision_num
2562: -- Document Revision Number
2563: --OUT:
2564: --x_msg_count
2565: -- Standard parameter.Message count
2566: --x_msg_data
2567: -- Standard parameter.message data
2568: --x_return_status
2569: -- Standard parameter. Status Returned to calling API. Possible values are following

Line 2567: -- Standard parameter.message data

2563: --OUT:
2564: --x_msg_count
2565: -- Standard parameter.Message count
2566: --x_msg_data
2567: -- Standard parameter.message data
2568: --x_return_status
2569: -- Standard parameter. Status Returned to calling API. Possible values are following
2570: -- FND_API.G_RET_STS_ERROR - for expected error
2571: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error

Line 2569: -- Standard parameter. Status Returned to calling API. Possible values are following

2565: -- Standard parameter.Message count
2566: --x_msg_data
2567: -- Standard parameter.message data
2568: --x_return_status
2569: -- Standard parameter. Status Returned to calling API. Possible values are following
2570: -- FND_API.G_RET_STS_ERROR - for expected error
2571: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
2572: -- FND_API.G_RET_STS_SUCCESS - for success
2573: --x_signed_records

Line 2809: IF l_document_type not in ('STANDARD', 'BLANKET','CONTRACT') OR

2805: l_org_id := null;
2806: End;
2807:
2808: -- Check the Contract terms auto Apply profile option value
2809: IF l_document_type not in ('STANDARD', 'BLANKET','CONTRACT') OR
2810: nvl(l_conterms_flag,'N') = 'Y' THEN
2811:
2812: l_progress := 40;
2813: IF g_debug_stmt THEN

Line 3036: IF p_doc_subtype NOT IN ('STANDARD', 'BLANKET', 'CONTRACT')

3032: RETURN;
3033: END IF;
3034:
3035: -- Check the Contract terms auto Apply profile option value
3036: IF p_doc_subtype NOT IN ('STANDARD', 'BLANKET', 'CONTRACT')
3037: OR NVL (p_conterms_exist_flag, 'N') = 'Y'
3038: THEN
3039: l_progress := 40;
3040:

Line 3214: IF p_doc_subtype NOT IN ('STANDARD', 'BLANKET', 'CONTRACT')

3210: BEGIN
3211:
3212:
3213: -- Check that the doc subtype is allowed.
3214: IF p_doc_subtype NOT IN ('STANDARD', 'BLANKET', 'CONTRACT')
3215: THEN
3216: l_progress := 20;
3217: IF g_debug_stmt
3218: THEN