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 PO_HEADERS_ALL

Line 694: -- PO_headers_all if p_lock_flag parameter is set to Y

690: -- rollback to release the lock
691: --Modifies:
692: -- None.
693: --Locks:
694: -- PO_headers_all if p_lock_flag parameter is set to Y
695: --Function:
696: -- This procedure is called by Contracts team to determine whether
697: -- the Purchase Order against which terms will be saved is in updatable
698: -- status or not. This API will compare the passed in status and version to

Line 719: -- tells whether po_headers_all be locked for the record

715: -- : Employee id
716: -- Note that the above parameters should always be concatenated in the same order with no extra spaces around
717: -- Status and revision are always expected to be there. For Employee Id pass 'Null' if status is not 'IN PROCESS'
718: --p_lock_flag
719: -- tells whether po_headers_all be locked for the record
720: --OUT:
721: --x_update_allowed
722: -- Returns Y or N depending PO is in updatable status or not
723: --x_msg_count

Line 768: l_callout_status PO_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;

764: x_msg_count OUT NOCOPY NUMBER
765: ) IS
766: l_api_name CONSTANT VARCHAR(30) := 'IS_PO_UPDATE_ALLOWED';
767: l_api_version CONSTANT NUMBER := 1.0;
768: l_callout_status PO_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;
769: l_callout_revision PO_HEADERS_ALL.REVISION_NUM%TYPE;
770: l_po_status PO_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;
771: l_po_revision PO_HEADERS_ALL.REVISION_NUM%TYPE;
772:

Line 769: l_callout_revision PO_HEADERS_ALL.REVISION_NUM%TYPE;

765: ) IS
766: l_api_name CONSTANT VARCHAR(30) := 'IS_PO_UPDATE_ALLOWED';
767: l_api_version CONSTANT NUMBER := 1.0;
768: l_callout_status PO_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;
769: l_callout_revision PO_HEADERS_ALL.REVISION_NUM%TYPE;
770: l_po_status PO_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;
771: l_po_revision PO_HEADERS_ALL.REVISION_NUM%TYPE;
772:
773: l_emp_id NUMBER;

Line 770: l_po_status PO_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;

766: l_api_name CONSTANT VARCHAR(30) := 'IS_PO_UPDATE_ALLOWED';
767: l_api_version CONSTANT NUMBER := 1.0;
768: l_callout_status PO_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;
769: l_callout_revision PO_HEADERS_ALL.REVISION_NUM%TYPE;
770: l_po_status PO_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;
771: l_po_revision PO_HEADERS_ALL.REVISION_NUM%TYPE;
772:
773: l_emp_id NUMBER;
774: l_emp VARCHAR2(100);

Line 771: l_po_revision PO_HEADERS_ALL.REVISION_NUM%TYPE;

767: l_api_version CONSTANT NUMBER := 1.0;
768: l_callout_status PO_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;
769: l_callout_revision PO_HEADERS_ALL.REVISION_NUM%TYPE;
770: l_po_status PO_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;
771: l_po_revision PO_HEADERS_ALL.REVISION_NUM%TYPE;
772:
773: l_emp_id NUMBER;
774: l_emp VARCHAR2(100);
775: l_doc_type_code PO_DOCUMENT_TYPES_ALL_B.DOCUMENT_SUBTYPE%TYPE;

Line 909: FROM po_headers_all

905: SELECT nvl(authorization_status,'INCOMPLETE'), revision_num, type_lookup_code
906: ,DECODE(type_lookup_code,'STANDARD','PO','BLANKET','PA','CONTRACT','PA',null)
907: INTO l_po_status,l_po_revision, l_doc_type_code
908: ,l_document_type
909: FROM po_headers_all
910: WHERE po_header_id = p_header_id;
911: ELSE -- CLM Mod
912: SELECT nvl(authorization_status,'INCOMPLETE'), revision_num, type_lookup_code
913: ,DECODE(type_lookup_code,'STANDARD','PO','BLANKET','PA','CONTRACT','PA',null)

