APPS.OKC_XPRT_UTIL_PVT dependencies on OKC_XPRT_DEVIATIONS_T

Line 5040: FROM OKC_XPRT_DEVIATIONS_T

5036: RETURN VARCHAR2 is
5037:
5038: CURSOR csr_variable_value IS
5039: SELECT variable_value
5040: FROM OKC_XPRT_DEVIATIONS_T
5041: WHERE variable_code = p_object_code
5042: AND run_id = p_sequence_id
5043: AND variable_value is not null;
5044:

Line 5149: FROM OKC_XPRT_DEVIATIONS_T

5145: AND rownum < 2;
5146:
5147: CURSOR csr_variable_value(l_object_code VARCHAR2) IS
5148: SELECT variable_value
5149: FROM OKC_XPRT_DEVIATIONS_T
5150: WHERE variable_code = l_object_code
5151: AND (line_number = p_line_number or line_number = '-99')
5152: AND run_id = p_sequence_id
5153: AND variable_value is not null;

Line 5294: --get the document value from OKC_XPRT_DEVIATIONS_T

5290: END IF;
5291:
5292: --If object_type is VARIABLE then get the variable translated value as below
5293: Elsif (p_object_type = 'VARIABLE') THEN
5294: --get the document value from OKC_XPRT_DEVIATIONS_T
5295: --Find whether rule is at Header level or Line Level
5296: l_is_rule_line_level := is_rule_line_level(p_rule_id);
5297: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5298: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

5316: END IF;
5317: --Bug#5148503 If l_variable_value is null then check whether we can find variable_value
5318: --using 'USER$'||p_object_code instead of p_object_code
5319: --NOTE:In case of User Defined Variables,variable_code will be
5320: --in the form 'USER$variable_code' in OKC_XPRT_DEVIATIONS_T table.So we need to search on
5321: --'USER$'||p_object_code
5322: IF(l_variable_value is NUll) THEN
5323: OPEN csr_variable_value('USER$'||p_object_code);
5324: FETCH csr_variable_value INTO l_variable_value;

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

5353: '920: Translated Document Value = '||l_variable_translated_value);
5354: END IF;
5355:
5356: --If translated variable value is not available in CZ table and variable value is available only
5357: --in OKC_XPRT_DEVIATIONS_T then need to fetch translated value using dyanmic sql query as below
5358: IF(l_variable_value is not null and l_variable_translated_value is null) THEN
5359:
5360: -- Build the dynamic SQL for the valueset
5361: OPEN csr_value_set_tab;

Line 7201: FROM okc_xprt_deviations_t

7197: --
7198:
7199: CURSOR l_get_rul_variable_values_csr (p_line_number VARCHAR2, p_variable_id VARCHAR2) IS
7200: SELECT variable_value variable_value
7201: FROM okc_xprt_deviations_t
7202: WHERE variable_code = p_variable_id
7203: AND run_id = p_sequence_id;
7204: --AND line_number = p_line_number;
7205:

Line 7859: FROM okc_xprt_deviations_t

7855: --
7856: CURSOR l_line_item_details_csr (p_line_number VARCHAR2) IS
7857: SELECT item_id,
7858: org_id
7859: FROM okc_xprt_deviations_t
7860: WHERE line_number = p_line_number
7861: and run_id = p_sequence_id;
7862:
7863: BEGIN

Line 8403: INSERT INTO OKC_XPRT_DEVIATIONS_T

8399:
8400:
8401: -- Insert header variables into okc_xprt_deviations_gt
8402:
8403: INSERT INTO OKC_XPRT_DEVIATIONS_T
8404: (
8405: RUN_ID,
8406: LINE_NUMBER,
8407: VARIABLE_CODE,

Line 8456: -- Insert line variables into okc_xprt_deviations_t

8452: G_MODULE||l_api_name,
8453: '129: l_line_sysvar_value_tbl( '|| i || ').org_id :' || l_line_sysvar_value_tbl(i).org_id);
8454: END IF;
8455:
8456: -- Insert line variables into okc_xprt_deviations_t
8457:
8458: INSERT INTO OKC_XPRT_DEVIATIONS_T
8459: (
8460: RUN_ID,

Line 8458: INSERT INTO OKC_XPRT_DEVIATIONS_T

8454: END IF;
8455:
8456: -- Insert line variables into okc_xprt_deviations_t
8457:
8458: INSERT INTO OKC_XPRT_DEVIATIONS_T
8459: (
8460: RUN_ID,
8461: LINE_NUMBER,
8462: VARIABLE_CODE,