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.WSH_ITM_CUSTOMIZE dependencies on WSH_ITM_QUERY_CUSTOM

Line 21: PROCEDURE ALTER_ITEM_SYNC(p_Table IN OUT NOCOPY WSH_ITM_QUERY_CUSTOM.g_CondnValTableType) IS

17: | |
18: +===========================================================================*/
19:
20:
21: PROCEDURE ALTER_ITEM_SYNC(p_Table IN OUT NOCOPY WSH_ITM_QUERY_CUSTOM.g_CondnValTableType) IS
22: l_Item_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
23:
24: --
25: l_debug_on BOOLEAN;

Line 22: l_Item_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

18: +===========================================================================*/
19:
20:
21: PROCEDURE ALTER_ITEM_SYNC(p_Table IN OUT NOCOPY WSH_ITM_QUERY_CUSTOM.g_CondnValTableType) IS
22: l_Item_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
23:
24: --
25: l_debug_on BOOLEAN;
26: --

Line 49: --WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(p_Table, ' AND B.ORG_ID = :b_org_id', l_Item_Condn1Tab, 'NUMBER');

45: NULL;
46: --Adding a Condition
47: --l_Item_Condn1Tab(1).g_number_val := 1;
48: --l_Item_Condn1Tab(1).g_Bind_Literal := ':b_org_id';
49: --WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(p_Table, ' AND B.ORG_ID = :b_org_id', l_Item_Condn1Tab, 'NUMBER');
50:
51: --Editing a Condition
52: --l_Item_Condn1Tab(1).g_number_val := 208;
53: --WSH_ITM_QUERY_CUSTOM.EDIT_CONDITION(p_Table,' AND B.ORG_ID = :b_org_id', ' AND B.ORG_ID = :b_org_id', l_Item_Condn1Tab, 'NUMBER');

Line 53: --WSH_ITM_QUERY_CUSTOM.EDIT_CONDITION(p_Table,' AND B.ORG_ID = :b_org_id', ' AND B.ORG_ID = :b_org_id', l_Item_Condn1Tab, 'NUMBER');

49: --WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(p_Table, ' AND B.ORG_ID = :b_org_id', l_Item_Condn1Tab, 'NUMBER');
50:
51: --Editing a Condition
52: --l_Item_Condn1Tab(1).g_number_val := 208;
53: --WSH_ITM_QUERY_CUSTOM.EDIT_CONDITION(p_Table,' AND B.ORG_ID = :b_org_id', ' AND B.ORG_ID = :b_org_id', l_Item_Condn1Tab, 'NUMBER');
54:
55: --Deleting a Condition
56: --WSH_ITM_QUERY_CUSTOM.DEL_CONDITION(p_Table, ' AND B.ORG_ID = :b_org_id');
57: --

Line 56: --WSH_ITM_QUERY_CUSTOM.DEL_CONDITION(p_Table, ' AND B.ORG_ID = :b_org_id');

52: --l_Item_Condn1Tab(1).g_number_val := 208;
53: --WSH_ITM_QUERY_CUSTOM.EDIT_CONDITION(p_Table,' AND B.ORG_ID = :b_org_id', ' AND B.ORG_ID = :b_org_id', l_Item_Condn1Tab, 'NUMBER');
54:
55: --Deleting a Condition
56: --WSH_ITM_QUERY_CUSTOM.DEL_CONDITION(p_Table, ' AND B.ORG_ID = :b_org_id');
57: --
58: -- Debug Statements
59: --
60: IF l_debug_on THEN

Line 79: PROCEDURE ALTER_PARTY_SYNC(p_Table IN OUT NOCOPY WSH_ITM_QUERY_CUSTOM.g_CondnValTableType) IS

75: | procedure. |
76: | |
77: +===========================================================================*/
78:
79: PROCEDURE ALTER_PARTY_SYNC(p_Table IN OUT NOCOPY WSH_ITM_QUERY_CUSTOM.g_CondnValTableType) IS
80:
81: --
82: l_debug_on BOOLEAN;
83: --

Line 121: PROCEDURE ALTER_DELIVERY_MARK (p_Table IN OUT NOCOPY WSH_ITM_QUERY_CUSTOM.g_CondnValTableType,

117: -- specify the deliveries that require ITM compliance screening by
118: -- appending filter conditions.
119:
120:
121: PROCEDURE ALTER_DELIVERY_MARK (p_Table IN OUT NOCOPY WSH_ITM_QUERY_CUSTOM.g_CondnValTableType,
122: x_return_status OUT NOCOPY VARCHAR2) IS
123:
124: l_Item_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
125: --

Line 124: l_Item_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

120:
121: PROCEDURE ALTER_DELIVERY_MARK (p_Table IN OUT NOCOPY WSH_ITM_QUERY_CUSTOM.g_CondnValTableType,
122: x_return_status OUT NOCOPY VARCHAR2) IS
123:
124: l_Item_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
125: --
126: l_debug_on BOOLEAN;
127: --
128: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'ALTER_DELIVERY_MARK';

Line 151: --WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(p_Table, ' AND WND.ORGANIZATION_ID = :b_org_id', l_Item_Condn1Tab, 'NUMBER');

147:
148: --Adding a Condition
149: --l_Item_Condn1Tab(1).g_number_val := 1;
150: --l_Item_Condn1Tab(1).g_Bind_Literal := ':b_org_id';
151: --WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(p_Table, ' AND WND.ORGANIZATION_ID = :b_org_id', l_Item_Condn1Tab, 'NUMBER');
152:
153: --Editing a Condition
154: --l_Item_Condn1Tab(1).g_number_val := 208;
155: --WSH_ITM_QUERY_CUSTOM.EDIT_CONDITION(p_Table,' AND WND.ORGANIZATION_ID = :b_org_id', ' AND WND.ORG_ID = :b_org_id', l_Item_Condn1Tab, 'NUMBER');

Line 155: --WSH_ITM_QUERY_CUSTOM.EDIT_CONDITION(p_Table,' AND WND.ORGANIZATION_ID = :b_org_id', ' AND WND.ORG_ID = :b_org_id', l_Item_Condn1Tab, 'NUMBER');

151: --WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(p_Table, ' AND WND.ORGANIZATION_ID = :b_org_id', l_Item_Condn1Tab, 'NUMBER');
152:
153: --Editing a Condition
154: --l_Item_Condn1Tab(1).g_number_val := 208;
155: --WSH_ITM_QUERY_CUSTOM.EDIT_CONDITION(p_Table,' AND WND.ORGANIZATION_ID = :b_org_id', ' AND WND.ORG_ID = :b_org_id', l_Item_Condn1Tab, 'NUMBER');
156: --Deleting a Condition
157: --WSH_ITM_QUERY_CUSTOM.DEL_CONDITION(p_Table, ' AND WND.ORGANIZATION_ID = :b_org_id');
158:
159: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 157: --WSH_ITM_QUERY_CUSTOM.DEL_CONDITION(p_Table, ' AND WND.ORGANIZATION_ID = :b_org_id');

153: --Editing a Condition
154: --l_Item_Condn1Tab(1).g_number_val := 208;
155: --WSH_ITM_QUERY_CUSTOM.EDIT_CONDITION(p_Table,' AND WND.ORGANIZATION_ID = :b_org_id', ' AND WND.ORG_ID = :b_org_id', l_Item_Condn1Tab, 'NUMBER');
156: --Deleting a Condition
157: --WSH_ITM_QUERY_CUSTOM.DEL_CONDITION(p_Table, ' AND WND.ORGANIZATION_ID = :b_org_id');
158:
159: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
160:
161: IF l_debug_on THEN