[Home] [Help]
1886: SELECT decode(p_cust_account_rec.ship_sets_include_lines_flag,p_cust_account_rec.arrivalsets_include_lines_flag,
1887: 'N',l_arrivalsets_inc_lines_f,
1888: decode(p_cust_account_rec.arrivalsets_include_lines_flag,l_ship_sets_inc_lines_f, 'Y','N'),'Y')
1889: INTO l_dummy
1890: FROM DUAL;
1891: IF l_dummy <> 'Y'
1892: THEN
1893: FND_MESSAGE.SET_NAME('AR','HZ_API_VAL_DEP_FIELDS');
1894: FND_MESSAGE.SET_TOKEN('COLUMN1','ship_sets_include_lines_flag');
1975: 'N',l_ship_sets_inc_lines_f,
1976: decode(p_cust_account_rec.ship_sets_include_lines_flag,l_arrivalsets_inc_lines_f,
1977: 'Y','N'),'Y')
1978: INTO l_dummy
1979: FROM DUAL;
1980: IF l_dummy <> 'Y'
1981: THEN
1982: FND_MESSAGE.SET_NAME('AR','HZ_API_VAL_DEP_FIELDS');
1983: FND_MESSAGE.SET_TOKEN('COLUMN1','arrivalsets_include_lines_flag');
8071: AND site.org_id = p_cust_site_use_rec.org_id -- Bug 3456489
8072: AND su.org_id = p_cust_site_use_rec.org_id -- Bug 3456489
8073: AND site.CUST_ACCOUNT_ID IN (
8074: SELECT l_cust_account_id
8075: FROM DUAL
8076: UNION
8077: SELECT CUST_ACCOUNT_ID
8078: FROM HZ_CUST_ACCT_RELATE_ALL
8079: WHERE RELATED_CUST_ACCOUNT_ID = l_cust_account_id
8454: 'N',l_arrivalsets_inc_lines_f,
8455: decode(p_cust_site_use_rec.arrivalsets_include_lines_flag,l_ship_sets_inc_lines_f,
8456: 'Y','N'),'Y')
8457: INTO l_dummy
8458: FROM DUAL;
8459: IF l_dummy <> 'Y'
8460: THEN
8461: FND_MESSAGE.SET_NAME('AR','HZ_API_VAL_DEP_FIELDS');
8462: FND_MESSAGE.SET_TOKEN('COLUMN1','ship_sets_include_lines_flag');
8523: 'N',l_ship_sets_inc_lines_f,
8524: decode(p_cust_site_use_rec.ship_sets_include_lines_flag,l_arrivalsets_inc_lines_f,
8525: 'Y','N'),'Y')
8526: INTO l_dummy
8527: FROM DUAL;
8528: IF l_dummy <> 'Y'
8529: THEN
8530: FND_MESSAGE.SET_NAME('AR','HZ_API_VAL_DEP_FIELDS');
8531: FND_MESSAGE.SET_TOKEN('COLUMN1','arrivalsets_include_lines_flag');