APPS.OKC_XPRT_UTIL_PVT dependencies on OKC_XPRT_DEVIATIONS_T

Line 5238: FROM OKC_XPRT_DEVIATIONS_T

5234: RETURN VARCHAR2 is
5235:
5236: CURSOR csr_variable_value IS
5237: SELECT variable_value
5238: FROM OKC_XPRT_DEVIATIONS_T
5239: WHERE variable_code = p_object_code
5240: AND run_id = p_sequence_id
5241: AND variable_value is not null;
5242:

Line 5347: FROM OKC_XPRT_DEVIATIONS_T

5343: AND rownum < 2;
5344:
5345: CURSOR csr_variable_value(l_object_code VARCHAR2) IS
5346: SELECT variable_value
5347: FROM OKC_XPRT_DEVIATIONS_T
5348: WHERE variable_code = l_object_code
5349: AND (line_number = p_line_number or line_number = '-99')
5350: AND run_id = p_sequence_id
5351: AND variable_value is not null;

Line 5492: --get the document value from OKC_XPRT_DEVIATIONS_T

5488: END IF;
5489:
5490: --If object_type is VARIABLE then get the variable translated value as below
5491: Elsif (p_object_type = 'VARIABLE') THEN
5492: --get the document value from OKC_XPRT_DEVIATIONS_T
5493: --Find whether rule is at Header level or Line Level
5494: l_is_rule_line_level := is_rule_line_level(p_rule_id);
5495: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5496: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 5518: --in the form 'USER$variable_code' in OKC_XPRT_DEVIATIONS_T table.So we need to search on

5514: END IF;
5515: --Bug#5148503 If l_variable_value is null then check whether we can find variable_value
5516: --using 'USER$'||p_object_code instead of p_object_code
5517: --NOTE:In case of User Defined Variables,variable_code will be
5518: --in the form 'USER$variable_code' in OKC_XPRT_DEVIATIONS_T table.So we need to search on
5519: --'USER$'||p_object_code
5520: IF(l_variable_value is NUll) THEN
5521: OPEN csr_variable_value('USER$'||p_object_code);
5522: FETCH csr_variable_value INTO l_variable_value;

Line 5555: --in OKC_XPRT_DEVIATIONS_T then need to fetch translated value using dyanmic sql query as below

5551: '920: Translated Document Value = '||l_variable_translated_value);
5552: END IF;
5553:
5554: --If translated variable value is not available in CZ table and variable value is available only
5555: --in OKC_XPRT_DEVIATIONS_T then need to fetch translated value using dyanmic sql query as below
5556: IF(l_variable_value is not null and l_variable_translated_value is null) THEN
5557:
5558: -- Build the dynamic SQL for the valueset
5559: OPEN csr_value_set_tab;

Line 7484: FROM okc_xprt_deviations_t

7480: --
7481:
7482: CURSOR l_get_rul_variable_values_csr (p_line_number VARCHAR2, p_variable_id VARCHAR2) IS
7483: SELECT variable_value variable_value
7484: FROM okc_xprt_deviations_t
7485: WHERE variable_code = p_variable_id
7486: AND run_id = p_sequence_id;
7487: --AND line_number = p_line_number;
7488:

Line 8186: FROM okc_xprt_deviations_t

8182: --
8183: CURSOR l_line_item_details_csr (p_line_number VARCHAR2) IS
8184: SELECT item_id,
8185: org_id
8186: FROM okc_xprt_deviations_t
8187: WHERE line_number = p_line_number
8188: and run_id = p_sequence_id;
8189:
8190: BEGIN

Line 8730: INSERT INTO OKC_XPRT_DEVIATIONS_T

8726:
8727:
8728: -- Insert header variables into okc_xprt_deviations_gt
8729:
8730: INSERT INTO OKC_XPRT_DEVIATIONS_T
8731: (
8732: RUN_ID,
8733: LINE_NUMBER,
8734: VARIABLE_CODE,

Line 8783: -- Insert line variables into okc_xprt_deviations_t

8779: G_MODULE||l_api_name,
8780: '129: l_line_sysvar_value_tbl( '|| i || ').org_id :' || l_line_sysvar_value_tbl(i).org_id);
8781: END IF;
8782:
8783: -- Insert line variables into okc_xprt_deviations_t
8784:
8785: INSERT INTO OKC_XPRT_DEVIATIONS_T
8786: (
8787: RUN_ID,

Line 8785: INSERT INTO OKC_XPRT_DEVIATIONS_T

8781: END IF;
8782:
8783: -- Insert line variables into okc_xprt_deviations_t
8784:
8785: INSERT INTO OKC_XPRT_DEVIATIONS_T
8786: (
8787: RUN_ID,
8788: LINE_NUMBER,
8789: VARIABLE_CODE,