Line 1185: -- rollback to release the lock on Po_headers_all unless p_commit is set to Y

1181: --Pre-reqs:
1182: -- 1.DONOT Use this API from wherever Functional Security Check is needed. This API
1183: -- Assumes that the org context is already set
1184: -- 2.when this API is called, the calling API is expected to commit or
1185: -- rollback to release the lock on Po_headers_all unless p_commit is set to Y
1186: --Modifies:
1187: -- PO_headers_ALL. The following Columns will be modified
1188: -- CONTERMS_EXIST_FLAG
1189: -- CONTERMS_ARTICLES_UPD_DATE

Line 1187: -- PO_headers_ALL. The following Columns will be modified

1183: -- Assumes that the org context is already set
1184: -- 2.when this API is called, the calling API is expected to commit or
1185: -- rollback to release the lock on Po_headers_all unless p_commit is set to Y
1186: --Modifies:
1187: -- PO_headers_ALL. The following Columns will be modified
1188: -- CONTERMS_EXIST_FLAG
1189: -- CONTERMS_ARTICLES_UPD_DATE
1190: -- CONTERMS_DELIV_UPD_DATE
1191: --Locks:

Line 1192: -- PO_headers_all

1188: -- CONTERMS_EXIST_FLAG
1189: -- CONTERMS_ARTICLES_UPD_DATE
1190: -- CONTERMS_DELIV_UPD_DATE
1191: --Locks:
1192: -- PO_headers_all
1193: --Function:
1194: -- This API will be called by Contracts when user attaches or deletes a template
1195: -- from a purchasing document. This API will first check if Po is in updatable status. If yes
1196: -- It will update the conterms fields in po_headers_all based on the action taken in contracts

Line 1196: -- It will update the conterms fields in po_headers_all based on the action taken in contracts

1192: -- PO_headers_all
1193: --Function:
1194: -- This API will be called by Contracts when user attaches or deletes a template
1195: -- from a purchasing document. This API will first check if Po is in updatable status. If yes
1196: -- It will update the conterms fields in po_headers_all based on the action taken in contracts
1197: -- Contracts will populate parameter p_template_changed to Y when this API is called
1198: -- after a new template is attached to PO. Contracts will populate parameter p_template_changed to D when
1199: -- this API is called after template is removed.
1200:

Line 1279: l_callout_status PO_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;

1275: l_update_not_allowed EXCEPTION;
1276: l_date DATE;
1277: l_conterms_exist_flag VARCHAR2(1);
1278:
1279: l_callout_status PO_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;
1280: l_callout_revision PO_HEADERS_ALL.REVISION_NUM%TYPE;
1281: l_old_conterms_flag VARCHAR2(1); -- <11i10+ Contracts ER Migrate PO>
1282: l_start NUMBER;
1283: l_end NUMBER;

Line 1280: l_callout_revision PO_HEADERS_ALL.REVISION_NUM%TYPE;

1276: l_date DATE;
1277: l_conterms_exist_flag VARCHAR2(1);
1278:
1279: l_callout_status PO_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;
1280: l_callout_revision PO_HEADERS_ALL.REVISION_NUM%TYPE;
1281: l_old_conterms_flag VARCHAR2(1); -- <11i10+ Contracts ER Migrate PO>
1282: l_start NUMBER;
1283: l_end NUMBER;
1284: l_is_mod VARCHAR2(1) := 'N'; -- CLM Mod

Line 1399: FROM PO_HEADERS_ALL poh

1395:
1396: IF l_is_mod = 'N' THEN -- CLM Mod
1397: SELECT poh.conterms_exist_flag
1398: INTO l_old_conterms_flag
1399: FROM PO_HEADERS_ALL poh
1400: WHERE poh.po_header_id = p_header_id;
1401: ELSE -- CLM Mod
1402: SELECT poh.conterms_exist_flag
1403: INTO l_old_conterms_flag

