APPS.OEXCPSVR dependencies on STANDARD

Line 13: INSERT INTO SO_STANDARD_VALUE_RULES

9: )
10:
11: IS
12: BEGIN
13: INSERT INTO SO_STANDARD_VALUE_RULES
14: ( STANDARD_VALUE_RULE_ID
15: , CREATION_DATE
16: , CREATED_BY
17: , LAST_UPDATE_DATE

Line 14: ( STANDARD_VALUE_RULE_ID

10:
11: IS
12: BEGIN
13: INSERT INTO SO_STANDARD_VALUE_RULES
14: ( STANDARD_VALUE_RULE_ID
15: , CREATION_DATE
16: , CREATED_BY
17: , LAST_UPDATE_DATE
18: , LAST_UPDATED_BY

Line 20: , STANDARD_VALUE_RULE_SET_ID

16: , CREATED_BY
17: , LAST_UPDATE_DATE
18: , LAST_UPDATED_BY
19: , LAST_UPDATE_LOGIN
20: , STANDARD_VALUE_RULE_SET_ID
21: , ATTRIBUTE_ID
22: , SEQUENCE_NUMBER
23: , STANDARD_VALUE_SOURCE_ID
24: , ATTRIBUTE_VALUE

Line 23: , STANDARD_VALUE_SOURCE_ID

19: , LAST_UPDATE_LOGIN
20: , STANDARD_VALUE_RULE_SET_ID
21: , ATTRIBUTE_ID
22: , SEQUENCE_NUMBER
23: , STANDARD_VALUE_SOURCE_ID
24: , ATTRIBUTE_VALUE
25: , OVERRIDE_ALLOWED_FLAG
26: , OVERRIDE_EXISTING_VALUE_FLAG
27: )

Line 28: SELECT SO_STANDARD_VALUE_RULES_S.NEXTVAL

24: , ATTRIBUTE_VALUE
25: , OVERRIDE_ALLOWED_FLAG
26: , OVERRIDE_EXISTING_VALUE_FLAG
27: )
28: SELECT SO_STANDARD_VALUE_RULES_S.NEXTVAL
29: , SYSDATE
30: , 1
31: , SYSDATE
32: , 1

Line 37: , STANDARD_VALUE_SOURCE_ID

33: , NULL
34: , destination_id
35: , ATTRIBUTE_ID
36: , SEQUENCE_NUMBER
37: , STANDARD_VALUE_SOURCE_ID
38: , ATTRIBUTE_VALUE
39: , OVERRIDE_ALLOWED_FLAG
40: , OVERRIDE_EXISTING_VALUE_FLAG
41: FROM SO_STANDARD_VALUE_RULES OESRC

Line 41: FROM SO_STANDARD_VALUE_RULES OESRC

37: , STANDARD_VALUE_SOURCE_ID
38: , ATTRIBUTE_VALUE
39: , OVERRIDE_ALLOWED_FLAG
40: , OVERRIDE_EXISTING_VALUE_FLAG
41: FROM SO_STANDARD_VALUE_RULES OESRC
42: WHERE STANDARD_VALUE_RULE_SET_ID = source_id
43: AND NOT EXISTS (
44: SELECT NULL
45: FROM SO_STANDARD_VALUE_RULES OEDST

Line 42: WHERE STANDARD_VALUE_RULE_SET_ID = source_id

38: , ATTRIBUTE_VALUE
39: , OVERRIDE_ALLOWED_FLAG
40: , OVERRIDE_EXISTING_VALUE_FLAG
41: FROM SO_STANDARD_VALUE_RULES OESRC
42: WHERE STANDARD_VALUE_RULE_SET_ID = source_id
43: AND NOT EXISTS (
44: SELECT NULL
45: FROM SO_STANDARD_VALUE_RULES OEDST
46: WHERE OEDST.STANDARD_VALUE_RULE_SET_ID = destination_id

Line 45: FROM SO_STANDARD_VALUE_RULES OEDST

41: FROM SO_STANDARD_VALUE_RULES OESRC
42: WHERE STANDARD_VALUE_RULE_SET_ID = source_id
43: AND NOT EXISTS (
44: SELECT NULL
45: FROM SO_STANDARD_VALUE_RULES OEDST
46: WHERE OEDST.STANDARD_VALUE_RULE_SET_ID = destination_id
47: AND OEDST.ATTRIBUTE_ID = OESRC.ATTRIBUTE_ID
48: AND OEDST.STANDARD_VALUE_SOURCE_ID =
49: OESRC.STANDARD_VALUE_SOURCE_ID);

Line 46: WHERE OEDST.STANDARD_VALUE_RULE_SET_ID = destination_id

42: WHERE STANDARD_VALUE_RULE_SET_ID = source_id
43: AND NOT EXISTS (
44: SELECT NULL
45: FROM SO_STANDARD_VALUE_RULES OEDST
46: WHERE OEDST.STANDARD_VALUE_RULE_SET_ID = destination_id
47: AND OEDST.ATTRIBUTE_ID = OESRC.ATTRIBUTE_ID
48: AND OEDST.STANDARD_VALUE_SOURCE_ID =
49: OESRC.STANDARD_VALUE_SOURCE_ID);
50:

Line 48: AND OEDST.STANDARD_VALUE_SOURCE_ID =

44: SELECT NULL
45: FROM SO_STANDARD_VALUE_RULES OEDST
46: WHERE OEDST.STANDARD_VALUE_RULE_SET_ID = destination_id
47: AND OEDST.ATTRIBUTE_ID = OESRC.ATTRIBUTE_ID
48: AND OEDST.STANDARD_VALUE_SOURCE_ID =
49: OESRC.STANDARD_VALUE_SOURCE_ID);
50:
51: return_status := 0; -- success
52: msg_text := 'OEXCPORD:' || 'success';

Line 49: OESRC.STANDARD_VALUE_SOURCE_ID);

45: FROM SO_STANDARD_VALUE_RULES OEDST
46: WHERE OEDST.STANDARD_VALUE_RULE_SET_ID = destination_id
47: AND OEDST.ATTRIBUTE_ID = OESRC.ATTRIBUTE_ID
48: AND OEDST.STANDARD_VALUE_SOURCE_ID =
49: OESRC.STANDARD_VALUE_SOURCE_ID);
50:
51: return_status := 0; -- success
52: msg_text := 'OEXCPORD:' || 'success';
53: