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.

[Home] [Help]

APPS.PO_SOURCING_PVT dependencies on STANDARD

Line 83: phi.clm_standard_form,

79: phi.global_agreement_flag,
80: phi.shipping_control,
81: phi.org_id,
82: phi.clm_award_type,
83: phi.clm_standard_form,
84: phi.clm_document_format,
85: phi.umbrella_program_id --umbrella program
86: FROM po_headers_interface phi
87: WHERE phi.interface_header_id = p_interface_header_id;

Line 321: -- The standard OUT parameter giving return status of the API call.

317: --IN:
318: -- None
319: --OUT:
320: --x_return_status
321: -- The standard OUT parameter giving return status of the API call.
322: -- FND_API.G_RET_STS_ERROR - for expected error
323: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
324: -- FND_API.G_RET_STS_SUCCESS - for success
325: --Notes:

Line 603: -- The standard OUT parameter giving return status of the API call.

599: --IN:
600: -- None
601: --OUT:
602: --x_return_status
603: -- The standard OUT parameter giving return status of the API call.
604: -- FND_API.G_RET_STS_ERROR - for expected error
605: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
606: -- FND_API.G_RET_STS_SUCCESS - for success
607: --Notes:

Line 830: -- The standard OUT parameter giving return status of the API call.

826: -- The unique identifier for the newly created document.
827: --x_document_number
828: -- The document number that would uniquely identify a document in a given organization.
829: --x_return_status
830: -- The standard OUT parameter giving return status of the API call.
831: -- FND_API.G_RET_STS_ERROR - for expected error
832: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
833: -- FND_API.G_RET_STS_SUCCESS - for success
834: --Notes:

Line 881: l_standard_form VARCHAR2(200);

877:
878: l_uda_template_exception EXCEPTION;
879:
880: -- Document Format
881: l_standard_form VARCHAR2(200);
882: l_document_format VARCHAR2(200);
883:
884: -- AME
885: l_ame_approval_id po_headers_all.ame_approval_id%TYPE;

Line 1116: -- Getting Standard Form and Document Format of the output document

1112: p_message => 'After getting the UDA template id: ' ||x_template_id
1113: );
1114: END IF;
1115:
1116: -- Getting Standard Form and Document Format of the output document
1117: BEGIN
1118: --Validating the standard_form and document_format in interface
1119: SELECT standard_form,
1120: document_format

Line 1118: --Validating the standard_form and document_format in interface

1114: END IF;
1115:
1116: -- Getting Standard Form and Document Format of the output document
1117: BEGIN
1118: --Validating the standard_form and document_format in interface
1119: SELECT standard_form,
1120: document_format
1121: INTO l_standard_form,
1122: l_document_format

Line 1119: SELECT standard_form,

1115:
1116: -- Getting Standard Form and Document Format of the output document
1117: BEGIN
1118: --Validating the standard_form and document_format in interface
1119: SELECT standard_form,
1120: document_format
1121: INTO l_standard_form,
1122: l_document_format
1123: FROM po_print_form_formats

Line 1121: INTO l_standard_form,

1117: BEGIN
1118: --Validating the standard_form and document_format in interface
1119: SELECT standard_form,
1120: document_format
1121: INTO l_standard_form,
1122: l_document_format
1123: FROM po_print_form_formats
1124: WHERE NVL(inactive_date, SYSDATE+1) > SYSDATE
1125: AND standard_form = g_cpa_csr.clm_standard_form

Line 1125: AND standard_form = g_cpa_csr.clm_standard_form

1121: INTO l_standard_form,
1122: l_document_format
1123: FROM po_print_form_formats
1124: WHERE NVL(inactive_date, SYSDATE+1) > SYSDATE
1125: AND standard_form = g_cpa_csr.clm_standard_form
1126: AND document_format = g_cpa_csr.clm_document_format;
1127:
1128: EXCEPTION
1129: WHEN No_Data_Found THEN

Line 1131: --Defaulting standard_form and document_format

1127:
1128: EXCEPTION
1129: WHEN No_Data_Found THEN
1130: BEGIN
1131: --Defaulting standard_form and document_format
1132: SELECT standard_form,
1133: document_format
1134: INTO l_standard_form,
1135: l_document_format

Line 1132: SELECT standard_form,

1128: EXCEPTION
1129: WHEN No_Data_Found THEN
1130: BEGIN
1131: --Defaulting standard_form and document_format
1132: SELECT standard_form,
1133: document_format
1134: INTO l_standard_form,
1135: l_document_format
1136: FROM po_print_form_formats

Line 1134: INTO l_standard_form,

1130: BEGIN
1131: --Defaulting standard_form and document_format
1132: SELECT standard_form,
1133: document_format
1134: INTO l_standard_form,
1135: l_document_format
1136: FROM po_print_form_formats
1137: WHERE NVL(inactive_date, SYSDATE+1) > SYSDATE
1138: AND default_flag = 'Y'

Line 1144: l_standard_form := NULL;

1140: AND document_type = 'PO_IDV_STD_FORM';
1141:
1142: EXCEPTION
1143: WHEN No_Data_Found THEN
1144: l_standard_form := NULL;
1145: l_document_format := NULL;
1146: WHEN OTHERS THEN
1147: l_standard_form := NULL;
1148: l_document_format := NULL;

Line 1147: l_standard_form := NULL;

1143: WHEN No_Data_Found THEN
1144: l_standard_form := NULL;
1145: l_document_format := NULL;
1146: WHEN OTHERS THEN
1147: l_standard_form := NULL;
1148: l_document_format := NULL;
1149: END;
1150: WHEN OTHERS THEN
1151: l_standard_form := NULL;

Line 1151: l_standard_form := NULL;

1147: l_standard_form := NULL;
1148: l_document_format := NULL;
1149: END;
1150: WHEN OTHERS THEN
1151: l_standard_form := NULL;
1152: l_document_format := NULL;
1153: END;
1154:
1155:

Line 1161: clm_standard_form = l_standard_form,

1157: UPDATE PO_HEADERS_ALL
1158: SET uda_template_id = x_template_id,
1159: uda_template_date = SYSDATE,
1160: style_id = g_style_id,
1161: clm_standard_form = l_standard_form,
1162: clm_document_format = l_document_format,
1163: clm_award_type = g_cpa_csr.clm_award_type
1164: WHERE po_header_id = l_po_header_id;
1165:

Line 1655: -- The standard OUT parameter giving return status of the API call.

1651: -- The unique identifier for the newly created document.
1652: --x_document_number
1653: -- The document number that would uniquely identify a document in a given organization.
1654: --x_return_status
1655: -- The standard OUT parameter giving return status of the API call.
1656: -- FND_API.G_RET_STS_ERROR - for expected error
1657: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
1658: -- FND_API.G_RET_STS_SUCCESS - for success
1659: --Notes:

Line 1952: -- The standard OUT parameter giving return status of the API call.

1948: --p_interface_header_id
1949: -- The id that will be used to uniquely identify a row in the PO_HEADERS_INTERFACE table
1950: --OUT:
1951: --x_return_status
1952: -- The standard OUT parameter giving return status of the API call.
1953: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
1954: -- FND_API.G_RET_STS_SUCCESS - for success
1955: --Notes:
1956: -- None