Line 1477: -- SQL WHAT-Update the conterms_exist_flag and the contract terms dates in po_headers_all

1473: End if;
1474: END IF;
1475:
1476: IF l_is_mod = 'N' THEN --CLM Mod
1477: -- SQL WHAT-Update the conterms_exist_flag and the contract terms dates in po_headers_all
1478: -- SQL WHY - Update the flag based on if contract terms template attached or removed
1479: -- SQL JOIN- None
1480: Update po_headers_all
1481: Set conterms_exist_flag = l_conterms_exist_flag,

Line 1480: Update po_headers_all

1476: IF l_is_mod = 'N' THEN --CLM Mod
1477: -- SQL WHAT-Update the conterms_exist_flag and the contract terms dates in po_headers_all
1478: -- SQL WHY - Update the flag based on if contract terms template attached or removed
1479: -- SQL JOIN- None
1480: Update po_headers_all
1481: Set conterms_exist_flag = l_conterms_exist_flag,
1482: Conterms_articles_upd_date = l_date,
1483: Conterms_DELIV_upd_date = l_date,
1484: Last_update_date = sysdate,

Line 1489: -- SQL WHAT-Update the conterms_exist_flag and the contract terms dates in po_headers_all

1485: Last_updated_by = FND_GLOBAl.USER_ID,
1486: Last_update_login = FND_GLOBAL.LOGIN_ID
1487: WHERE po_header_id= p_header_id;
1488: ELSE --CLM Mod
1489: -- SQL WHAT-Update the conterms_exist_flag and the contract terms dates in po_headers_all
1490: -- SQL WHY - Update the flag based on if contract terms template attached or removed
1491: -- SQL JOIN- None
1492: Update po_headers_draft_all
1493: Set conterms_exist_flag = l_conterms_exist_flag,

Line 1506: MESSAGE =>'300:Po headers all updated for header id'||p_header_id);

1502: IF g_fnd_debug = 'Y' then
1503: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1504: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1505: MODULE =>g_module_prefix||l_api_name,
1506: MESSAGE =>'300:Po headers all updated for header id'||p_header_id);
1507: END IF;
1508: End if;
1509:
1510: ELSE -- if p_template_changed other than Y or D

Line 1679: l_type_lookup_code po_headers_all.type_lookup_code%type;

1675: x_msg_count OUT NOCOPY NUMBER
1676: ) IS
1677: l_api_name CONSTANT VARCHAR(30) := 'Attribute_value_changed';
1678: l_api_version CONSTANT NUMBER := 1.0;
1679: l_type_lookup_code po_headers_all.type_lookup_code%type;
1680: -- the length varchar40 fixed with the assumption that the length of variable code
1681: -- will not exceed this. For using %type, dependence on OKC tables. Consider for refactor
1682: l_po_attrib_tbl VARIABLE_CODE_TBL_TYPE;
1683: l_sys_var_index BINARY_INTEGER;

Line 1804: po_headers_all poh

1800: ,l_type_lookup_code
1801: ,l_po_attrib_tbl(29) --
1802:
1803: FROM
1804: po_headers_all poh
1805: ,po_headers_archive_all poha
1806: WHERE poh.po_header_id = p_doc_id
1807: AND poh.po_header_id = poha.po_header_id
1808: AND poha.latest_external_flag = 'Y';

Line 2114: l_type_lookup_code po_headers_all.type_lookup_code%type;

2110: x_msg_count OUT NOCOPY NUMBER) IS
2111:
2112: l_api_name CONSTANT VARCHAR(30) := 'Get_PO_Attribute_values';
2113: l_api_version CONSTANT NUMBER := 1.0;
2114: l_type_lookup_code po_headers_all.type_lookup_code%type;
2115: -- the length varchar40 fixed with the assumption that the length of variable code
2116: -- will not exceed this. For using %type, dependence on OKC tables. Consider for refactor
2117: l_po_attrib_tbl VARIABLE_VALUE_TBL_TYPE;
2118: l_sys_var_index BINARY_INTEGER;

Line 2511: po_headers_all poh

2507: ,l_po_attrib_tbl(87).variable_value_id --
2508: ,l_po_attrib_tbl(88).variable_value_id --
2509:
2510: FROM
2511: po_headers_all poh
2512: ,FINANCIALS_SYSTEM_PARAMS_ALL FP
2513: ,FND_CURRENCIES_VL CU
2514: ,GL_SETS_OF_BOOKS gsb
2515: ,FND_CURRENCIES_VL cuf

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

2931: IS
2932: l_api_name CONSTANT VARCHAR2(30) := 'get_last_signed_revision';
2933: l_api_version CONSTANT NUMBER := 1.0;
2934:
2935: l_archived_conterms_flag PO_headers_all.conterms_exist_Flag%Type :='N';
2936: l_signed_revision_num NUMBER;
2937: l_signed_records VARCHAR2(1);
2938: l_is_mod VARCHAR2(1) := 'N'; -- CLM Mod
2939:

Line 3075: l_document_type PO_HEADERS_ALL.type_lookup_code%TYPE;

3071: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;
3072: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;
3073: l_template_desc OKC_TERMS_TEMPLATES_ALL.description%TYPE;
3074: l_k_doc_type VARCHAR2(240);
3075: l_document_type PO_HEADERS_ALL.type_lookup_code%TYPE;
3076: l_doc_number PO_HEADERS_ALL.segment1%TYPE; -- Bug 4096095
3077: l_agent_id PO_HEADERS_ALL.agent_id%TYPE; -- Bug 4096095
3078: l_vendor_id PO_HEADERS_ALL.vendor_id%TYPE; -- Bug 4096095
3079: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE; -- Bug 4096095

Line 3076: l_doc_number PO_HEADERS_ALL.segment1%TYPE; -- Bug 4096095

3072: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;
3073: l_template_desc OKC_TERMS_TEMPLATES_ALL.description%TYPE;
3074: l_k_doc_type VARCHAR2(240);
3075: l_document_type PO_HEADERS_ALL.type_lookup_code%TYPE;
3076: l_doc_number PO_HEADERS_ALL.segment1%TYPE; -- Bug 4096095
3077: l_agent_id PO_HEADERS_ALL.agent_id%TYPE; -- Bug 4096095
3078: l_vendor_id PO_HEADERS_ALL.vendor_id%TYPE; -- Bug 4096095
3079: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE; -- Bug 4096095
3080: l_status PO_HEADERS_ALL.authorization_status%TYPE;

Line 3077: l_agent_id PO_HEADERS_ALL.agent_id%TYPE; -- Bug 4096095

3073: l_template_desc OKC_TERMS_TEMPLATES_ALL.description%TYPE;
3074: l_k_doc_type VARCHAR2(240);
3075: l_document_type PO_HEADERS_ALL.type_lookup_code%TYPE;
3076: l_doc_number PO_HEADERS_ALL.segment1%TYPE; -- Bug 4096095
3077: l_agent_id PO_HEADERS_ALL.agent_id%TYPE; -- Bug 4096095
3078: l_vendor_id PO_HEADERS_ALL.vendor_id%TYPE; -- Bug 4096095
3079: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE; -- Bug 4096095
3080: l_status PO_HEADERS_ALL.authorization_status%TYPE;
3081: l_conterms_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;

Line 3078: l_vendor_id PO_HEADERS_ALL.vendor_id%TYPE; -- Bug 4096095

3074: l_k_doc_type VARCHAR2(240);
3075: l_document_type PO_HEADERS_ALL.type_lookup_code%TYPE;
3076: l_doc_number PO_HEADERS_ALL.segment1%TYPE; -- Bug 4096095
3077: l_agent_id PO_HEADERS_ALL.agent_id%TYPE; -- Bug 4096095
3078: l_vendor_id PO_HEADERS_ALL.vendor_id%TYPE; -- Bug 4096095
3079: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE; -- Bug 4096095
3080: l_status PO_HEADERS_ALL.authorization_status%TYPE;
3081: l_conterms_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
3082: l_revision PO_HEADERS_ALL.revision_num%TYPE;

Line 3079: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE; -- Bug 4096095

3075: l_document_type PO_HEADERS_ALL.type_lookup_code%TYPE;
3076: l_doc_number PO_HEADERS_ALL.segment1%TYPE; -- Bug 4096095
3077: l_agent_id PO_HEADERS_ALL.agent_id%TYPE; -- Bug 4096095
3078: l_vendor_id PO_HEADERS_ALL.vendor_id%TYPE; -- Bug 4096095
3079: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE; -- Bug 4096095
3080: l_status PO_HEADERS_ALL.authorization_status%TYPE;
3081: l_conterms_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
3082: l_revision PO_HEADERS_ALL.revision_num%TYPE;
3083: l_org_id PO_HEADERS_ALL.org_id%TYPE;

Line 3080: l_status PO_HEADERS_ALL.authorization_status%TYPE;

3076: l_doc_number PO_HEADERS_ALL.segment1%TYPE; -- Bug 4096095
3077: l_agent_id PO_HEADERS_ALL.agent_id%TYPE; -- Bug 4096095
3078: l_vendor_id PO_HEADERS_ALL.vendor_id%TYPE; -- Bug 4096095
3079: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE; -- Bug 4096095
3080: l_status PO_HEADERS_ALL.authorization_status%TYPE;
3081: l_conterms_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
3082: l_revision PO_HEADERS_ALL.revision_num%TYPE;
3083: l_org_id PO_HEADERS_ALL.org_id%TYPE;
3084: l_msg_data VARCHAR2(2000);

Line 3081: l_conterms_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;

3077: l_agent_id PO_HEADERS_ALL.agent_id%TYPE; -- Bug 4096095
3078: l_vendor_id PO_HEADERS_ALL.vendor_id%TYPE; -- Bug 4096095
3079: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE; -- Bug 4096095
3080: l_status PO_HEADERS_ALL.authorization_status%TYPE;
3081: l_conterms_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
3082: l_revision PO_HEADERS_ALL.revision_num%TYPE;
3083: l_org_id PO_HEADERS_ALL.org_id%TYPE;
3084: l_msg_data VARCHAR2(2000);
3085: l_msg_count NUMBER;

Line 3082: l_revision PO_HEADERS_ALL.revision_num%TYPE;

3078: l_vendor_id PO_HEADERS_ALL.vendor_id%TYPE; -- Bug 4096095
3079: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE; -- Bug 4096095
3080: l_status PO_HEADERS_ALL.authorization_status%TYPE;
3081: l_conterms_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
3082: l_revision PO_HEADERS_ALL.revision_num%TYPE;
3083: l_org_id PO_HEADERS_ALL.org_id%TYPE;
3084: l_msg_data VARCHAR2(2000);
3085: l_msg_count NUMBER;
3086:

Line 3083: l_org_id PO_HEADERS_ALL.org_id%TYPE;

3079: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE; -- Bug 4096095
3080: l_status PO_HEADERS_ALL.authorization_status%TYPE;
3081: l_conterms_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
3082: l_revision PO_HEADERS_ALL.revision_num%TYPE;
3083: l_org_id PO_HEADERS_ALL.org_id%TYPE;
3084: l_msg_data VARCHAR2(2000);
3085: l_msg_count NUMBER;
3086:
3087: l_progress NUMBER := 0;

Line 3146: FROM po_headers_all poh

3142: l_vendor_id,
3143: l_vendor_site_id,
3144: l_agent_id,
3145: l_conterms_flag
3146: FROM po_headers_all poh
3147: WHERE poh.po_header_id = p_document_id;
3148: Exception
3149: When others then
3150: l_document_type := null;

Line 3348: l_document_type PO_HEADERS_ALL.type_lookup_code%TYPE;

3344:
3345: l_api_name CONSTANT VARCHAR2(30) := 'Copy_ConTerms_Mod';
3346: l_log_head CONSTANT VARCHAR2(100) := g_log_head||l_api_name;
3347:
3348: l_document_type PO_HEADERS_ALL.type_lookup_code%TYPE;
3349: l_doc_number PO_HEADERS_ALL.segment1%TYPE; -- Bug 4096095
3350: l_conterms_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
3351: l_conterms_flag_mod PO_HEADERS_ALL.conterms_exist_flag%TYPE;
3352: l_msg_data VARCHAR2(2000);

Line 3349: l_doc_number PO_HEADERS_ALL.segment1%TYPE; -- Bug 4096095

3345: l_api_name CONSTANT VARCHAR2(30) := 'Copy_ConTerms_Mod';
3346: l_log_head CONSTANT VARCHAR2(100) := g_log_head||l_api_name;
3347:
3348: l_document_type PO_HEADERS_ALL.type_lookup_code%TYPE;
3349: l_doc_number PO_HEADERS_ALL.segment1%TYPE; -- Bug 4096095
3350: l_conterms_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
3351: l_conterms_flag_mod PO_HEADERS_ALL.conterms_exist_flag%TYPE;
3352: l_msg_data VARCHAR2(2000);
3353: l_msg_count NUMBER;

Line 3350: l_conterms_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;

3346: l_log_head CONSTANT VARCHAR2(100) := g_log_head||l_api_name;
3347:
3348: l_document_type PO_HEADERS_ALL.type_lookup_code%TYPE;
3349: l_doc_number PO_HEADERS_ALL.segment1%TYPE; -- Bug 4096095
3350: l_conterms_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
3351: l_conterms_flag_mod PO_HEADERS_ALL.conterms_exist_flag%TYPE;
3352: l_msg_data VARCHAR2(2000);
3353: l_msg_count NUMBER;
3354: l_k_doc_type_source VARCHAR2(240);

Line 3351: l_conterms_flag_mod PO_HEADERS_ALL.conterms_exist_flag%TYPE;

3347:
3348: l_document_type PO_HEADERS_ALL.type_lookup_code%TYPE;
3349: l_doc_number PO_HEADERS_ALL.segment1%TYPE; -- Bug 4096095
3350: l_conterms_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
3351: l_conterms_flag_mod PO_HEADERS_ALL.conterms_exist_flag%TYPE;
3352: l_msg_data VARCHAR2(2000);
3353: l_msg_count NUMBER;
3354: l_k_doc_type_source VARCHAR2(240);
3355: l_k_doc_type_target VARCHAR2(240);

Line 3401: FROM po_headers_all poh

3397: nvl(poh.conterms_exist_flag, 'N')
3398: INTO l_document_type,
3399: l_doc_number,
3400: l_conterms_flag
3401: FROM po_headers_all poh
3402: WHERE poh.po_header_id = p_document_id;
3403: Exception
3404: When others then
3405: l_document_type := null;

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

3926: ------------------------------------------------------------------------------
3927: FUNCTION get_archive_conterms_flag (p_po_header_id IN NUMBER)
3928: RETURN VARCHAR2 IS
3929:
3930: l_archived_conterms_flag PO_headers_all.conterms_exist_Flag%Type :='N';
3931:
3932: BEGIN
3933: -- SQL What: Query to check if the last archived version had conterms
3934: -- SQL Why: To check if the conterms were applied to the last archived rev